PM92392: UDA-SQL-0191 ERROR WHEN USING FILE WITH EMPTY CELLS AT RUNTIME

APAR status

• Closed as unreproducible in next release.

Error description

• After publishing a package with external data, an user is
  running a report based on the external data namespace. When the
  file, he is selecting, contains an empty cell in the first row,
  the following error message is displayed:?RQP-DEF-0177 An error
  occurred while performing operation 'sqlPrepareWithOptions'
  status='-56'.?Details UDA-SQL-0191 The column "x" was not found
  in the table or view "file_name...file_name".
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 2                                                       *
  ****************************************************************
  

Problem conclusion

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

  COG REPORT STUD

• Fixed component ID

  5724W12RS

Applicable component levels

• RA22 PSN

     UP