IBM Support

PM66162: NETEZZA (COGDMOD.INI) - NEED TO CHANGE THE DEFAULT DEFINITION FOR WITH CLAUSE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • In [C10.1.1 + Netezza Server v5.2] environment, the following
    error occurs in running the report.??---?UDA-QOS-0006
    UDA-SQL-0107 A general exception has occurred during the
    operation 'prepare'. Prepared statement not a cursor
    specification?---??Cognos does not specify a Netezza version in
    cogdmod.ini and passes WITH clause for all versions of Netezza
    by default, expect for those specified below.??---?[Exceptions
    Clauses DATABASE:NETEZZASQL VERSION:05.00]?With=??[Exceptions
    Clauses DATABASE:NETEZZASQL VERSION:04.00]?With=??[Exceptions
    Clauses DATABASE:NETEZZASQL VERSION:04.05]?With=??[Exceptions
    Clauses DATABASE:NETEZZASQL VERSION:04.06]?With=??[Exceptions
    Clauses DATABASE:NETEZZASQL VERSION:03]?With=?---??So, when
    running the report with this default cogdmod.ini, Cognos will
    pass WITH clause to Netezza DB 5.2 even if WITH clause is not
    supported in Netezza (Netezza supports WITH clause from v6).
    

Local fix

  • A simple fix is to change or add the definition, as below.
    
    (1) Change
    [Exceptions Clauses DATABASE:NETEZZASQL VERSION:05.00]
    With=
    ...to...
    [Exceptions Clauses DATABASE:NETEZZASQL VERSION:05]
    With=
    
    (2) Add
    [Exceptions Clauses DATABASE:NETEZZASQL VERSION:05.02]
    With=
    

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM66162

  • Reported component name

    COG8 BI REPORT

  • Reported component ID

    5724W12RS

  • Reported release

    A11

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-05

  • Closed date

    2013-06-11

  • Last modified date

    2013-06-11

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWW","label":"Report Authoring v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 June 2013