search cancel

ORA-01461: can bind a LONG value only for insert into a LONG column

book

Article ID: 253944

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

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.

Environment

Release: 21.x

Component: Automation Engine

Database Platform: Oracle

Cause

  • The script failure happens if the data is more than 4000 characters when using Oracle DB - This restriction is by design  

         Restriction: With an Oracle database, the attribute values of XML data should not contain more than 4000 characters.

  • UCUDB: FATAL DATA BASE ERROR - This is identified as a bug 

Resolution

The issue has been confirmed to be a bug by our Dev team.

A fix will be provided in a future version.

Additional Information

Script Elements for XML VARA Objects