PUT_ATT OPERATOR "COINTAINS" in DB-EVENT script results in U00020862 error
Error Message :
U00020862 Value ' ' for 'EVNT' is invalid. Permitted values: 'OPERATOR'.
When using the :PUT_ATT script statement with a the value CONTAINS in a DB Event the above error message is displayed and the Job terminates with a FAULT_OTHER status.
Investigation
Create a DB Event, with the value CONTAINS define with a variable in the process tab:
<Please see attached file for image>
Execute the Job.
Results
Expected: The Job should run to completion.
Reference
Automic Workload Automation 12.0 Documentation:
User Guide > Process Assembly Perspective > Defining Objects > Defining DB Event Objects
Cause type:
Defect
Root Cause: PUT_ATT and GET_ATT for DB-events does not work, if operator "CONTAINS" has been used. GET_ATT delivers BLANK and PUT_ATT results in a runtime error.
OS Version: N/A
Update to a fix version listed below or a newer version if available.
Fix Status: Released
Fix Version(s):
Automation Engine 12.1.0 - Available
Automation Engine 12.0.4 - Available
Automation Engine 11.2.6 - Available
Workaround :
Do not used PUT_ATT to set this attribute, instead use the operator definition directly in the object:
<Please see attached file for image>