In IBM BAW version 23.0.1, I am using a Linked Service Flow to retrieve data from a database via the "SQL Execute Statement" service, which is part of the System Data 8.6.0.0_TC toolkit.

The SQL query executes successfully when run directly in SQL Developer. In the service flow, I've provided the required input mappings, including the sqlQuery, dataSource, returnType (set to NameValuePair), and results.

While the service flow executes without errors and returns a results array, the array contains empty records.

I have attached screenshots of the variable definitions, and the SQL Execute Statement data mappings for reference.

Could you please help identify what might be causing this issue?

Hi Hari,

Kindly make sure that your query columns alias include same property keys
eg: ( Select ID as value, Item_EN as name from test_tbl  )

Also in the mapping  of "maxRows" provide value "-1"

------------------------------
Mohammed Shaker
IBM BPM Consaultant
Valleysoft
Nasr City
01007073310
------------------------------

I am using the below query which as name and value columns.

SELECT DISTINCT COUNTRY as value, COUNTRY as name from BAW_COUNTRY

Still, I am getting the empty values.

what are the query results from DB Engine Side, 

Also add mapping of "maxRows" to "-1"
Also can you try on evaluator this "tw.local.results" without double quotes to see xml representation of this output variable.

Hi Mohammed Shaker, Although the data section displays an empty list, I was able to view the XML in the Evaluator Results section. Thank you for clarifying the issue.