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

Document ID : KB000085115
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.

Environment:
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: Error when exporting dynamic properties with a condition on system_parent_entity.system_id
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.