IBM Support

PH10513: COMMAND BLOCK TO SET ORACLE PROXY USER DOES NOT WORK WHEN LOADING A SCHEMA

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • A data source is configured against Oracle, and a session
    command block is added using the <argument> element to specify
    the OCI_ATTR_USERNAME property.  This works for a CQM connection
    and FM package.  When configuring a JDBC Type 2 connection (OCI
    thick client) or Type 2 (thin client) and attempting to load
    metadata for a schema, the
    metadata load request ignores the command block, which may cause
    an incorrect set of tables to be loaded or an error message if
    the user in the Signon does not have access to the same set of
    tables as the user specified in the command block.  An error may
    be thrown like MSR-GEN-0026 The schema "SCHEMA_NAME" is either
    empty, or not accessible using the current signon.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Analytics 11.1.3                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH10513

  • Reported component name

    COG MODELING

  • Reported component ID

    5724W12MO

  • Reported release

    B0A

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-04-02

  • Closed date

    2019-07-09

  • Last modified date

    2019-07-09

  • 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



Document information

More support for: Cognos Analytics
Cognos Modeling v11x

Software version: B0A

Reference #: PH10513

Modified date: 09 July 2019