Projects Endeca: PRJ-PMC And PRJ-PJT Full Load Fails

(Doc ID 2372454.1)

Last updated on MARCH 12, 2018

Applies to:

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

Symptoms

Release R12.2.5 and Endeca V6

This is a new instance on which Endeca is installed and referred to standard Oracle documentation for R12.2.5 and V6. The sandboxes 'ar', 'ont' full load has completed fine.

However, for sandbox, PRJ-PMC and PRJ-PJT, the full load ends in error.


PRJ-PJT

2017-02-15 17:49:55,108 ERROR 314455 [PREPARE_VIEW_STREAM_314455] totalLength is 928401 and viewsIndex is 230
2017-02-15 17:50:23,782 ERROR 314455 [WatchDog_314455] Component [Load Views in Data Domain:LOAD_VIEWS_IN_DATA_DOMAIN1] finished with status ERROR.
 In statement "FUNDING_INNER_VIEW": In computing attribute "FUNDING_CATEGORY": This corpus does not have an attribute named "FUNDING_CATEGORY"
2017-02-15 17:50:23,783 ERROR 314455 [WatchDog_314455] Error details:
org.jetel.exception.JetelRuntimeException: Component [Load Views in Data Domain:LOAD_VIEWS_IN_DATA_DOMAIN1] finished with status ERROR.
at org.jetel.graph.Node.createNodeException(Node.java:543)
at org.jetel.graph.Node.run(Node.java:522)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.apache.axis2.AxisFault: In statement "FUNDING_INNER_VIEW": In computing attribute "FUNDING_CATEGORY": This corpus does not have an attribute named "FUNDING_CATEGORY"
at org.apache.axis2.description.OutInAxisOperationClient$NonBlockingInvocationWorker.run(OutInAxisOperation.java:451)
... 3 more

2017-02-15 17:50:23,794 ERROR 314455 [WatchDog_314455] !!! Phase finished with error - stopping graph run !!!
2017-02-15 17:50:23,835 ERROR 314455 [JobFinalizer_314455]
---------------------------------------------------------------- Error details -----------------------------------------------------------------
  Component [Load Views in Data Domain:LOAD_VIEWS_IN_DATA_DOMAIN1] finished with status ERROR.
  In statement "FUNDING_INNER_VIEW": In computing attribute "FUNDING_CATEGORY": This corpus does not have an attribute named "FUNDING_CATEGORY"
------------------------------------------------------------------------------------------------------------------------------------------------


PRJ-PMC

2017-02-15 17:39:49,365 ERROR 314431 [PREPARE_VIEW_STREAM_314431] totalLength is 848041 and viewsIndex is 230
2017-02-15 17:39:54,974 ERROR 314431 [WatchDog_314431] Component [Load Views in Data Domain:LOAD_VIEWS_IN_DATA_DOMAIN1] finished with status ERROR.
 In statement "ResourceSummary_Base": In computing attribute "PROJECT_ORG_ID": This corpus does not have an attribute named "PROJECT_ORG_ID"
2017-02-15 17:39:54,975 ERROR 314431 [WatchDog_314431] Error details:
org.jetel.exception.JetelRuntimeException: Component [Load Views in Data Domain:LOAD_VIEWS_IN_DATA_DOMAIN1] finished with status ERROR.
at org.jetel.graph.Node.createNodeException(Node.java:543)
at org.jetel.graph.Node.run(Node.java:522)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.apache.axis2.AxisFault: In statement "ResourceSummary_Base": In computing attribute "PROJECT_ORG_ID": This corpus does not have an attribute named "PROJECT_ORG_ID"
at org.apache.axis2.description.OutInAxisOperationClient$NonBlockingInvocationWorker.run(OutInAxisOperation.java:451)
... 3 more

2017-02-15 17:39:54,985 ERROR 314431 [WatchDog_314431] !!! Phase finished with error - stopping graph run !!!
2017-02-15 17:39:54,991 ERROR 314431 [JobFinalizer_314431]
--------------------------------------------------------------- Error details ----------------------------------------------------------------
  Component [Load Views in Data Domain:LOAD_VIEWS_IN_DATA_DOMAIN1] finished with status ERROR.
  In statement "ResourceSummary_Base": In computing attribute "PROJECT_ORG_ID": This corpus does not have an attribute named "PROJECT_ORG_ID"
----------------------------------------------------------------------------------------------------------------------------------------------

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms