The ETL Runs for Upwards of 48 Hours. The Following Error Is Found in the Log: ORA-06512: at "STARUSER.SPREAD_ROLLUP_PKG" (Doc ID 2932730.1)

Last updated on MARCH 09, 2023

Applies to:

Symptoms

When attempting to execute the P6 ETL, the following error occurs after upwards of 24-48 hours of execution.

ERROR

Complete extract on WBSHIERARCHY
  [ERROR] PROC_WBS_SPREAD_ROLL_UP
  [ERROR] 0 \-\ WBS Spread Roll Up
  [ERROR] 1 /-/ Procedure - WBS Spread Roll Up - SpreadRollupWbs
  [ERROR] WBS spread roll up, duration = 11382 seconds
  ODI-1228: Task Procedure-WBS Spread Roll Up-SpreadRollupWbs fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS. Caused by: java.sql.SQLException: ORA-08103: object no longer exists ORA-06512: at "STARUSER.SPREAD_ROLLUP_PKG", line 425 ORA-06512: at "STARUSER.SPREAD_ROLLUP_PKG", line 241 ORA-06512: at line 2 atoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510) atoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462) atoracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105) atoracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551) atoracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) atoracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656) atoracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:230) atoracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:42) atoracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:929) atoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1280) atoracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1921) atoracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1876) atoracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304) atoracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:208) atoracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:142) atoracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28) atoracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52) atoracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:217) atoracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:129) atoracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:892) atoracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2234) atoracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:613) atoracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718) atoracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611) atoracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203) atoracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800) atoracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85) atoracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:923) atoracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180) atoracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108) atjava.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) atoracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73) atoracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73) atjava.util.concurrent.FutureTask.run(FutureTask.java:266) atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) atjava.lang.Thread.run(Thread.java:750) Caused by: Sql = begin spread_rollup_pkg.wbs_spread_rollup(#PRIMAVERA_ANALYTICS_PROJECT.VAR_DATASOURCE_ID); end; , Error Msg = java.sql.SQLException: ORA-08103: object no longer exists ORA-06512: at "STARUSER.SPREAD_ROLLUP_PKG", line 425 ORA-06512: at "STARUSER.SPREAD_ROLLUP_PKG", line 241 ORA-06512: at line 2


STEPS

The issue can be reproduced at will with the following steps:
1. Execute the ETL.

Cause

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