3 Replies Latest reply: Feb 20, 2014 6:22 PM by FPonte RSS

    Getting ODI-1227 error when running ODI for the first time

    2612850

      We installed ODI and getting the following error when running for the first time.  We enable Service and Sales Analytics in OBIA

       

      SDE_DomainGeneral_S_LST_OF_VAL_PRODUCT_CONFIG_CAT (InternalID:49500), SDE_DomainGeneral_S_LST_OF_VAL_DIVISION_TYPE (InternalID:56500), SDE_DomainGeneral_S_LST_OF_VAL_STATE_PROV (InternalID:61500), SDE_DOMAINGENERAL_POSITION (InternalID:65500), SDE_DomainGeneral_S_LST_OF_VAL_PRODUCT_ITEM_TYPE (InternalID:48500), SDE_DomainGeneral_S_LST_OF_VAL_ACCOUNT_STATUS (InternalID:55500)
      ODI-1217: Session SDE_SBL_811_ADAPTOR_SDE_DOMAINGENERAL_S_LST_OF_VAL (19500) fails with return code 942.
      ODI-1226: Step SDE_DomainGeneral_S_LST_OF_VAL fails after 1 attempt(s).
      ODI-1240: Flow SDE_DomainGeneral_S_LST_OF_VAL fails while performing a Loading operation. This flow loads target table W_DOMAIN_MEMBER_GS.
      ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection VOC_SBL_811.
      Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
      at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:189)
      at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:94)
      at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:1)
      at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:70)
      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:577)
      at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
      at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
      at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1895)
      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
      at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:512)
      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1068)
      at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:137)
      at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
      at java.lang.Thread.run(Thread.java:662)