SCCD:ITIC -Unique Constraint Violation during mapping execution

Technote (troubleshooting)


Problem(Abstract)

SCCD:ITIC-Unique Constraint Violation during mapping execution

Symptom

ITIC execution fails and the following error is recorded in fusion.log

Error Message: Insert, update, or delete query failed
ORA-00001: unique constraint
(MCTESTA3.DPASOFTWARE_NDX4) violated

java.sql.SQLException: ORA-00001: unique constraint
(MCTESTA3.DPASOFTWARE_NDX4) violated


Resolving the problem

If customer ran multiple imports at the same time ,it has done the damage, the sequences are out of order now, at least DPASOFTWARESEQ.
To fix it the following steps need to be done:

1. Run this query (all queries must be executed on TAMIT DB)

select max(softwareid) + 100 from maximo.dpasoftware

Record the result1

2. Run this query

select maximo.dpasoftwareseq.nextval from dummy_table

Record the result2

3. Run this query

alter sequence maximo.dpasoftwareseq increment by NNN nocache

Where NNN = result1-result2

4. Run this query

select maximo.dpasoftwareseq.nextval from dummy_table

The result should be not less than result1

5. Run this query

alter sequence maximo.dpasoftwareseq increment by 1 nocache

Product Alias/Synonym

SCCD
ITIC
integration Composer

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Integration Composer

Software version:

All Versions

Operating system(s):

AIX, Linux, Windows

Reference #:

1640034

Modified date:

2014-05-07

Translate my page

Machine Translation

Content navigation