2546153 - ORA-02292: integrity constraint SC_SETTING_FK1 violated - child record found - EIS

Symptom

As part of the pruning process for SAP Enterprise Inventory and Service-Level Optimization (EIS), you are running the mipo_pruning.sql script and it fails with the following error:

The delete from sc_data_handle failed
ORA-02292: integrity constraint (SOPS_MIPO.SC_SETTING_FK1) violated - child record found

Environment

SAP Enterprise Inventory and Service-Level Optimization (EIS)

Product

SAP Enterprise Inventory and Service-Level Optimization all versions

Keywords

EIS, EIO, SmartOps, MIPO, prune, 2292, foreign_key, fail, error, sc_data_handle, scdhk, scenario, scenario_definition , 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.