IBM Support

PI41144: IN PREDICATE WITH ROW VALUE CONSTRUCTOR NOT PUSHED TO ORACLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using a row value constructor against an Oracle database
    the IN predicate is not getting pushed into the Native SQL. This
    causes split SQL down on the database and performance is
    affected
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * see error description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
    * 8                                                            *
    ****************************************************************
    

Problem conclusion

  • code fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI41144

  • Reported component name

    COG ADMINISTRAT

  • Reported component ID

    5724W12AD

  • Reported release

    A21

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-05-14

  • Closed date

    2015-07-31

  • Last modified date

    2015-07-31

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

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

    PI41490 PI41494

Fix information

  • Fixed component name

    COG ADMINISTRAT

  • Fixed component ID

    5724W12AD

Applicable component levels

  • RA21 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
06 March 2023