Article - CS375477
WebUI fails to load due Oracle error ORA-00001: unique constraint in Servigistics
Modified: 20-Aug-2025
Applies To
- Servigistics Service Parts Management 12.2.1.1 to 13.0.1.5
Description
- WebUI fails to start due to Oracle error :
ORA-00001: unique constraint
- WebUI.log contains:
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'applicationInitializer': Invocation of init method failed; nested exception is org.springframework.dao.DuplicateKeyException: StatementCallback; SQL [insert into IPCSCUST_VENDOR_LOC_SKU_LT (LOCID, ORDERTYPEID, PARTID, TRANSPORTMODEID, VENDORLOCID ) select s.LOCID, s.ORDERTYPEID, s.PARTID, s.TRANSPORTMODEID, s.VENDORLOCID from IPCS_VENDOR_LOC_SKU_LT s where not exists (select 1 from IPCSCUST_VENDOR_LOC_SKU_LT where LOCID = s.LOCID and ORDERTYPEID = s.ORDERTYPEID and PARTID = s.PARTID and TRANSPORTMODEID = s.TRANSPORTMODEID and VENDORLOCID = s.VENDORLOCID)]; ORA-00001: unique constraint (SVGSPM.SYS_C00571139) violated; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SVGSPM.SYS_C00571139) violated
This is a printer-friendly version of Article 375477 and may be out of date. For the latest version click CS375477