2 Replies Latest reply on Oct 9, 2017 7:48 AM by 2847423

    FDMEE Export error using Oracle UDA

    2847423

      Hello Folks,

       

      We have configured the Oracle Universal Data Adaptor to connect to our Oracle Staging Tables and imported the Table definition and generated ODI Package in FDMEE successfully. Created Location, Imp Format, Mappings etc and now while executing the DLR, it fails with the below errors in the ODI session logs:

       

      ODI-1217: Session COMM_LOAD_BALANCES (85501) fails with return code 7000. ODI-1280: The Target Logical Schema AIF_TGT and Context RGL of the task Update Process are not mapped to any Physical Schema. Caused By: com.sunopsis.core.SnpsInexistantSchemaException: ODI-17523: There is no connection for this logical schema / context pair: AIF_TGT / RGL. at com.sunopsis.dwg.dbobj.SnpConnect.getSnpConnectByLSchemaNameAndContext(SnpConnect.java:239) at com.sunopsis.dwg.dbobj.SnpConnect.getSnpConnect(SnpConnect.java:193) at com.sunopsis.dwg.dbobj.SnpSessTask.getDefaultConnection(SnpSessTask.java:415) at com.sunopsis.dwg.dbobj.SnpSessStep.getTargetDataServer(SnpSessStep.java:1409) at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:701) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465) 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)

       

      Troubleshooting We've done:

      Looked at the ODI configuration of Physical Schema, Logical Schema and Context. It all looks fine. However, in the AIF_TGT logical schema - we are unable to select anything as the dropdown has only "Not defined". We did not had to select anything here in AIF_TGT for other integrations.

       

      We have 2 contexts: Global and RGL

       

      Global - used for set of tables from HR systems.

      RGL - used for tables from RGL.

       

      Please advise how to fix this.

       

      Thanks in Advance,

      SSP

        • 1. Re: FDMEE Export error using Oracle UDA
          JohnGoodwin

          The error suggests there is an issue with the the logical schema mapping for AIF_TGT / RGL

          It is probably worth having a look through the following post - FDMEE 11.1.2.4.100 and AIF_TGT logical schema

          Also follow fishing with FDMEE: Universal Data Adapter (UDA), direct DB integration - Part 2

          If you are using the ODI console I recommend switching to the ODI studio to configure the UDA, sometimes the console does not act in the way you would want and over complicates matters.

           

          Cheers

           

          John

          • 2. Re: FDMEE Export error using Oracle UDA
            2847423

            Thank you John. I have updated the table and linked the Physical Schema to AIF_TGT. However, on running the Data Load rule getting the below error in ODI Sessions:

             

            I can confirm that the table/view in question here exists because i ran the Import Table Definition, Generated Template Package successfully. Not sure why i am still getting the below error when executing DLR.

             

            Target is Hyperion Planning Application.

             

             

                <errorMessage><![CDATA[ODI-1217: Session COMM_LOAD_BALANCES (4501) fails with return code 942.

            ODI-1226: Step FAILED: Variable Refresh fails after 1 attempt(s).

            ODI-1232: Procedure COMM Update Process execution fails.

            ODI-1228: Task COMM Update Process (Procedure) fails on the target GENERIC_SQL connection ARB_STAGING.

            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.executeForRows(T4CPreparedStatement.java:1115)

            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

            at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)

            at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)

            at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)

            at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)

            at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.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:577)

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

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