PM33519: A WRONG DATABASE CONNECTION IS ADDED TO THE PACKAGE CONNECTION INFORMATION IN A TRANSFORMER MODEL

APAR status

• Closed as program error.

Error description

• -In a Transformer Model a wrong database connection is added to
  the package connection information ( can be verified in the
  model under content store database tab)  in a transformer model
  when the database connection has more than one SignOn associated
  in Cognos Connection?This will lead to the
  error:?--------------------------------------------------------?
  example
  : ?Thu 09 Dec 2010 07:59:30        2       000000A5
  QE-DEF-0285 The logon failed.?Thu 09 Dec 2010 07:59:30        2
       000000A5        QE-DEF-0321 The userID or password is
  either missing or invalid.?Thu 09 Dec 2010 07:59:30        2
    000000A5        RQP-DEF-0068 Unable to connect to at least one
  database during a multi-database attach to 1 database(s) in:?Thu
  09 Dec 2010 07:59:30        2       000000A5
  DBCDX?Thu 09 Dec 2010 07:59:30        2       000000A5
  ?Thu 09 Dec 2010 07:59:30        2       000000A5
  UDA-SQL-0031 Unable to access the "DBCDX" database.?Thu 09 Dec
  2010 07:59:30        2       000000A5        UDA-SQL-0129
  Invalid login information was detected by the underlying
  database.?Thu 09 Dec 2010 07:59:30        2       000000A5
   [IBM][CLI Driver] SQL30082N  Security processing failed with
  reason "3" ("PASSWORD MISSING").  SQLSTATE=08001?Thu 09 Dec 2010
  07:59:30        2       000000A5       ?Thu 09 Dec 2010 07:59:30
         4       000000A5
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1 Refresh     *
  * Pack 1 or Upgrade to IBM Cognos 8 Business Intelligence      *
  * 8.4.1 Fix Pack 4Upgrade to IBM Cognos TM1 10.1.0             *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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

• Fixed component name

  COG8 BI INST CO

• Fixed component ID

  5724W12IC

Applicable component levels

• RA11 PSN

     UP