RS03824: DECISION CENTER INSTALLATION WIZARD DOES NOT DETECT DB-SCHEMA CREATED USING SYNONYMS

21.0.2-WS-CP4BA-IF003
21.0.1-WS-CP4BA-IF005
Operational Decision Manager V8.10.5.1: Interim Fix 4 for Decision Center

APAR status

• Closed as program error.

Error description

• The issue occurs whenever:
  1) the database tables have been created using a given database
  user,
  
  2) and the datasource is configured to connect to the database
  with a different user, and some synonyms are used to reference
  the tables created using the other user.
  
  In this case, decision center fails to detect the database
  schema because it does not look for synonyms.
  As a result the installation wizard is opened each time a user
  logs in the Enterprise console and the database schema cannot be
  used as expected.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Decision Center administrators  using database synonyms      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Decison Center does not search synomyms to find existing     *
  * tables and therefore may declare a repository not ready to   *
  * use.                                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• the code is fixed to accept database synonyms
  

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

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels