PI75553: SCHEMA MISSING FOR AN UNSPECIFIED DATABASE NAME IN A SQL SERVER DATA SERVER CONNECTION TO COGNOS 11.0.5.

APAR status

• Closed as fixed if next.

Error description

• When connecting to a SQL Server data source using the data
  server connection option, without specifying the database name,
  the user is expecting to see all of the schema associated with
  the data server connection. The user can only see SQL Server's
  default database schema.
  
  The user should be seeing all schema associated with the data
  source connection when leaving the database name unspecified.
  

Local fix

• Change the database name in the data server connection instead
  of leaving it blank to see a specific schema
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytic 11.0.6.0                      *
  ****************************************************************
  

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

• RB00 PSN

     UP