SAP Knowledge Base Article - Preview

2175948 - EIS Unique Constraint ITEM_ATTRIBUTE_PK Violated - SAP EIS

Symptom

  • 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


Read more...

Environment

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).

Product

SAP Enterprise Inventory and Service-Level Optimization all versions

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.