5 Replies Latest reply on Nov 1, 2017 9:23 PM by 2847423

    FDMEE to EBS WriteBack Integration

    2847423

      Hi Folks,

       

      We already have an existing integration with an EBS instance for Budget Writeback. And now trying to integrate FDMEE with another EBS Instance.

       

      I have created a Data Server, Physical Schema and Logical Schema in ODI. And the connection to Data Server is successful.

       

      In FDMEE, I have added ERPI Source System and given all the details, but when I Initialize the Source System, getting errors as below. Could you please help.

       

      2017-10-31 18:13:19,142 INFO  [AIF]: FDMEE Process: 2690, Log Level: 5, Log File: \\172.17.5.69\FDMEEApps\ARB_BUD/outbox/logs/EBS_ACC_2690.log

      2017-10-31 18:13:19,142 INFO  [AIF]: Location     : NA (Partitionkey:null)

      2017-10-31 18:13:19,142 INFO  [AIF]: Period Name  : NA (Period Key:null)

      2017-10-31 18:13:19,142 INFO  [AIF]: Category Name: NA (Category key:null)

      2017-10-31 18:13:19,143 INFO  [AIF]: Rule Name    : NA (Rule ID:null)

      2017-10-31 18:13:27,217 INFO  [AIF]: FDM Version: 11.1.2.4.210

      2017-10-31 18:13:27,217 INFO  [AIF]: Log File Encoding: UTF-8

      2017-10-31 18:14:46,245 FATAL [AIF]: Error in Launch EBS Setup Source System

      2017-10-31 18:14:46,352 INFO  [AIF]: FDMEE Process End, Process ID: 2690

       

      The ODI Session logs are as below.

       

      ODI-1217: Session EBS_GL_SETUP_SOURCE_SYSTEM (1162501) fails with return code 7000. 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: oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:117) 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)

        • 1. Re: FDMEE to EBS WriteBack Integration
          JohnGoodwin

          There is a problem connecting to the Oracle EBS database as it is timing out

           

          "Caused By: oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database"

           

          Cheers

           

          John

          • 2. Re: FDMEE to EBS WriteBack Integration
            2847423

            Hello John,

             

            Is there a timeout setting that needs to be set on Hyperion side? We are using ODI bundled with FDMEE and version is 11.1.2.4.210.212

            • 3. Re: FDMEE to EBS WriteBack Integration
              JohnGoodwin

              The timeout will be on the ODI side, have a search in Oracle support for "oracle.odi.jdbc.datasource.ConnectionTimeoutException"

              • 4. Re: FDMEE to EBS WriteBack Integration
                2847423

                Hi John,

                 

                I have another Data server in ODI connecting to other database instance which is connecting fine when testing the Data Server. It is just this one, so wondering if there is anything wrong on this particular database side. Thoughts?

                • 5. Re: FDMEE to EBS WriteBack Integration
                  2847423

                  I figure out that The timeout issue was due to missing tns entries in the tnsnames.ora. However now when initializing the Source System for EBS, getting errors

                   

                   

                   

                  [2017-11-01T23:53:29.643+03:00] [ErpIntegrator0] [ERROR] [ODI-1134] [] [tid: 24] [userId: <anonymous>] [ecid: 0000LxtMknwApIMLIMg8yf1PyZA200000M,1:21321] [APP: oraclediagent] Agent OracleDIAgent encountered an error: ODI-1217: Session COMM_SETUP_SOURCE_SYSTEM (1247501) fails with return code 7000. Caused by: ODI-1226: Step Set Process Failed fails after 1 attempt(s).[[

                  ODI-1217: Session COMM_SETUP_SOURCE_SYSTEM (1247501) fails with return code 7000.

                  ODI-1226: Step Set Process Failed fails after 1 attempt(s).

                  ODI-1232: Procedure COMM Update Process execution fails.

                  Caused By: oracle.odi.core.repository.UncategorizedRepositoryAccessException: ODI-10182: Uncategorized exception during repository access.

                  Connection has already been closed.

                          at oracle.odi.core.datasource.dwgobject.support.DataSourceDefinitionFactory.getDataSourceDefinition(DataSourceDefinitionFactory.java:72)

                          at oracle.odi.core.datasource.dwgobject.support.DwgConnectConnectionCreatorImpl.createDwgConnectConnection(DwgConnectConnectionCreatorImpl.java:80)

                          at com.sunopsis.dwg.dbobj.SnpSession.createDwgConnectConnection(SnpSession.java:4076)

                          at com.sunopsis.dwg.dbobj.SnpSessTask.getDefaultDwgConnectConnection(SnpSessTask.java:513)

                          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.getExecutor(SnpSessTaskSql.java:2960)

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

                          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: com.sunopsis.dwg.SQLMasterReposException: Connection has already been closed.

                          at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:62)

                          at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:100)

                          at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:545)

                          at com.sunopsis.sql.SnpsQuery.getPreparedStatement(SnpsQuery.java:975)

                          at com.sunopsis.sql.SnpsQuery.getPreparedStatement(SnpsQuery.java:1016)

                          at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java:1850)

                          at com.sunopsis.sql.SnpsQuery.executeQuery(SnpsQuery.java:596)

                          at com.sunopsis.dwg.dbobj.generated.GeneratedSnpAgent.getObjectLst(GeneratedSnpAgent.java:789)

                          at com.sunopsis.dwg.dbobj.SnpAgent.getAgentByName(SnpAgent.java:148)

                          at com.sunopsis.dwg.dbobj.SnpDatasource.getSnpDatasourceByIConnectAndAgentName(SnpDatasource.java:50)

                          at oracle.odi.core.datasource.dwgobject.support.DataSourceDefinitionFactory.getDataSourceDefinition(DataSourceDefinitionFactory.java:60)

                          ... 17 more

                   

                  Any thoughts?