IBM Support

Upgrade error BMXAA7968E MAXINTOBJCOLS_NDX1 V7601_37.dbc

Troubleshooting


Problem

Error during upgrade to version 7.6 BMXAA7968E -- A unique key error with index MAXINTOBJCOLS_NDX1 is defined on table maxintobjcols, columns (INTOBJECTNAME, OBJECTNAME, NAME, INTOBJFLDTYPE).;

Symptom

ERROR: DATABASE Script UPDATE COMPLETED WITH ERROR. CHECK ERRORS IN
UPDATE LOG FILE -Updatedbxxxxxxxxxxxxxx.log
dbchange#ScriptFailure
ERROR: BMXAA7025E -- Script failed while running.;
Caught SQL Exception;
BMXAA7968E -- A unique key error with index MAXINTOBJCOLS_NDX1 is
defined on table maxintobjcols, columns (INTOBJECTNAME, OBJECTNAME,
NAME, INTOBJFLDTYPE).;
One or more values in the INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid because
the primary key, unique constraint or unique index identified by "2"
constrains table "MAXIMO.MAXINTOBJCOLS" from having duplicate values
for the index key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=4.11.69
at psdi.dbmanage.ScriptRun(ScriptRun.java: 242)
at psdi.dbmanage.Utility(Utility.java: 284)
at psdi.tools.RunScripts(RunScripts.java: 609)
at psdi.tools.RunScripts(RunScripts.java: 598)
at psdi.tools.RunScripts(RunScripts.java: 192)
at psdi.tools.UpdateDB(UpdateDB.java: 2801)
at psdi.tools.UpdateDB(UpdateDB.java: 2738)
at psdi.tools.UpdateDB(UpdateDB.java: 2499)
at psdi.tools.UpdateDB(UpdateDB.java: 2212)
at psdi.tools.UpdateDB(UpdateDB.java: 5043)
at psdi.tools.UpdateDB(UpdateDB.java: 252)
at psdi.tools.UpdateDB(UpdateDB.java: 3131)
Caused by: Caught SQL Exception;
BMXAA7968E -- A unique key error with index MAXINTOBJCOLS_NDX1 is
defined on table maxintobjcols, columns (INTOBJECTNAME, OBJECTNAME,
NAME, INTOBJFLDTYPE).;
One or more values in the INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid because
the primary key, unique constraint or unique index identified by "2"
constrains table "MAXIMO.MAXINTOBJCOLS" from having duplicate values
for the index key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=4.11.69
at psdi.dbmanage.connection.DB2DatabaseConnection
(DB2DatabaseConnection.java: 466)
at psdi.dbmanage.connection.DB295DatabaseConnection
(DB295DatabaseConnection.java: 30)
at psdi.dbmanage.connection.DatabaseConnection(DatabaseConnection.
java: 567)
at psdi.dbmanage.statement.TempTableModel(TempTableModel.java: 413)
at psdi.dbmanage.statement.TempTableModel(TempTableModel.java: 394)
at psdi.dbmanage.statement.TempTableModel(TempTableModel.java: 479)
at psdi.dbmanage.statement.InsertSQLStatement(InsertSQLStatement.java:
403)
at psdi.dbmanage.statement.InsertSQLStatement(InsertSQLStatement.java:
183)
at psdi.dbmanage.statement.InsertSQLStatement(InsertSQLStatement.java:
387)
at psdi.dbmanage.statement.InsertSQLStatement(InsertSQLStatement.java:
531)
at psdi.dbmanage.statement.Script(Script.java: 309)
at psdi.dbmanage.statement.Script(Script.java: 293)
at psdi.dbmanage.ScriptRun(ScriptRun.java: 237)
at psdi.dbmanage.Utility(Utility.java: 284)
at psdi.tools.RunScripts(RunScripts.java: 609)

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
18 September 2025

UID

swg22001042

Page Feedback