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

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 is sysrouted FROM one or more of the following:

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

Fix information

Applicable component levels