Endeca INV-Item Graph/FullLoadConfig.grf Fails With DFF_ExtractDFFData.grf Can't get metadata file (Doc ID 2028243.1)

Last updated on MARCH 12, 2021

Applies to:

Symptoms

On : 12.2.4  V5 version, Item Endeca Integration

- Enedca Inventory Item graph is failing.

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.

 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

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

ERROR
-----------------------
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)

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)

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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.