Article - CS331003
GetHostData process failed with "ORA-02437: cannot validate (SVG_MGR.IPCSTMP_G43999_PK) - primary key violated" in Servigistics Service Parts Management
Modified: 29-May-2023
Applies To
- Servigistics Service Parts Management 11.4.1.3 to 12.2.0.1
Description
- GetHostData process failed with "ORA-02437: cannot validate (SVG_MGR.IPCSTMP_G43999_PK) - primary key violated"
- Import for SKU Overrides failing with "ORA-02437: cannot validate (SVG_MGR.IPCSTMP_G43999_PK) - primary key violated"
- Error in log file:
- uncategorized SQLException for SQL [alter table IPCSTMP_G43999 add constraint IPCSTMP_G43999_PK primary key (HostSKUOverrideID)]; SQL state [72000]; error code [2437]; ORA-02437: cannot validate (SVG_MGR.IPCSTMP_G43999_PK) - primary key violated
; nested exception is java.sql.SQLException: ORA-02437: cannot validate (SVG_MGR.IPCSTMP_G43999_PK) - primary key violated
- uncategorized SQLException for SQL [alter table IPCSTMP_G43999 add constraint IPCSTMP_G43999_PK primary key (HostSKUOverrideID)]; SQL state [72000]; error code [2437]; ORA-02437: cannot validate (SVG_MGR.IPCSTMP_G43999_PK) - primary key violated
This is a printer-friendly version of Article 331003 and may be out of date. For the latest version click CS331003