1 Reply Latest reply: Aug 15, 2014 4:23 PM by Ayush Ganeriwal-Oracle RSS

    ODI 11.1.1.7 loaddata to Essbase 11.1.2.3 error

    1312149

      IKM SQL TO ESSBASE(DATA)

      I user local(nom agent),hava anyproblem config Agent?have must config agent?



      [2014-07-28T23:04:59.573+08:00] [] [WARNING] [ODI-1134] [] [tid: 31] [ecid: 0000KTwxNz96QPWzLwNM8A1Jp^BV000002,0:56561] Agent Internal encountered an error: ODI-1226: step test fails after 1 attempt(s).

      [2014-07-28T23:04:59.574+08:00] [] [ERROR] [ODI-1217] [] [tid: 31] [ecid: 0000KTwxNz96QPWzLwNM8A1Jp^BV000002,0:56561] 会话test (42002) 失败, 返回代码为 7000。[[

      ODI-1226: 步骤 test 在经过 1 次尝试后失败。

      ODI-1240: 执行集成操作时流test失败。此流加载目标表CABUDGET_PLData。

      Caused By: org.apache.bsf.BSFException: exception from Jython:

      Traceback (most recent call last):

        File "<string>", line 26, in <module>

      at com.hyperion.odi.essbase.ODIEssbaseDataWriter.loadData(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.essbase.ODIEssbaseException: com.hyperion.odi.essbase.ODIEssbaseException: Error records reached the maximum error threshold : 11

       

      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 oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)

      at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

      at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)

      at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)

      at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)

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

      at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

      at java.lang.Thread.run(Thread.java:662)

      Caused by: Traceback (most recent call last):

        File "<string>", line 26, in <module>

      at com.hyperion.odi.essbase.ODIEssbaseDataWriter.loadData(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.essbase.ODIEssbaseException: com.hyperion.odi.essbase.ODIEssbaseException: Error records reached the maximum error threshold : 11

       

      at org.python.core.PyException.fillInStackTrace(PyException.java:70)

      at java.lang.Throwable.<init>(Throwable.java:181)

      at java.lang.Exception.<init>(Exception.java:29)

      at java.lang.RuntimeException.<init>(RuntimeException.java:32)

      at org.python.core.PyException.<init>(PyException.java:46)

      at org.python.core.PyException.<init>(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.PyObject.__call__(PyObject.java:355)

      at org.python.core.PyMethod.__call__(PyMethod.java:215)

      at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

      at org.python.core.PyMethod.__call__(PyMethod.java:206)

      at org.python.core.PyObject.__call__(PyObject.java:397)

      at org.python.core.PyObject.__call__(PyObject.java:401)

      at org.python.pycode._pyx7.f$0(<string>:30)

      at org.python.pycode._pyx7.call_function(<string>)

      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)

      ... 19 more

      Caused by: com.hyperion.odi.essbase.ODIEssbaseException: Error records reached the maximum error threshold : 11

      at com.hyperion.odi.essbase.ODIEssbaseDataWriter.loadData(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)

      ... 33 more

      Caused by: com.hyperion.odi.essbase.ODIEssbaseException: Error records reached the maximum error threshold : 11

      at com.hyperion.odi.essbase.ODIEssbaseDataWriter.checkMaxError(Unknown Source)

      at com.hyperion.odi.essbase.ODIEssbaseDataWriter.sendRecordArrayToEsbase(Unknown Source)

      ... 39 more

       

      ]]