1 Reply Latest reply: Oct 24, 2013 3:46 PM by Ayush Ganeriwal-Oracle RSS

    OdiWaitForLogData failing with ODI-30018: Unable to find the tables

    user582620

      OdiWaitForLogData was working all the time and all of the sudden it started failing with below error. No luck how many time we restart the process or restart the ODI agent. We are using 11.1.1.6.3 and its  J2EE agent on Weblogic server.

      com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30018: Unable to find the tables

          at com.sunopsis.dwg.tools.WaitForLogData.actionExecute(WaitForLogData.java:677)

          at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:163)

          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

          at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

          at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)

          at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

          at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:561)

          at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)

          at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)

          at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)

          at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

          at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)

          at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)

          at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)

          at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

          at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:83)

          at java.lang.Thread.run(Thread.java:662)

       

       

      Thanks for your help.

      Rama