IJ46339: UPGRADE FAILS WITH BMXAA7968E A UNIQUE KEY ERROR WITH INDEX MAXLOOKUPMAP_NDX1

APAR status

• Closed as program error.

Error description

• During upgrade, updatedb raised error:
  
  commit
  ;
   false
   BEGINUPDATEDBERROR
   Product: IBM Maximo Asset Management Scheduler
   Error running script: HF7682_02
   UPDATEDBFILE: HF7682_02.dbc
   Script: Error
  rollback
  ;
  
  ERROR: BMXAA7025E  Script failed while running.;
  BMXAA8313E  A statement failed to execute inside a freeform
  statement. See the nested exception.;
  BMXAA7968E  A unique key error with index MAXLOOKUPMAP_NDX1 is
  defined on table maxlookupmap, columns (TARGET, LOOKUPATTR,
  TARGETATTR, SOURCE).;
  ORA-00001: unique constraint (MAXIMO.MAXLOOKUPMAP_NDX1) violated
  
  ;
  ORA-00001: unique constraint (MAXIMO.MAXLOOKUPMAP_NDX1) violated
  
     at psdi.dbmanage.ScriptRun(ScriptRun.java: 272)
     at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  514)
     at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  361)
     at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  313)
     at psdi.tools.RunScripts(RunScripts.java: 160)
     at psdi.tools.UpdateDB(UpdateDB.java: 3017)
     at psdi.tools.UpdateDB(UpdateDB.java: 4721)
     at psdi.tools.UpdateDB(UpdateDB.java: 6183)
     at psdi.tools.UpdateDB(UpdateDB.java: 323)
     at psdi.tools.UpdateDB(UpdateDB.java: 3452)
  Caused by: BMXAA8313E  A statement failed to execute inside a
  freeform statement. See the nested exception.;
  BMXAA7968E  A unique key error with index MAXLOOKUPMAP_NDX1 is
  defined on table maxlookupmap, columns (TARGET, LOOKUPATTR,
  TARGETATTR, SOURCE).;
  ORA-00001: unique constraint (MAXIMO.MAXLOOKUPMAP_NDX1) violated
  
  ;
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * UPGRADE FAILS WITH BMXAA7968E A UNIQUE KEY ERROR WITH INDEX  *
  * MAXLOOKUPMAP_NDX1                                            *
  ****************************************************************
  

Problem conclusion

• A fix for this APR will be included in a future release.
  

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

  UPGRADE PROGRAM

• Fixed component ID

  5724R46UP

Applicable component levels