RS03693: UPDATING MODEL EXTENSIONS IS FAILING WHEN USING AN OLDER DATABASE SCHEMA

Operational Decision Manager V8.10.5.0: Interim Fix 12 for Decision Center
Operational Decision Manager V8.9.2.1: Interim Fix 34
IBM Operational Decision Manager V8.10.5 Download Document
IBM Operational Decision Manager V8.10.5 Refresh Pack

APAR status

• Closed as program error.

Error description

• Executing the script generated by Decition Center to update the
  extension model on a database schema version 8.8 with a more
  recent version of Decision Center throws errors on the update
  of the table VTRTSINFO.
  
  This error occurred as STARTID, ENDID,
  ORIGINALID, BASELINE referenced in the queries are not in the
  table.
  
  Error at Command Line : 102 Column : 25
  Error report
  -
  
  SQL Error: ORA-00904: "BASELINE": invalid identifier
  00904.
  00000 - "%s: invalid identifier"
  *Cause:
  *Action:
  
  The table
  VTRTSINFO should not be updated when updating the extension
  model.
  

Local fix

• Migrate database schema to 8.9 before trying to update model
  extensions.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Decision Center database administrators updating rule model  *
  * extensions                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Updating model extensions not handling custom classes        *
  * correctly.                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The code was 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

• R892 PSY

     UP