Scenario: User is running a Automic script object which saves some data in a VARA.xml with Oracle DB at the backend - This script runs into a ORA-01461 error which results in a FATAL DB ERROR causing the DB to disconnect.
Error from the log:
U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
U00003592 UCUDB - Status: '' Native error: '1461' Msg: 'ORA-01461: can bind a LONG value only for insert into a LONG column'
U00003536 UCUDB: FATAL DATA BASE ERROR: Re-connection will be attempted in 10 seconds.
U00003538 UCUDB: Re-connection to database successful. Processing will continue.
U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
Expected Behavior: When this can result in a script execution failure - This should not cause the database error.
Database Platform: Oracle
Restriction: With an Oracle database, the attribute values of XML data should not contain more than 4000 characters.