RS03606: RUNNING PROGRESSIVE MIGRATION SCRIPT THROWS AN SQLEXCEPTION ABOUT INVALID FOREIGN KEY

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.10.2.2: Interim Fix 1
Operational Decision Manager V8.9.2.1: Interim Fix 30
Operational Decision Manager V8.9.2.1: Interim Fix 31
Operational Decision Manager V8.10.2.2 Interim Fix 6 for Decision Center
Operational Decision Manager V8.9.2.1: Interim Fix 34

APAR status

• Closed as program error.

Error description

• Running progressive migration script throws following error
  :
  
  ALTER TABLE ILOG89.BASELINE ADD CONSTRAINT BSLN_PARENT
  FOREIGN KEY (PARENT) REFERENCES ILOG89.BASELINE ON DELETE
  CASCADE
  DB21034E The command was processed as an SQL statement
  because it was not a
  valid Command Line Processor command.
  During SQL processing it returned:
  SQL0667N The FOREIGN KEY
  "BSLN_PARENT" cannot be created because the table
  contains
  rows with foreign key values that cannot be found in the parent
  key
  of the parent table. SQLSTATE=23520
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users running progressive migration script.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Running progressive migration script throws following error  *
  * :                                                            *
  *                                                              *
  * ALTER TABLE ILOG89.BASELINE ADD CONSTRAINT BSLN_PARENT       *
  * FOREIGN KEY (PARENT) REFERENCES ILOG89.BASELINE ON DELETE    *
  * CASCADE                                                      *
  * DB21034E The command was processed as an SQL statement       *
  * because it was not a                                         *
  * valid Command Line Processor command. During SQL processing  *
  * it returned:                                                 *
  * SQL0667N The FOREIGN KEY "BSLN_PARENT" cannot be created     *
  * because the table                                            *
  * contains rows with foreign key values that cannot be found   *
  * in the parent key                                            *
  * of the parent table. SQLSTATE=23520                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The script is 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