JR61161: COLUMN VALUES ARE MISSING FROM THE RESULTS WHEN THERE ARE DUPLICATE COLUMN NAMES OR COMPUTED COLUMNS

workflow.19002.delta.repository

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