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!

Not able to run Maxl if the ODI Agent is Running Under & Being Managed by OPMN

2636557Jun 13 2014 — edited Jun 16 2014

Error thrown in Inteface execution of Oracle-Essbase Interface when using IKM SQL to Hyperion Essbase(DATA) and calling a MAXL clear script in PRE_LOAD_MAXL_SCRIPT.

The Interface execution completes successfully if the same ODI agent is running directly from command prompt(using agent.bat). But when we start the agent through OPMN instance, getting the following error:

com.hyperion.odi.essbase.ODIEssbaseException: com.hyperion.odi.essbase.ODIEssbaseException: Cannot run program "essmsh": CreateProcess error=2, The system cannot find the file specified

The ODI agent running fine and completes any interface execution without MAXL. But if we use PRE_LOAD_MAXL_SCRIPT, it throws an error.

We have already created two environment variables as ESSBASEPATH and ARBORPATH, also updated the Path variable. We are able to start maxl using "essmsh" command directly from command prompt.

Let me know how can we call MAXL scripts through OPMN managed ODI agents.

Any suggestions/help will be appreciated.

Thanks!!

This post has been answered by Chuggans-Oracle on Jun 13 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2014

Added on Jun 13 2014

#agent, #business-intelligence-applications, #data-integrator, #essbase, #interface, #odi, #system-management-and-integration

7 comments

3,201 views