3 Replies Latest reply on Jan 24, 2017 12:52 AM by USER1211

    ODI connection

    pr921

      From WorkSpace, the FDMEE connection test says the connection to ODI is ok.

       

      When I run a simple file based Import it fails and I see this in ODI console,

       

      ODI-1241: Oracle Data Integrator tool execution fails.

      Caused By: oracle.odi.runtime.agent.invocation.InvocationException: HTTP/1.1 302 Found

          at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:247)

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

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

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

          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)

       

       

       

      oracle.odi.runtime.agent.invocation.InvocationException: HTTP/1.1 302 Found

          at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:247)

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

       

       

      Thanks,

      PR

        • 1. Re: ODI connection
          USER1211

          what is the version of Hyperion(including patch level) are you?(e.g 11.1.2.4.210)

          Has this ever worked before?

          Is this a new environment?

          Did you set your FDMEE log level to 5 and retry.

          • 2. Re: ODI connection
            pr921

            11.1.2.4.200

            Never worked....

             

            FDMEE log says FATAL ERROR, the ODI step output in my original post gives more detail...

            • 3. Re: ODI connection
              USER1211

              So this is a new environment that never worked.
              Also you did not look at what the FDMEE log at level 5 itself is stating.

              You may want  to log an Oracle SR to have Oracle work with your IT team and check your environment/installation.

               

              There are a few documents you may look at too granted they are not direct to your error:

              FDMEE Open Interface Data Load Fails With Message "ODI-30058: -SCEN_NAME parameter is mandatory" (Doc ID 1952281.1)

              ODI 11g Standalone Agent Running Under OPMN Does Not Execute ERPI Loaddata.bat File - ODI-30038: OS command returned 1. (Doc ID 1609488.1)

               

              Other members on the board may also provide some guidance on areas you could look at .

               

              Good luck