Duplicate Key inserting ALNDOMAIN
Trying to insert a new ALN Domain and a duplicate key or unique constraint error occurs
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'.
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 .