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