2175948 - EIS Unique Constraint ITEM_ATTRIBUTE_PK Violated - SAP EIS

• The loadset fails and the following errors appear in the log file:

Caused by: java.sql.SQLException: ORA-20000: ORA-20000: There were no stocking points transferred to MIPO for this scenario. Check the reject log and stg tables.
....
ORA-00001: unique constraint (.) violated
ORA-06512: at line 1
ORA-06512: at "SOPS_GATEWAY.PACK_LOADER_UTILITY", line 376
ORA-06512: at "SOPS_GATEWAY.PACK_CREATE_TOPOLOGY", line 3002
ORA-00001: unique constraint (SOPS_GATEWAY.ITEM_ATTRIBUTE_PK) violated

• The following two messages appear in the ERROR_LOG table in the REJECT_REASON column or in the Data Loading Errors published report:

Processing stg_item_attribute into item_attribute table ORA-00001: unique constraint (SOPS_GATEWAY.ITEM_ATTRIBUTE_PK) violated.
Calling process_item_attribute_data ORA-00001: unique constraint (.) violated

This can effect versions 6.10 and older of SAP Enterprise Inventory and Service Level Optimization (older versions also referred to as EIO or SmartOps).

SmartOps
EIS
EIO
Data Issue
Loadset Failure , KBA , SCM-EIS , SAP Enterprise Inventory and Service-Level Optimization , Problem