DELETE_VAR on 4000+ char XML gives ORA-19011 error

book

Article ID: 88071

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

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.

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.

Environment

OS Version: N/A

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

Additional Information

Workaround :
Delete from the XML Variable manually.