Last updated on MARCH 08, 2017

Applies to:

Symptoms

On : 12.2.4  V5 version, Item Endeca Integration

- Enedca Inventory Item graph is failing.
- This was occurring in test before Go-Live...but would not block Go-Live.
- Go-Live was Monday June 1st.
- Only found this issue in the final UAT.
- This never worked....it always failed.

Followed note Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.2 V5 (Doc ID 1614014.1) and document Oracle® E-Business Suite Extensions for Oracle Endeca Integration and System Administration Guide Release 12.2 V5 Part No. E49519-09.

We are using the following Endeca products [ besides Inventory extensions ]. All loaded successfully.
  Oracle Cost Management Extensions
  Oracle Order Management Extensions
  Oracle Payables Extensions
  Oracle Receivables Extensions
  Oracle Warehouse Management Extensions

Per the EBS Extensions for Endeca team:
"Specifically, we navigated through clover to the sandboxes, and checked sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt. The file exists, and is readable, so the parsing error appears to be a syntax error, and should be handled by the inventory team."

When attempting to run a full load of inv-item, the following error occurs:

ERROR
-----------------------
2015-05-13 11:28:22,981 ERROR 33423 [EXTRACT_AND_LOAD_DFF_DATA_33421] Pool: Error loading graph:/u01/Oracle/Middleware/user_projects/domains/integrator_domain/sandboxes/Common/graph/DFF_ExtractDFFData.grf Can't get metadata file sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt - java.lang.RuntimeException : Can't parse metadata definition file: sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt
java.lang.RuntimeException: Can't get metadata file sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt - java.lang.RuntimeException : Can't parse metadata definition file: sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt
at org.jetel.metadata.MetadataFactory.fromFile(MetadataFactory.java:50)
at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiateMetadata(TransformationGraphXMLReaderWriter.java:407)
at org.jetel.graph.TransformationGraphXMLReaderWriter.read(TransformationGraphXMLReaderWriter.java:360)

2015-05-13 11:28:22,982 WARN 33423 [EXTRACT_AND_LOAD_DFF_DATA_33421] Couldn't get graph from the pool.Pool: Error loading graph:/u01/Oracle/Middleware/user_projects/domains/integrator_domain/sandboxes/Common/graph/DFF_ExtractDFFData.grf Can't get metadata file sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt - java.lang.RuntimeException : Can't parse metadata definition file: sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt
java.lang.RuntimeException: Pool: Error loading graph:/u01/Oracle/Middleware/user_projects/domains/integrator_domain/sandboxes/Common/graph/DFF_ExtractDFFData.grf Can't get metadata file sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt - java.lang.RuntimeException : Can't parse metadata definition file: sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt
at com.cloveretl.server.c.b.g.c(Unknown Source)
at com.cloveretl.server.c.b.g.d(Unknown Source)
at com.cloveretl.server.c.b.g.b(Unknown Source)

2015-05-13 11:28:22,987 ERROR 33423 [EXTRACT_AND_LOAD_DFF_DATA_33421] Pool: Error loading graph:/u01/Oracle/Middleware/user_projects/domains/integrator_domain/sandboxes/Common/graph/DFF_ExtractDFFData.grf Can't get metadata file sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt - java.lang.RuntimeException : Can't parse metadata definition file: sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt
java.lang.RuntimeException: Can't get metadata file sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt - java.lang.RuntimeException : Can't parse metadata definition file: sandbox://inv-item/meta/dynamic/ITEM_DFF_METADATA.fmt
at org.jetel.metadata.MetadataFactory.fromFile(MetadataFactory.java:50)
at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiateMetadata(TransformationGraphXMLReaderWriter.java:407)
at org.jetel.graph.TransformationGraphXMLReaderWriter.read(TransformationGraphXMLReaderWriter.java:360)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup Endeca Inventory per document Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.2 V5 ( Doc ID 1614014.1 ) and Oracle® E-Business Suite Extensions for Oracle Endeca Integration and System Administration Guide Release 12.2 V5. Order Information.
2. Sign into Clover and Run Graph INV-Item graph/FullLoadConfig.grf.
3. Graph completes with error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the inv-item features.

Cause