Article - CS356336
Unable to create Product from Season > Linesheet with error "java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DBADMIN.PK_WTACLENTRY) violated" after rehost in FlexPLM
Modified: 09-Nov-2021
Applies To
- FlexPLM 11.1 M010-CPS06
Description
- Unable to create product from Season > Linesheet with error "java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DBADMIN.PK_WTACLENTRY) violated" after rehost
- Below error is observed in the Method Server logs :
INFO [ajp-nio-127.0.0.1-8010-exec-8] wt.system.err wcadmin - wt.pom.UniquenessException: A datastore uniqueness constraint violation has occurred. INFO [ajp-nio-127.0.0.1-8010-exec-8] wt.system.err wcadmin - Nested exception is: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SchemaName.PK_WTACLENTRY) violated INFO [ajp-nio-127.0.0.1-8010-exec-8] wt.system.err wcadmin - ORA-06512: at "SchemaName.ADHOCACCESSPK", line 196 INFO [ajp-nio-127.0.0.1-8010-exec-8] wt.system.err wcadmin - ORA-06512: at line 1 INFO [ajp-nio-127.0.0.1-8010-exec-8] wt.system.err wcadmin - INFO [ajp-nio-127.0.0.1-8010-exec-8] wt.system.err wcadmin - at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) INFO [ajp-nio-127.0.0.1-8010-exec-8] wt.system.err wcadmin - at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
This is a printer-friendly version of Article 356336 and may be out of date. For the latest version click CS356336