Unable to EXPORT a STORE object using the EXPORT script function

Document ID : KB000084918
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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 &OBJEKT# = "STORE.JOK"
: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:

 
"U00003521 UCUDB: SQL Stmnt is not zero terminated: ' '."

0EMb0000001V2MK.png

Reference

Automic Workload Automation 12.0 Documentation:
Automation Engine Script Guide > Ordered by Function > Handle Objects > EXPORT

 
Environment:
OS Version: N/A
Cause:
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: ' '."
Resolution:
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
Additional Information:
Workaround :
Export the store object manually via the Automic Web Interface (AWI) or the JAVA User Interface (UI).