Unable to EXPORT a STORE object using the EXPORT script function

book

Article ID: 84918

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

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: ' '."

<Please see attached file for image>

0EMb0000001V2MK.png

Reference

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

 

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: ' '."

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.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).

Attachments

1558692719162000084918_sktwi1f5rjvs16ltf.png get_app