PM85278: Run/validate report generates UDA-SQL-0358 after upgrade from IBM Cognos BI v10.1.1 to v10.2.0

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • A report with a crosstab is upgraded from IBM Cognos BI v10.1.1
    to v10.2.0. This report validates and runs without warnings in
    version 10.1.1. After the upgrade this report does not validate
    and run. This error message is thrown:??RQP-DEF-0177 An error
    occurred while performing operation 'sqlPrepareWithOptions'
    status='-16'.?UDA-SQL-0358 Line 27: Syntax error near
    "15.3".??Both IBM Cognos BI versions use the same OS, database
    and database client.
    

Local fix

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM85278

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    A20

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-21

  • Closed date

    2013-06-11

  • Last modified date

    2013-09-23

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • RA21 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Business Intelligence
Report Studio

Software version:

10.2

Reference #:

PM85278

Modified date:

2013-09-23

Translate my page

Machine Translation

Content navigation