My Oracle Support Banner

Prj-Pjt And Prj-Pmc - ETL Failed (Doc ID 2441904.1)

Last updated on SEPTEMBER 04, 2018

Applies to:

Oracle Project Planning and Control - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Information Discovery

Full ETL failed - prj-pjt and prj-pmc

When run the Endeca ETL for Projects module getting the following error message.

ERROR
-----------------------


Error Stack for failure is :
org.jetel.exception.JetelRuntimeException: Component [Run Load Data Full:RUN_LOAD_DATA_FULL] finished with status ERROR. (In0: 1 recs, Out0: 0 recs) at org.jetel.graph.Node.createNodeException(Node.java:631) at org.jetel.graph.Node.run(Node.java:599) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)Caused by: org.jetel.exception.JetelRuntimeException: Execution of graph './graph/LoadDataFull.grf' failed! at org.jetel.component.RunGraph.logError(RunGraph.java:550) at org.jetel.component.RunGraph.runGraphThisInstance(RunGraph.java:543) at org.jetel.component.RunGraph.runSingleGraph(RunGraph.java:412) at org.jetel.component.RunGraph.execute(RunGraph.java:313) at org.jetel.graph.Node.run(Node.java:562) ... 3 moreCaused by: org.jetel.exception.JetelRuntimeException: Component [Load View Definition:LOAD_VIEW_DEFINITION] finished with status ERROR. Execution of graph 'sandbox://Common/graph/Views/LoadViewDefinitions.grf' failed! Component [Load Views in Data Domain:LOAD_VIEWS_IN_DATA_DOMAIN1] finished with status ERROR. (In0: 1 recs, Out0: 0 recs) In statement "DRAFT_REVENUE_DETAIL": In computing attribute "REVTRANS_CURRENCY_CODE": This corpus does not have an attribute named "REVTRANS_CURRENCY_CODE" ... 7 more
For error details please login to Clover URL (http://cloud-ol-endeca-dev.contanda.net:7006/clover) and look for run ID : 168777 in Execution History
 Update statement = UPDATE FND_EID_ETL_AUDITS SET REQUEST_ID = :1 WHERE EID_DATA_STORE_NAME = ( SELECT EID_DATA_STORE_NAME FROM FND_EID_INSTANCES WHERE EID_INSTANCE_ID = :2 ) AND ETL_LAST_RUN_ENDECA_ID = :3
 Parameters passed = Request Id = 13801514 Instance Id = 4 runId = 168777
 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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