IBM Support

Duplicate Key inserting ALNDOMAIN

Technote (troubleshooting)


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 .

Document information

More support for: Maximo Asset Management

Software version: Version Independent

Operating system(s): Platform Independent

Reference #: 1622025

Modified date: 07 December 2015

Translate this page: