SAP Knowledge Base Article - Preview

2146687 - ORA-04063: package body "PACK_AUGMENT_DATA" has errors - EIS

Symptom

  • While running a model in SAP Enterprise Inventory and Service-Level Optimization (EIS), an error occurs during validation of the "PACK_AUGMENT_DATA" plsql package in the SOPS_GATEWAY schema when doing one of the following:
    1. Installing or upgrading the EIS schemas (i.e. MIPO, DataLoader, Data Gateway and Datastore).
    2. Loading a supply chain model.
       
  • The package will appear as an invalid object during a check for invalid objects after the SOPS_GATEWAY is installed.  This is especially the case if it is the only invalid object:

OWNER OBJECT_NAME STATUS
SOPS_GATEWAY   PACK_AUGMENT_DATA     INVALID 
  • When loading a supply chain, an error can also be seen in the EIS (SmartOps) application log similar to the following:

2015-03-23 12:18:36 EST EXCEPTION      InboundGatewayWorkerThread com.smartops.gateway.connector.InboundGatewayWorkerThread processLoadSet - Processing of loadSet with inboundGatewayQueueKey failed for inbound_gateway_queue_key = 11 gw_pack_augment_data.augment_topology_data ( ) failed
com.smartops.gateway.connector.GatewayInboundException: gw_pack_augment_data.augment_topology_data ( ) failed
 at com.smartops.gateway.GatewayPersistor.augmentData(GatewayPersistor.java:156)
 at com.smartops.gateway.connector.InboundGatewayWorkerThread.invokeStoredProcedureForDataAugmentation(InboundGatewayWorkerThread.java:348)
 at com.smartops.gateway.connector.InboundGatewayWorkerThread.processLoadSet(InboundGatewayWorkerThread.java:793)
 at com.smartops.gateway.connector.InboundGatewayWorkerThread.run(InboundGatewayWorkerThread.java:194)
Caused by: java.sql.SQLException: ORA-04063: package body "SOPS_GATEWAY.PACK_AUGMENT_DATA" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SOPS_GATEWAY.PACK_AUGMENT_DATA"
ORA-06512: at line 1


Read more...

Environment

This can effect versions 6.10.x and older of SAP Enterprise Inventory and Service Level Optimization (older versions also referred to as EIO or SmartOps).

Product

SAP Enterprise Inventory Optimization 6.3 by SmartOps ; SAP Enterprise Inventory Optimization 6.7.2 by SmartOps ; SAP Enterprise Inventory Optimization 6.8 by SmartOps ; SAP Enterprise Inventory Optimization 6.9 by SmartOps ; SAP Enterprise Inventory and Service-Level Optimization 6.10

Keywords

SmartOps, EIS, EIO, MIPO, ORA-01429, STG_BUSINESS_ALERT, 1429, 4063, nls_length_semantics , KBA , nls_length_semantics , ora-01429 , stg_business_alert , 4063 , 1429 , SCM-EIS , SAP Enterprise Inventory and Service-Level Optimization , SCM-EIS-OPS , SAP EIS - Operations , Problem

About this page

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

Search for additional results

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