PM79514: SQL OBJECT ADDED TO REPORT HAS WITH CLAUSE STATEMENT AND THROWS ORA-32034: UNSUPPORTED USE OF WITH CLAUSE

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • Client uses pass-through SQL as FM models cannot interpret SQL
    syntax they use in some instances, specifically to this PMR it
    is the "with" clause. When client sets up SQL object in Report
    Studio they get an error stating that With clause is unsupported
    with Oracle DB. Client states that they are setting this up as
    they would in 10.1.1 but in 10.2 they get this error. Client has
    determined that issue is with Cognos appending with clause to
    SQL object unless the property, Use SQL With Clause, under Query
    Hints, is set to NO. Prior versions NO was default.
    

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 IBM Cognos Business Intelligence 10.2 Fix Pack 2          *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM79514

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    841

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-19

  • Closed date

    2014-03-31

  • Last modified date

    2014-03-31

  • 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

  • RA20 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Business Intelligence
Report Studio

Software version:

8.4.1

Reference #:

PM79514

Modified date:

2014-03-31

Translate my page

Machine Translation

Content navigation