SAP Knowledge Base Article - Preview

2365756 - Error during pruning of SOPS_DATASTORE schema - SAP EIS

Symptom

  • You have SAP Enterprise and Service-Level Optimization (EIS) Analytics 6.10.3.3 or 6.10.3.4 installed.

  • While pruning the SOPS_DATASTORE schema for EIS, you encounter a Foreign Key violation error similar to the following:

             Pruning failed ORA-02292: integrity constraint (SOPS_DATASTORE.ITEM_ATTRIBUTE_FK1) violated - child record found  
             The prune_package had an error -2292 ORA-02292: integrity constraint (SOPS_DATASTORE.ITEM_ATTRIBUTE_FK1) violated - child record found


Read more...

Environment

  • SAP Enterprise Inventory and Service-Level Optimization (EIS).
  • SAP Enterprise Inventory and Service-Level Optimization Analytics 6.10.3.3 or 6.10.3.4.

Product

SAP Enterprise Inventory and Service-Level Optimization 6.10 ; SAP Enterprise Inventory and Service-Level Optimization Analytics 6.10

Keywords

SmartOps, EIS, EIO, MIPO, prune, ORA-02292, 2292, foreign key, KBA, 6.10.3.3, 6.10.3.4, 6.10 SP3P3, 6.10 SP3P4, partition , 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.