Direct link to fix
APAR status
Closed as program error.
Error description
In the following circumstances, some values may be missing in the resulting rows when you run an SQL statement by using the SQLConnector: -When the query refers to columns of the same name from different objects. -When the query has two or more computed columns and the database type is "SQL Server". PRODUCTS AFFECTED IBM Business Automation Workflow
Local fix
N/A
Problem summary
This issue occurs because the result set has two or more columns with the same name.
Problem conclusion
A fix will be included in a future release of Business Automation Workflow that ensures the rows show all the returned values. For each row, the SQL query also returns an object named "indexedMap" that associates each column name with its value in the row and, beside the list of rows, an object named "columnIndexes" that associates each column name with its index in the row. These objects have not changed. Don't use these objects if the query produces two or more columns with the same name.
Temporary fix
Comments
APAR Information
APAR number
JR61161
Reported component name
BPM
Reported component ID
5737A5700
Reported release
860
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-06-06
Closed date
2019-06-17
Last modified date
2019-06-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BPM
Fixed component ID
5737A5700
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFPJS","label":"IBM Business Process Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.6.0.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
14 September 2022