Article - CS375022
Error: "ORA-02437: cannot validate (SPM.IPCSTMP_G93313_PK) - primary key violated" running Gateway due to duplicate HostSalesOrderIDs in Servigistics
Modified: 10-Jul-2025
Applies To
- Servigistics Service Parts Management 12.2.1.0 to 13.1.0.5
Description
- Primary unique key on IPCS_SALES_ORDER is SalesOrderID (internally assigned number).
- Other indexes that are all non-unique are on HostSalesOrderID and (PartID, LocID, SalesOrderDueDt)
- Users are able to import a combination of HostPartID, HostLocID, SalesOrderDueDt with a given HostSalesOrderID.
- Then, in another run, import the same HostPartID, HostLocID, HostSalesOrderID, and a different SalesOrderDueDt.
- When Gateway runs importing system interfaced data, the SyncTable process finds the same HostOrderID assigned to different OrderIDs, which area also different combinations of PartID, LocID, SalesOrderDueDt. and Gateway fails with primary key violation on IPCSTMP_*
This is a printer-friendly version of Article 375022 and may be out of date. For the latest version click CS375022