Troubleshooting
Problem
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 Synonym
SCCD;ITIC;integration Composer
Was this topic helpful?
Document Information
Modified date:
27 February 2019
UID
swg21640034