BMXAA4211E - Database error number -803 has occurred when operating on ASSET : Site=1111 Asset=2222.

Technote (troubleshooting)


Problem(Abstract)

Why would one receive a Database error number -803 , report the error to the owner of the deployment ?

Symptom

One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "20" constrains table "MAXIMO.ASSET" from having duplicate values for the index key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=3.53.70


Cause

This sequence error when receiving rotated assets often happens because the sequence generator appears to be out of sequence for MAXIMO.ASSET

Resolving the problem

1) Check if max(assetid) is greater than assetseq nextval:

You can check this by running the following 2 select statements:

select max(ASSETID) from MAXIMO.ASSET;

select (nextval for assetseq) from sysibm.sysdummy1;

2) If max(assetid) is greater than nextval for assetseq then increase the sequence value.

a) Alter the sequence. XXX is a number that is larger than a difference between max(ASSETID) and (nextval for assetseq).

alter sequence assetseq increment by XXX;

b. Select nextval. , keep the result.

select nextval for assetseq from sysibm.sysdummy1;

c. Select max(id). Make sure this value is smaller than the result of step b

select max(assetid) from maximo.asset;

d. Alter the sequence again.

alter sequence assetseq increment by 1;

e. Commit;

f. Try doing the same use case again and check whether the problem is fixed or not.


Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Tivoli Service Request Manager AIX, Linux, Solaris, Windows 2008 server 7.1, 7.1.2, 7.2, 7.2.1
Systems and Asset Management Tivoli Asset Management for IT AIX, HP-UX, Linux, Solaris, Windows 7.2, 7.2.1, 7.5
Systems and Asset Management IBM SmartCloud Control Desk AIX, HP-UX, Linux, Solaris, Windows
Systems and Asset Management Tivoli Change and Configuration Management Database AIX, Linux, Windows, Solaris, HP-UX 7.2, 7.2.1, 7.5

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Asset Management

Software version:

7.1, 7.1.1, 7.5

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1641478

Modified date:

2014-05-19

Translate my page

Machine Translation

Content navigation