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

book

Article ID: 85115

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

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.

Investigation
 

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

Results

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

Expected:  The exported csv file should be displayed.

Cause

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

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