Forum Stats

  • 3,769,363 Users
  • 2,252,957 Discussions
  • 7,875,005 Comments

Discussions

ODI - Not running simple MaxL Calc Script Now

User_BP7C5
User_BP7C5 Member Posts: 29 Green Ribbon
edited Nov 7, 2019 5:19PM in Planning and Budgeting

Hi.  I know a crapshoot as nobody probably uses ODI anymore.   Anyways we have a process in our data loads:

  1. Execute pre calc
  2. Load data
  3. Execute post calc

Now we are getting the below error when it tries and executes this part of the code.  Any ideas?  Could it be a 'port' issue?  I"m at a loss here as it worked perfectly for years...

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

Traceback (most recent call last):

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

    at com.hyperion.odi.essbase.ODIEssbaseConnection.executeMaxl(Unknown Source)

    at com.hyperion.odi.essbase.AbstractEssbaseWriter.beginLoad(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 occured while executing maxl script. Error Message is:

    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 89, in <module>

    at com.hyperion.odi.essbase.ODIEssbaseConnection.executeMaxl(Unknown Source)

    at com.hyperion.odi.essbase.AbstractEssbaseWriter.beginLoad(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 occured while executing maxl script. Error Message is:

    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._pyx33.f$0(<string>:89)

    at org.python.pycode._pyx33.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 occured while executing maxl script. Error Message is:

    at com.hyperion.odi.essbase.ODIEssbaseConnection.executeMaxl(Unknown Source)

    at com.hyperion.odi.essbase.AbstractEssbaseWriter.beginLoad(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.essbase.api.base.EssException: Error occured while executing maxl script. Error Message is:

    at com.hyperion.odi.essbase.wrapper.EssbaseConnection.executeMaxl(Unknown Source)

    ... 40 more

Tagged:
User_BP7C5

Best Answer

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Nov 7, 2019 2:51AM Accepted Answer

    Are you sure nothing has changed? The only time I have seen this issue is when MaxL cannot be accessed due to missing environment variables.

    For example - https://john-goodwin.blogspot.com/2012/03/odi-series-problems-using-prepost-maxl.html

    Cheers

    John

    User_BP7C5
  • User_BP7C5
    User_BP7C5 Member Posts: 29 Green Ribbon
    edited Nov 7, 2019 2:28PM

    They upgraded Powershell to version 5.0    That shouldn't affect it should it?   Is there a service on the server for ODI that needs to be running?

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Nov 7, 2019 3:06PM

    Something has affected it, whether it was that I can't say but if changes happened on the server and then errors have started appearing then could be linked.

    Did you check the three environment variables to check if they are correct like in the link I posted?

  • User_BP7C5
    User_BP7C5 Member Posts: 29 Green Ribbon
    edited Nov 7, 2019 3:14PM

    I just did that and the ARBORPATH was missing so I added it.  Rebooted Server and trying again. 

    Here's my PATH:

    %SystemRoot%\system32;

    %SystemRoot%;

    %SystemRoot%\System32\Wbem;

    %SYSTEMROOT%\System32\WindowsPowerShell\v1.0;

    C:\Oracle\Middleware\EPMSystem11R1\common\ODBC-64\Merant\7.0\Drivers;

    C:\Oracle\Middleware\EPMSystem11R1\bin;

    C:\Oracle\Middleware\EPMSystem11R1\common\SAP\bin;

    C:\Oracle\Middleware\EPMSystem11R1\opmn\bin;

    C:\Oracle\Middleware\EPMSystem11R1\opmn\lib;

    C:\Oracle\Middleware\EPMSystem11R1\perl\bin;

    C:\Oracle\Middleware\ohs\bin;

    C:\Oracle\Middleware\ohs\opmn\bin;

    C:\Oracle\Middleware\ohs\opmn\lib;

    C:\Oracle\Middleware\ohs\perl\bin;

    C:\Oracle\Middleware\jdk160_35\bin;

    %PATH%;

    %ESSBASEPATH%\bin;

    %CSAM_SOCKADAPTER%bin;

    F:\Automation\7zip;

    F:\TestEssbase\bin;

    C:\Oracle\EPM Automate\bin;

    %systemroot%\System32\WindowsPowerShell\v1.0\;

    %EPM_ORACLE_HOME%\bin;

    C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC-64\11.1.2.0\bin

  • User_BP7C5
    User_BP7C5 Member Posts: 29 Green Ribbon
    edited Nov 7, 2019 3:15PM

    ESSBASEPATH:

    %EPM_ORACLE_HOME%\products\Essbase\EssbaseServer

  • User_BP7C5
    User_BP7C5 Member Posts: 29 Green Ribbon
    edited Nov 7, 2019 3:49PM

    ARBORPATH:

    F:\Essbase

    However everytime I reboot server it disappears.  I'm comparing our TEST environment to our PROD.   Do we need to re-run the configurator?  That scares me to be honest.

    The jobs are now executing, so that's good.   No idea how the ENV's changed.