My Oracle Support Banner

Error: "ORA-30926: unable to get a stable set of rows in the source tables ORA-06512: at STARUSER.UDF_HIST_LOAD_PKG" While Executing P6 EPPM ETL (ODI) (Doc ID 2455447.1)

Last updated on DECEMBER 06, 2018

Applies to:

Primavera Analytics Cloud Service - Version 17.11.0.0 and later
Primavera Analytics - Version 17.11.0.0 and later
Information in this document applies to any platform.

Symptoms

While executing the P6 ETL (staretl1) the following error occurs causing the ETL to fail:

ERROR
-----------------------
...
Complete load on W_UDF_ACTIVITY_HF
Complete load on W_UDF_PROJECT_HF
  [ERROR] PROC_AFTER_LOADING_PKG_SCD
  [ERROR] 0 \-\ After SCD
  [DONE] 1 /-/ Procedure - After SCD - UpdateWidsEpsHDWids
  [DONE] 2 /-/ Procedure - After SCD - HistRollupActivity
  [DONE] 3 /-/ Procedure - After SCD - HistRollupProject
  [DONE] 4 /-/ Procedure - After SCD - HistRollupWbs
  [ERROR] 5 /-/ Procedure - After SCD - UdfHistFactLoad
  [ERROR] After loading package SCD, duration = 82 seconds
 ODI-1228: Task Procedure-After SCD-UdfHistFactLoad fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS. Caused By: java.sql.SQLException: ORA-12801: error signaled in parallel query server xxx, instance host:sid (1) ORA-30926: unable to get a stable set of rows in the source tables ORA-06512: at "STARUSER.UDF_HIST_LOAD_PKG", line 526 ORA-06512: at line 4 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:31) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2168) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2100) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:363) at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:142) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28) at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52) at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206) at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117) at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886) at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225) at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610) at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718) at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203) at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:917) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73) at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)
[ERROR]Load plan [LOAD_PLAN_DAILY] completed, duration = 854 seconds
-- End --

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Execute the P6 EPPM ETL (note, the execution can occur on an existing schedule)
  2. Note the failure on the status page of the Analytics Administration Application
  3. Click View Log to determine the error causing the ETL to fail.

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


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