1 Reply Latest reply: Jun 7, 2013 2:53 AM by user799741 RSS

    OBIA 11.1.1.7.1 ETL gets fail again and again

    Sher Ullah Baig
      Hi
      I am running HRMS load plan. once i am executing i am getting following error. I increased my Source DB sessions to 700 but didn't solve problem. still i m getting following error.
      ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection EBS Vsision.
      Caused By: java.sql.SQLException: IO Error: Got minus one from a read call
      --------------------------------------------------------------------- FULL Error log -------------------------------------------------------------------------------------------------------------------------

      ODI-1217: Session SDE_ORA11510_ADAPTOR_SDE_ORA_DOMAINGENERAL_FND_LOOKUPS (454500) fails with return code 8000.
      ODI-1226: Step SDE_ORA_DomainGeneral_FND_LOOKUPS fails after 1 attempt(s).
      ODI-1240: Flow SDE_ORA_DomainGeneral_FND_LOOKUPS 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 EBS Vsision.
      Caused By: java.sql.SQLException: IO Error: Got minus one from a read call
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
           at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:74)
           at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
           at com.sunopsis.sql.SnpsConnection.createConnection(SnpsConnection.java:390)
           at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java:348)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.getExecutor(SnpSessTaskSql.java:2962)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2893)
           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 oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor$3.doAction(QueuedSessionsExecutor.java:252)
           at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
           at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor.executeQueuedSessions(QueuedSessionsExecutor.java:172)
           at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor.executeQueuedSessions(QueuedSessionsExecutor.java:102)
           at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:704)
           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:722)
      Caused by: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
           at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
           at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
           at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:234)
           at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
           at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:410)
           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:386)
           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:353)
           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:332)
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:217)
           at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
           at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
           at java.util.concurrent.FutureTask.run(FutureTask.java:166)
           at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
           at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
           ... 1 more
      Caused by: oracle.net.ns.NetException: Got minus one from a read call
           at oracle.net.ns.Packet.receive(Packet.java:305)
           at oracle.net.ns.NSProtocol.connect(NSProtocol.java:308)
           at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1229)
           at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:326)
           ... 15 more
        • 1. Re: OBIA 11.1.1.7.1 ETL gets fail again and again
          user799741
          This looks like a source connection issue:

          ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection EBS Vsision.
          Caused By: java.sql.SQLException: IO Error: Got minus one from a read call
          at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
          at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
          at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection

          The domains tasks are the first tasks that touch the source connection, hence they would be the first to show this problem.

          To check this out:

          1.     In ODI go to Topology / Physical Architecture / Technologies / Oracle
          2.     Select the node for the connection name appropriate to the EAT type you are doing
          3.     Double Click that node to open it
          4.     Select JDBC (side tab in opened window)
          5.     Click "Test Connection" (option at top of opened window)