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:
- Installing or upgrading the EIS schemas (i.e. MIPO, DataLoader, Data Gateway and Datastore).
- 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
Keywords
SmartOps, EIS, EIO, MIPO, ORA-01429, STG_BUSINESS_ALERT, 1429, 4063, nls_length_semantics , KBA , nls_length_semantics , ora-01429 , stg_business_alert , 1429 , 4063 , 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.