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?

------------------------------
Hari Krishna
------------------------------

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

Original Message:
Sent: Sun April 06, 2025 12:09 AM
From: Hari Krishna
Subject: Issue with "SQL Execute Statement" in Linked Service Flow – BAW 23.0.1

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?

------------------------------
Hari Krishna
------------------------------

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.

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

Original Message:
Sent: Sun April 06, 2025 12:09 AM
From: Hari Krishna
Subject: Issue with "SQL Execute Statement" in Linked Service Flow – BAW 23.0.1

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?

------------------------------
Hari Krishna
------------------------------

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.

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.

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

Original Message:
Sent: Sun April 06, 2025 12:09 AM
From: Hari Krishna
Subject: Issue with "SQL Execute Statement" in Linked Service Flow – BAW 23.0.1

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?

------------------------------
Hari Krishna
------------------------------