RS03567: Progressive migration script is failing due to a missing key exception

Operational Decision Manager V8.9.2.1: Interim Fix 24
Operational Decision Manager for z/OS 8.10.2.2 Fix Pack
IBM Operational Decision Manager V8.10.2.2 Fix Pack
Operational Decision Manager V8.9.2.1: Interim Fix 26
Operational Decision Manager V8.9.2.1: Interim Fix 27
Operational Decision Manager V8.9.2.1: Interim Fix 28
IBM Operational Decision Manager V8.10.4 Download Document
IBM Operational Decision Manager V8.10.4 Mod Pack
IBM Operational Decision Manager for z/OS 8.10.4 Mod Pack
Operational Decision Manager V8.9.2.1: Interim Fix 30
Operational Decision Manager V8.9.2.1: Interim Fix 31
Operational Decision Manager V8.9.2.1: Interim Fix 34

APAR status

• Closed as program error.

Error description

• Running progressive migration script may fail while running this
  query :
  INSERT INTO ILOG89.VERSION (ID, MAJOR, MINOR, USERNAME,
  COMMENTAIRE, VERSDATE, ELTORIGINALID, type, DELETED, SYSVERS,
  PROJECT, BASELINE, MERGEDFROMBASELINE, MERGEDFROMVERSION) SELECT
  ID, MAJOR, MINOR, USERNAME, COMMENTAIRE, VERSDATE,
  ELTORIGINALID, type, DELETED, SYSVERS, PROJECT, BASELINE,
  MERGEDFROMBASELINE, MERGEDFROMVERSION FROM ILOG89.TMSRVR38114844
  
  The following error is raised :
  DB21034E The command was processed as an SQL statement because
  it was not a
  valid Command Line Processor command. During SQL processing it
  returned:
  SQL0530N The insert or update value of the FOREIGN KEY
  "ILOG89.VERSION.VERSION_BASELINE" is not equal to any value of
  the parent key
  of the parent table. SQLSTATE=23503
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Decision Center administrators running progressive migration *
  * script                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Missing key exception when running a specific query.         *
  ****************************************************************
  * 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

• R881 PSY

     UP