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
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21645113