SAP Knowledge Base Article - Preview

2630320 - EIS MIPO pruning failure with NEW_SKU_MAP foreign key error

Symptom

User is running the mipo_pruning.sql script within SAP Enterprise Inventory and Service-Level Optimization (EIS) and it is failing with the following error found within the mipo_pruning.log.

A foreign key error was raised when restoring data into NEW_SKU_MAP
The FK related delete from  input_tab was successful
Retrying the insert back into table NEW_SKU_MAP from input_tab
DECLARE
*
ERROR at line 1:
ORA-02291: integrity constraint (SOPS_MIPO.NEW_SKU_MAP_FK3) violated - parent

key not found
ORA-06512: at "SOPS_MIPO.PACK_SCENARIO_PRUNE", line 440
ORA-02291: integrity constraint (SOPS_MIPO.NEW_SKU_MAP_FK3) violated - parent
key not found
ORA-06512: at "SOPS_MIPO.PACK_SCENARIO_PRUNE", line 953
ORA-06512: at line 74


Read more...

Environment

SAP Enterprise Inventory and Service-Level Optimization (EIS)

Product

SAP Enterprise Inventory and Service-Level Optimization all versions

Keywords

SmartOps, EIS, EIO, MIPO, PACK_SCENARIO_PRUNE, NEW_SKU_MAP, ORA-02291, ORA-06512, key, parent, foreign, prune, global , 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.