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 JULY 20, 2023

Applies to:

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

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