Error: "ODI-1217: Session XXXXXXXXXXXXXXXX (XXXX) fails with return code 0" Or "ORA-01653: unable to extend table" When Executing An ETL For Primavera Analytics (Using ODI)

(Doc ID 2397728.1)

Last updated on MAY 11, 2018

Applies to:

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

Symptoms

After an ETL is executed (for example, LOAD_PLAN_DAILY, LOAD_PLAN_REALTIME_GLOBAL, LOAD_PLAN_REALTIME_PROJECT) the load plan fails with the following (evident within the ODI Studio):

ERROR
-----------------------
ODI-1217: Session XXXXXXXXXXXXXXXX (XXXX) fails with return code 0.
  at oracle.odi.runtime.agent.execution.SessionExecutor.closeSession(SessionExecutor.java:2693)
  at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.computeFirstDependentNodeInOptimizedWay(SessionExecutor.java:2176)
  at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.computeFirstDependentNodeInOptimizedWay(SessionExecutor.java:2149)
  at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2031)
  at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:562)
  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:84)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:916)
  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:471)
  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:262)
  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:745)


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

  1. Execute an ETL
  2. Note the failure which occurs from the log file


Note: If relative to the real-time ETLs, the error can be found from the ODI Studio.

Changes

 

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