Duplicate Key inserting ALNDOMAIN

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:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management
Domains

Software version:

Version Independent

Operating system(s):

Platform Independent

Reference #:

1622025

Modified date:

2014-12-08

Translate my page

Machine Translation

Content navigation