X

Proactive insights, news and tips from Oracle Hyperion EPM and BI Support. Learn Oracle from Oracle.

How to Integrate Essbase Analytics Link (EAL) 11.1.2.2.500 with Enterprise Performance Management (EPM) 11.2

Tanya Heise
Sr Principal Technical Support Engineer

How to Integrate Essbase Analytics Link (EAL) 11.1.2.2.500 with Enterprise Performance Management (EPM) 11.2

Thank you to Ilya Tebelev for contributing to this post!

General notes:

  • Deployment of EAL on WebLogic 12C with Java 1.8 (used by EPM 11.2) is not successful. Therefore, EAL 11.1.2.2.500 does not work with EPM 11.2. EAL is officially supported on EPM 11.1 using WebLogic 11G and Java 1.6.
  • Development of EAL is not active, so I tried to find workaround to make EAL work with EPM 11.2. The workaround is: prepare a standalone machine that is dedicated to an EAL 11.1.2.2.500 installation on EPM 11.1 WebLogic domain with EPM 11.1 HSS and HFM Clients, but make sure the database of this EPM 11.1 installation points to the database repository of EPM 11.2.
  • EAL must be deployed as a server on the EPM 11.1 WebLogic domain and must use Shared Services and HFM APIs (that is a part of Foundation Services Java Web Applications and HFM Management SDK deployment on WebLogic) of EPM 11.1 to communicate with EPM 11.2.
  • EAL security and provisioning will be done by Shared Services 11.2, identified by "Shared Services and a Registry database" that is pointed by the local EPM 11.1HSS Client configuration.
  • EAL 11.1.2.2.500, unlike previous versions of product, can communicate with only one HFM Server that is registered in Shared Services where the EAL managed by. In our case it will be HFM 11.2 that is registered with HSS 11.2 as part of EPM 11.2.

 

EPM 11.1.2.4.xxx installation:

* Use the latest version of EPM 11.1.2.4 available on MOS

Foundation Services Client installation:

 

HFM Client installation:

 

EPM 11.1 Configuration:

Configure:

  • Hyperion Foundation
    • Common Settings
    • Database
    • Deploy to Application Server
  • Financial Management

Configure the Shared Services database to point to a previously installed and configured EPM 11.2 Shared Services database (where HFM Server 11.2 is registered)

On the following screen, un-check Create of Windows Services for configured components, as it will not run.


 
Deploy a new Web Server locally. It will install the WebLogic Server locally with the EPM 11.1 domain.


 
Deploy Foundation Services on WebLogic locally. It will deploy Foundation Services 11.1 libraries that will allow to EAL communicate with HSS of EPM 11.2.

Finish Configuration of EPM 11.1.2.4.

 

Install HFM 11.1 Patch Set Update (to allow integration with EAL):

* Installed HFM PSU should be not older then Patch Set Update 20455650

CMD>cd "C:\Oracle\Middleware\EPMSystem11R1\OPatch"
CMD>opatch apply 28511735 -oh C:\Oracle\Middleware\EPMSystem11R1 -jre C:\Oracle\Middleware\jdk160_35

 

Install and Configure EAL:

Install EAL in the regular way. Here are some important points regarding EAL installation and configuration.

Installation of EAL:

Choose a local WebLogic directory.

Configuration of EAL:

Note: Local Web Logic Admin Server has to run
Provide local WebLogic Server details:


 
Provide credentials for HSS in EPM 11.2, but local EPM (i.e., 11.1) instance Home.

 

There are several known issues in integration of these two products.

1. Integration of EAL 11.1.2.2.500 with EPM 11.2 fails with error ORA-01017 or  ORA-28040 when Oracle Database 12C or later is used

Symptoms: "ORA-28040: No matching authentication protocol" or "ORA-01017: invalid username/password" in %HFS_HOME%\Work\config.log, eal.log or dss.log. This issue happens at any integration stages, like EAL configuration, EAL Server start, HFM Server connection while an EAL Bridge open, DSS database creation, EAL Target Design Grid mapping creation, EAL data extraction to RDBMS.

By default, Oracle Database 12c Release 2 (12.2) and later releases are upgraded to an Exclusive Mode. Exclusive Modes do not support case-insensitive password-based authentication.
Accounts that have only the 10G password version become inaccessible when the server runs in an Exclusive Mode. To resolve this problem, you should allow 10G password access to specific user.

Solution:

  • Configure the system so that it is not running in Exclusive Mode by editing the setting of the $ORACLE_HOME/network/admin/SQLNET.ORA parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER to a level appropriate for affected accounts: SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

Note: As for taking effect, you don't have to restart listener, the new incoming connections will apply the new values.

  • Connect to Oracle as SYSDBA and run the following for each of users: Foundation Services database user, HFM database user, EAL database user, EAL Data Store user:

        >SELECT USERNAME, PASSWORD_VERSIONS FROM DBA_USERS WHERE USERNAME='<user>';
        USERNAME          PASSWORD_VERSIONS
        <user>                  11G 12C
        >alter user <user> password expire;
        >alter user <user> identified by <user password>;
        NB: Pay attention that the password should not be enclosed in single quotes.
        >SELECT USERNAME, PASSWORD_VERSIONS FROM DBA_USERS WHERE USERNAME='<user>';
        USERNAME          PASSWORD_VERSIONS
        <user>                   10G

 

2. HFM Server status is "Not Available" while opening an EAL Bridge with error EPMHFM-69451

Symptoms: EAS Console message is "Financial Management status is unavailable: An unexpected error occurred" and the following appears in %HFS_HOME%\Work\eal.log: "EPMHFM-69451: No server specified for datasource process for application:<HFM Application>".
Solution: It is a known issue - refer to Bug 30770671 "EPMHFM-69451: EAL cannot connect to HFM application if it's not running (java api)".In EPM 11.2, if HFM application is not running, EAL cannot connect to it. To resolve the issue, user should start corresponding HFM application manually through EPM Workspace.

3. HFM Server status is "Not Available" while opening an EAL Bridge with error EPMHFM-65599

Symptoms: EAS Console message is "Financial Management status is unavailable: An unexpected error occurred" and the following appears in %HFS_HOME%\Work\eal.log: "EPMHFM-65599: Invalid HIT Registry property".
Solution: This is known issue: BUG 30065194 "FIRST SESSION ATTEMPTING TO ACCESS HFM APPLICATION AFTER SERVICES RESTART RETURNS ERROR". If you refresh the "Summary" tab of a Bridge - status of HFM Server will become "Available".  

4. Report on Transparent Partition Essbase database fail with HR#13218/Error(1008108)

Symptoms: When running report on Essbase database that connected with DSS database by Transparent Partition - report fail.
For example, Smart View report error:

The same message printed in <Essbase Application>.log file:
------------------
Hybrid Aggregation Mode enabled.
msg from remote site [[Thu Feb 04 15:57:58 2021]slc05gyd/LL_AUN/LL_1/admin/Error(1008108) Essbase Internal Logic Error [Error in query initialization, see log file for details]]
An error [1040022] occurred in Spreadsheet Extractor.
------------------
and following appears in %HFS_HOME%\Work\dss.log: "HR#13218: Not expected format of grid query (REQ_DDB_RPC) packet after regionID".
Solution: set in essbase.cfg:
ASODYNAMICAGGINBSO <Essbase applcaition> NONE
and restart Essbase application.

 

============================================================================================

References:

 

Join the discussion

Comments ( 3 )
  • karthikeyan p Monday, July 27, 2020
    Thanks for the information on how to Integrate EAL with EPM 11.2.2
  • Karin Tuesday, July 28, 2020
    Where does the Essbase server (11.2 version?) and EAL-DSS (data sync) server go in this suggested setup? For the Essbase authentication through EAL, Essbase and APS & EAS would have to be registered in the same Shared Services (11.2.x presumably) as HFM. EAL needs the ESSBASEPATH, so Essbase client needs to go on the EAL server too.

    In any case the whole 'integration' looks fragile and full of mismatching css and interop jar's of 2 environments, and liable to stop working if HSS or HFM gets an extra patch on.
  • admin Wednesday, July 29, 2020
    Hi Karin, I reached out to Ilya about this. Below are his responses:
    1. Essbase Server 11.2. It can be installed in EPM 11.2 system, but not on EAL-EPM11.1 box, as I am not sure that Essbase 11.2 is compatible (there is a good chance that it does compatible, but user should test it by himself) with EPM 11.1 deployment.
    Regarding DSS, you can install it on any environment (EPM 11.1, EPM 11.2 or even non-EPM environment), as it does not dependent on EPM installed locally.
    2. EAL bring in its installation Essbase Java API and ECCMD client, so you do not need Essbase Client on EAL box at all. From another side, you can tell EAL to use APS 11.1 Java APIs by providing APS URL.
    3. Right now, HSS (css, interop) and HFM (HFM SDK) Clients of 11.1 are compatible with ones of EPM 11.2. Advised integration is tested in internal systems and found as working. Right now, this is only solution for integration of EAL 11.1.2.2.500 with EPM 11.2 and no other is expectable.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.