U0020568 Runtime error in object 'xxxxx' when a Search for Use is done on a prompt object

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

U0020568 Runtime error in object 'xxxxx' when a Search for Use is done on a prompt object

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Symptoms

When a Search for Use is done on a prompt object, the following error message(s) pop up:  

U0020568 Runtime error in object 'XREPLACE_RENAME(ACT)', line '00095'. DS return code: '0000003590 DB error: 'OCIStmtExecute', 'ERROR ',*,

'ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4092, maximum: 4000)*. Error occurred in UCDSFUN at position: 'DS_SEARCH15'.

---

Cause

This is a bug that was observed in version 9. If an insert is done from a CLOB field to a CHAR field, the function to_Char is called on Oracle. This function can only handle < 4000 bytes.

---

Resolution

If the String that is searched for is more than 4000 characters long, an error like above is returned. This behavior has been fixed in Version 10. In previous versions, please use Strings that are less than 4000 characters long for the Search for Use.