Unable to EXPORT a STORE object using the EXPORT script function
Error Message :
"U00003521 UCUDB: SQL Stmnt is not zero terminated: ' '."
When attempting to export a STORE object using the EXPORT script function it fails. The task hangs in a status of Generating and the above error message is displayed.
Investigation
Using an example from the documentation to EXPORT a STORE object it would look similar to this:
:SET &DATEI# = "C:\Temp\JOK_DESTINATION\INC00135270.xml"
:SET &RET# = EXPORT(&OBJEKT#,&DATEI#)
Results
Expected: The job should run to completion and the STORE object should be exported.
Actual: The job remains in the activity window in a status of Generating, and an error message appears in message window:
<Please see attached file for image>
Reference
Automic Workload Automation 12.0 Documentation:
Automation Engine Script Guide > Ordered by Function > Handle Objects > EXPORT
Cause type:
Defect
Root Cause: Unable to exporting a STORE object using a script command :export. The task hangs in a state of "generating" and an error message appears in the message window: "U00003521 UCUDB: SQL Stmnt is not zero terminated: ' '."
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.0.3 - Available
Automation Engine 11.2.6 – Available
Workaround :
Export the store object manually via the Automic Web Interface (AWI) or the JAVA User Interface (UI).