ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

ARA Specific Export (via importexport-Webservice) resulting in SQL-statement instead of exported csv


Article ID: 85115


Updated On:


CA Automic Workload Automation - Automation Engine


Affects Release version(s): 7;8

Error Message :
Could not execute query [ SELECT TOP (@p0) this_.Id as Id13_1_, this_.ValueMode as ValueMode13_1_, this_.StaticValue as StaticVa3_13_1_, this_.ExpressionValue as Expressi4_13_1_

Specific Export (via importexport-Webservice) results in SQL-statement similar to the one above instead of an exported csv file.


  1. Create an application workflow and a dynamic property that gets prompted on execution 
  2. Start the workflow and enter any value 
  3. Identify the system_id for this execution, e.g. by exporting the following: 

.\ImportExportCLI.exe export -usr <usr> -con <url> -mt Execution -pwd <pass> -format csv 

and identifying "your" execution id 

  1. Invoke

ImportExportCLI.exe export -usr <usr> -con <url> -mt DynamicProperty -pwd <pass> -format csv -properties "system_parent_entity.system_id" -where "system_parent_entity.system_id eq '16022'"


Actual: The SQL statement is displayed instead of the exported csv file.

Expected:  The exported csv file should be displayed.


Cause type:
Root Cause: Error when exporting dynamic properties with a condition on system_parent_entity.system_id


OS Version: N/A


Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Release Manager 8.0.0 - Available
Release Manager 7.0.3 - Available

Additional Information

Workaround :
Use a condition on system_parent_entity.system_name instead.