IBM Support

dbchange#ScriptFailure; scriptrun#UniqueKey MAXPROP_NDX1

Troubleshooting


Problem

Upgrade 6.2.8 to 7.1.1.11 fails in Update script V7110_211.

Symptom

A the end of the UpdateDB log:
dbchange#ScriptFailure; scriptrun#UniqueKey MAXPROP_NDX1 MAXPROP
PROPNAME; ORA-00001: unique constraint (MAXIMO.MAXPROP_NDX1) violated

Cause

Script V7110_211 adds property 'mxe.LDAPUserMgmt' to tables MaxProp and MaxPropValue. It is possible that this property already exists in your database.

Diagnosing The Problem

Execute the following two SQL queries. If one or both returns a row of data, then property 'mxe.LDAPUserMgmt already exists in the database system properties and this is the reason that the upgrade failed.

Select * From maxprop Where varname=''mxe.LDAPUserMgmt'

Select * From maxpropvalue Where varname=''mxe.LDAPUserMgmt'

Resolving The Problem

To resolve the error, restore the database to its state after the upgrade completed and before running UpdateDB. Drop the existing properties using these two SQL statements, the run updatedb.bat again.

Delete From maxprop Where propname=''mxe.LDAPUserMgmt' ;

Delete From maxpropvalue Where propname=''mxe.LDAPUserMgmt' ;

If you did make a backup of your database after completing the upgrade utility and before running UpdateDB, then you should:

- restore the database to 6.2.8

- delete the existing properties using the above SQL statements

- start the 6.2.8 to 7.1 upgrade process over again

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"6.2.8;7.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKTY","label":"Maximo Asset Management for IT"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSKTXT","label":"Tivoli Change and Configuration Management Database"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6HJK","label":"Tivoli Service Request Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21645113

Page Feedback