9 Replies Latest reply on Jul 13, 2016 11:25 AM by Ishti

    EBS Source System Initialization Error.

    Ishti

      Hello Experts,

       

      I have two FDMEE Servers ( A & B) For Dev and Prod. While I am trying to connect both the FDMEE instances to the same EBS Source System.

      My connection works fine when I connect to EBS from Server A. I have been using this for a while.

      Now I have to make a new connection to the same EBS source system from Server B.

      I am getting Initialization Error.

      The ODI Log says the following Error:

      ODI-1227: Task EBS Update Source System Base Language (Procedure) fails on the source ORACLE connection EBS_DATA_SERVER.

       

      I have gone through the thread:

      source system initialization error

       

      And seems like the synonym and the access is fine.

       

      Appreciate your help.

       

      Thanks,

      Ishti.

        • 1. Re: EBS Source System Initialization Error.
          Dayalan Punniyamoorthy

          Thought of asking if you followed this FDMEE: How to Register Multiple Source Systems of the Same Type in One Environment. (Doc ID 1997512.1)

           

          Regards,

          Dayalan P.

          • 2. Re: EBS Source System Initialization Error.
            Ishti

            Thank You for Sharing this. But in my case I have the same source system to be connected to Multiple FDMEE instances.

            • 3. Re: EBS Source System Initialization Error.
              Dayalan Punniyamoorthy

              Sorry,i misunderstood your question. Never tried to connect to same EBS for more than 1 FDMEE instance, but technically it should work (Conflict might happen during the write back, but hopefully each FDMEE might generate separate process id's).

               

              Now coming back to the issue, this issue normally points to the access issue, can you run the SQL using the schema user you are using to connect? Does it works?

               

              Regards,

              Dayalan P.

              • 4. Re: EBS Source System Initialization Error.
                Ishti

                Yes It works as in both the FDMEE instances, I am using the same user to connect.

                • 5. Re: Re: EBS Source System Initialization Error.
                  JohnGoodwin

                  Are there any more details in the logs in Studio as that step should only be running the following SQL against the EBS_DATA_SERVER connection

                   

                  select LANGUAGE_CODE BASE_LANGUAGE
                  from fnd_languages
                  where installed_flag = 'B'
                  

                   

                  Then the following SQL is run against the FDMEE_DATA_SERVER connection

                   

                  UPDATE aif_source_systems
                  SET base_language = :BASE_LANGUAGE
                  WHERE source_system_id = #AIF.p_source_system_id
                  

                   

                  I would expect there would some kind of SQL related error in the logs

                  • 6. Re: Re: EBS Source System Initialization Error.
                    Ishti

                    Hi John,

                     

                    Thank You for the reply.

                    Below is the log as i cannot find any sql related error.

                    =================================================================================

                    Session Failed :7501 : ODI-1217: Session EBS_GL_SETUP_SOURCE_SYSTEM (7501) fails with return code 8000.

                    ODI-1226: Step EBS Update Source System Base Langu fails after 1 attempt(s).

                    ODI-1232: Procedure EBS Update Source System Base Language execution fails.

                    ODI-1227: Task EBS Update Source System Base Language (Procedure) fails on the source ORACLE connection EBS_DATA_SERVER.

                    Caused By: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection

                      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.processTask(SnpSessTaskSql.java:2882)

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

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

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

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

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

                      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:513)

                      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

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

                      at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:50)

                      at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)

                      at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:93)

                      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                      at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

                      at oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)

                      at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)

                      at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)

                      at com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)

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

                      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:580)

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

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

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

                      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:513)

                      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

                      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)

                    Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

                      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:439)

                      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

                      at java.util.concurrent.FutureTask.run(FutureTask.java:138)

                      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

                      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

                      ... 1 more

                    Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

                      at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:398)

                      at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:438)

                      at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:711)

                      at oracle.net.ns.NSProtocol.connect(NSProtocol.java:257)

                      at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1229)

                      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:326)

                      ... 15 more

                    Caused by: java.net.ConnectException: Connection timed out: connect

                      at java.net.PlainSocketImpl.socketConnect(Native Method)

                      at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)

                      at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)

                      at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)

                      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

                      at java.net.Socket.connect(Socket.java:529)

                      at oracle.net.nt.MetricsEnabledSocket.connect(TcpNTAdapter.java:631)

                      at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:164)

                      at oracle.net.nt.ConnOption.connect(ConnOption.java:137)

                      at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:374)

                      ... 20 more

                    =================================================================================================================

                    Thanks,

                    Ishti.

                    • 7. Re: Re: EBS Source System Initialization Error.
                      Ishti

                      I have also tried running the source system query and the query returns result with the Base Language.

                      • 8. Re: EBS Source System Initialization Error.
                        JohnGoodwin

                        There is an issue connecting to the database you can see it in the logs

                        "Caused By: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection"


                        Have a search for the above error on the internet and you will lots of help on the issue.

                        • 9. Re: EBS Source System Initialization Error.
                          Ishti

                          I will check on the connection issue to the database. I will update the results. Thanks a ton for your time John.