5 Replies Latest reply: Aug 28, 2014 3:50 AM by umit RSS

    Startscen.bat generates an error

    2698502

      greetings, I hope someone can help.  I'm currently using ODI to insert new members into a Planning account dimension.

       

      When running Startscen with a standalone agent, I get an error with regards to the XML log file path (see row 3).  Note that when running this within ODI client, I get no errors and the new members are inserted into Planning as expected.

       

       

      Logging configuration class "oracle.core.ojdl.logging.LoggingConfiguration" failed oracle.core.ojdl.logging.LoggingConfigurationException: ODL-52051: unable to process file './ODI-logging-config.xml'; exception: java.io.FileNotFoundException: F:\Auto\ODI\.\ODI-logging-config.xml (The system cannot find the file specified)

       

              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$1.run(DefaultAgentTaskExecutor.java:49)         at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)         at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)         at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor. doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)         at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor. process(TaskExecutorAgentRequestProcessor.java:83)         at oracle.odi.runtime.agent.RuntimeAgent.startScenario(RuntimeAgent.java:434)         at oracle.odi.StartScen.run(StartScen.java:229)         at oracle.odi.StartScen.main(StartScen.java:343) Caused by: Traceback (most recent call last):   File "", line 30, in        at com.hyperion.odi.planning.wrapper.PlanningWrapper.init(Unknown Source)         at com.hyperion.odi.planning.ODIPlanningConnection.(Unknown Source)         at com.hyperion.odi.planning.PlanningConnectionFactory.getAppWriter(Unknown Source)         at com.hyperion.odi.connection.HypAppConnectionFactory.getWriter(UnknownSource)         at com.hyperion.odi.connection.HypAppConnectionFactory.getAppWriter(Unknown Source)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:597) com.hyperion.odi.planning.ODIPlanningException: com.hyperion.odi.planning.ODIPlanningException: Could not connect the Planning instance on host [MyServer], port [11333], check if connect information is correct.         at org.python.core.PyException.fillInStackTrace(PyException.java:70)         at java.lang.Throwable.(Throwable.java:181)         at java.lang.Exception.(Exception.java:29)         at java.lang.RuntimeException.(RuntimeException.java:32)         at org.python.core.PyException.(PyException.java:46)         at org.python.core.PyException.(PyException.java:43)         at org.python.core.Py.JavaError(Py.java:455)         at org.python.core.Py.JavaError(Py.java:448)         at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:177)         at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:190)         at org.python.core.PyObject.__call__(PyObject.java:414)         at org.python.core.PyObject.__call__(PyObject.java:418)         at org.python.pycode._pyx0.f$0(:64)         at org.python.pycode._pyx0.call_function()         at org.python.core.PyTableCode.call(PyTableCode.java:165)         at org.python.core.PyCode.call(PyCode.java:18)         at org.python.core.Py.runCode(Py.java:1204)         at org.python.core.Py.exec(Py.java:1248)         at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)         at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)         ... 25 more Caused by: com.hyperion.odi.planning.ODIPlanningException: Could not connect thePlanning instance on host [MyServer], port [11333], check if connect information is correct.         at com.hyperion.odi.planning.wrapper.PlanningWrapper.init(Unknown Source)         at com.hyperion.odi.planning.ODIPlanningConnection.(Unknown Source)         at com.hyperion.odi.planning.PlanningConnectionFactory.getAppWriter(Unknown Source)         at com.hyperion.odi.connection.HypAppConnectionFactory.getWriter(UnknownSource)         at com.hyperion.odi.connection.HypAppConnectionFactory.getAppWriter(Unknown Source)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:597)         at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)         ... 36 more Caused by: java.rmi.ConnectException: Connection refused to host: 192.168.0.3; nested exception is:         java.net.ConnectException: Connection timed out: connect         at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:601)         at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:198)         at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:184)         at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:110)         at com.hyperion.planning.HyperionPlanningBeanFactoryImpl_Stub.createHspHALBean(Unknown Source)         ... 46 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 java.net.Socket.connect(Socket.java:478)         at java.net.Socket.(Socket.java:375)         at java.net.Socket.(Socket.java:189)         at sun.rmi.transport.proxy.RMIDirectSocketFactory.createSocket(RMIDirectSocketFactory.java:22)         at sun.rmi.transport.proxy.RMIMasterSocketFactory.createSocket(RMIMasterSocketFactory.java:128)         at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:595)         ... 50 more Aug 21, 2014 7:12:27 AM oracle.odi.agent.logging.AgentLogger log INFO: ODI-1019: Session 32001 ended with status E (ERROR) Status message is : Session Failed :32001 : ODI-1217: Session MyHypPlanApp_Account_Dim_Load (32001) fails with return code 7000. ODI-1226: Step MyHypPlanApp_Account_Dim_Load fails after 1 attempt(s). ODI-1240: Flow MyHypPlanApp_Account_Dim_Load fails while performing a Integration operation. This flow loads target table Account. Caused By: org.apache.bsf.BSFException: exception from Jython:Traceback (most recent call last):   File "", line 30, in        at com.hyperion.odi.planning.wrapper.PlanningWrapper.init(Unknown Source)         at com.hyperion.odi.planning.ODIPlanningConnection.(Unknown Source)         at com.hyperion.odi.planning.PlanningConnectionFactory.getAppWriter(Unknown Source)         at com.hyperion.odi.connection.HypAppConnectionFactory.getWriter(UnknownSource)         at com.hyperion.odi.connection.HypAppConnectionFactory.getAppWriter(Unknown Source)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:597) com.hyperion.odi.planning.ODIPlanningException: com.hyperion.odi.planning.ODIPlanningException: Could not connect the Planning instance on host [MyServer], port [11333], check if connect information is correct.         at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)         at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)         at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)         at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)         at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)         at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.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$1.run(DefaultAgentTaskExecutor.java:49)         at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)         at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)         at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)         at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)         at oracle.odi.runtime.agent.RuntimeAgent.startScenario(RuntimeAgent.java:434)         at oracle.odi.StartScen.run(StartScen.java:229)         at oracle.odi.StartScen.main(StartScen.java:343) Caused by: Traceback (most recent call last):   File "", line 30, in        at com.hyperion.odi.planning.wrapper.PlanningWrapper.init(Unknown Source)         at com.hyperion.odi.planning.ODIPlanningConnection.(Unknown Source)         at com.hyperion.odi.planning.PlanningConnectionFactory.getAppWriter(Unknown Source)         at com.hyperion.odi.connection.HypAppConnectionFactory.getWriter(UnknownSource)         at com.hyperion.odi.connection.HypAppConnectionFactory.getAppWriter(Unknown Source)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:597) com.hyperion.odi.planning.ODIPlanningException: com.hyperion.odi.planning.ODIPlanningException: Could not connect the Planning instance on host [MyServer], port [11333], check if connect information is correct.         at org.python.core.PyException.fillInStackTrace(PyException.java:70)         at java.lang.Throwable.(Throwable.java:181)         at java.lang.Exception.(Exception.java:29)         at java.lang.RuntimeException.(RuntimeException.java:32)         at org.python.core.PyException.(PyException.java:46)         at org.python.core.PyException.(PyException.java:43)         at org.python.core.Py.JavaError(Py.java:455)         at org.python.core.Py.JavaError(Py.java:448)         at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:177)         at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:190)         at org.python.core.PyObject.__call__(PyObject.java:414)         at org.python.core.PyObject.__call__(PyObject.java:418)         at org.python.pycode._pyx0.f$0(:64)         at org.python.pycode._pyx0.call_function()         at org.python.core.PyTableCode.call(PyTableCode.java:165)         at org.python.core.PyCode.call(PyCode.java:18)         at org.python.core.Py.runCode(Py.java:1204)         at org.python.core.Py.exec(Py.java:1248)         at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)         at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144 )         ... 25 more Caused by: com.hyperion.odi.planning.ODIPlanningException: Could not connect thePlanning instance on host [MyServer], port [11333], check if connect information is correct.         at com.hyperion.odi.planning.wrapper.PlanningWrapper.init(Unknown Source)         at com.hyperion.odi.planning.ODIPlanningConnection.(Unknown Source)         at com.hyperion.odi.planning.PlanningConnectionFactory.getAppWriter(Unknown Source)         at com.hyperion.odi.connection.HypAppConnectionFactory.getWriter(UnknownSource)         at com.hyperion.odi.connection.HypAppConnectionFactory.getAppWriter(Unknown Source)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:597)         at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)         ... 36 more Caused by: java.rmi.ConnectException: Connection refused to host: 192.168.0.3; nested exception is:         java.net.ConnectException: Connection timed out: connect         at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:601)         at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:198)         at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:184)         at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:110)         at com.hyperion.planning.HyperionPlanningBeanFactoryImpl_Stub.createHspHALBean(Unknown Source)         ... 46 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 java.net.Socket.connect(Socket.java:478)         at java.net.Socket.(Socket.java:375)         at java.net.Socket.(Socket.java:189)         at sun.rmi.transport.proxy.RMIDirectSocketFactory.createSocket(RMIDirectSocketFactory.java:22)         at sun.rmi.transport.proxy.RMIMasterSocketFactory.createSocket(RMIMasterSocketFactory.java:128)         at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:595)         ... 50 more