IBM Support

PH05877: ERROR LOADING SCHEMAS FOR A SQL SERVER DATA SERVER CONNECTION WITH NATIVE KERBEROS SSO: MSR_GEN_0071

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • A SQL Server data server connection is created using Kerberos
    SSO.  Kerberos SSO is configured at the web server and the
    sqljdbc_auth.dll file for the SQL JDBC Driver's native
    integrated authentication is copied to the bin64 directory.  The
    connection tests fine, and when testing the login is made as the
    expected user.  When clicking on the Schemas tab for the same
    connection, Cognos attempts to connect to SQL Server as the
    account which runs the Cognos processes, instead of the user who
    logged in.  If this service user does not have access to the
    target database, an error is thrown: MSR_GEN_0071 Internal error
    getting catalogs and schemas for: "Data Server"
    

Local fix

  • Grant the service account which runs the Cognos service
    permission to access the target database, or configure a
    different authentication type for the data server, like a saved
    Signon
    

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

    PH05877

  • Reported component name

    COG ADMINISTRAT

  • Reported component ID

    5724W12AD

  • Reported release

    B0A

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-11-28

  • 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
Administration and Configuration v11x

Software version: B0A

Reference #: PH05877

Modified date: 09 July 2019