Technote (troubleshooting)
Problem(Abstract)
Trying to insert a new ALN Domain and a duplicate key or unique constraint error occurs
Symptom
BMXAA4211E - Database error number 2601 has occurred when operating on
ALNDOMAIN Domain=XYZ Value=TEST Site= Organization=.
[MAXPROD]Cannot insert duplicate key row in object 'dbo.alndomain' with
unique index 'alndomain_ndx'.
Cause
When trying to add the new ALNDOMAIN Value The ALNDOMAINID is already in use. The problem may be due to inserting data through the back end and copying values from maxsquence incorrectly.
Resolving the problem
Run the following statement:
update maxsequence set maxreserved = (select max(ALNDOMAINID)+1 from
ALNDOMAIN) where tbname = 'ALNDOMAIN' and name = 'ALNDOMAINID'
You will then need to restart the Maximo Application server for it to
pick up the change. Then you will be able to enter the ALN domain .
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.