RS03702: DC DATABASE MIGRATED FROM ORACLE 12C.1 CAN'T BE USED FOR ORACLE 12C.2

Operational Decision Manager V8.8.1.4: Interim Fix 13 for Decision Center
Operational Decision Manager V8.9.2.2: Interim Fix 16 for Decision Center

APAR status

• Closed as program error.

Error description

• Oracle 12c.1 has a column name limit of 32 bytes. Therefore all
  the table column names have been truncated to 32 chars in
  12c.1. But 12c.2 has a column name limit of 128 bytes, so the
  DC query is dynamically generated for the full column names for
  a database that has a truncated to 32 char repository, causing
  "invalid column name" error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users migration from Oracle 12.1 to a more recent Oracle     *
  * version.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Oracle 12c.1 has a column name limit of 32 bytes. Therefore  *
  * all                                                          *
  * the table column names have been truncated to 32 chars in    *
  * 12c.1. But 12c.2 has a column name limit of 128 bytes, so    *
  * the                                                          *
  * DC query is dynamically generated for the full column names  *
  * for                                                          *
  * a database that has a truncated to 32 char repository,       *
  * causing                                                      *
  * "invalid column name" error.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The column name has been fixed.
  

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

• R881 PSY

     UP