Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ODI - Not running simple MaxL Calc Script Now

User_BP7C5Nov 6 2019 — edited Nov 7 2019

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
This post has been answered by JohnGoodwin on Nov 7 2019
Jump to Answer

Comments

JohnGoodwin
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

Marked as Answer by User_BP7C5 · Sep 27 2020
1 person found this helpful
User_BP7C5

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

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

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

ESSBASEPATH:

%EPM_ORACLE_HOME%\products\Essbase\EssbaseServer

User_BP7C5

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.

1 - 6

Post Details

Added on Nov 6 2019
#business-intelligence-applications, #essbase, #odi, #performance-management-applications, #planning, #planning-and-budgeting
6 comments
208 views