DELETE_VAR on 4000+ char XML gives ORA-19011 error
Article ID: 88071
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Error Message :
ORA-19011: Character string buffer too small.
If the Automation Engine has an Oracle DB backend, when using the script command DELETE_VAR on an XML Variable of over 4000 characters, the command will fail and display the above error.
ORA-19011: Character string buffer too small.
If the Automation Engine has an Oracle DB backend, when using the script command DELETE_VAR on an XML Variable of over 4000 characters, the command will fail and display the above error.
Environment
OS Version: N/A
Cause
Cause type:
Defect
Root Cause: If you use the Automation Engine with an Oracle database, the attribute values of XML data used in this Variable object can't contain more than 4000 characters.
Defect
Root Cause: If you use the Automation Engine with an Oracle database, the attribute values of XML data used in this Variable object can't contain more than 4000 characters.
Resolution
Update to a fix version listed below or a newer version if available.
Fix Status: Released
Fix Version(s):
Automation Engine 12.0.2 - Available
Automation Engine 11.2.5 - Available
Fix Status: Released
Fix Version(s):
Automation Engine 12.0.2 - Available
Automation Engine 11.2.5 - Available
Additional Information
Workaround :
Delete from the XML Variable manually.
Delete from the XML Variable manually.
Feedback
Yes
No
Powered by
