Error Seen When Running an Essbase Interface in ODI Using an ODI Agent Service: com.hyperion.odi.essbase.ODIEssbaseException: Error occurred while executing a maxl script (Unknown Source)
Last updated on MARCH 05, 2018
Applies to:Hyperion Essbase - Version 188.8.131.52.00 and later
Oracle Data Integrator - Version 10.1.3.4.5 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Sep-2014***
- When the ODI agent is running as a Windows service and an Essbase interface in ODI is run, an error like the following is seen:
- If an ODI Agent is manually started by using the agent.bat script in <ORACLE HOME>\oracedi\bin\agent.bat then the integration succeeds.
- Please note: If this does not work when using a standalone ODI Agent either then please check that the Essbase client has been installed on the machine where the ODI Agent is running. The Essbase KM User Guide (default location - C:\OraHome_1\oracledi\doc\km\odiess_users.pdf) states that this is a pre-requisite for using MAXL scripts.
1. The ODI Agent is running as a Windows service under a system account.
2. The ODI Agent is running in OPMN.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms