My Oracle Support Banner

Planning Data-source Connection UI Error: "The Essbase Connection Failed" Logs: "Error Code Is :0[[ Com.Hyperion.Planning.Olap.Essbaseexception (1030803)" (Doc ID 3008174.1)

Last updated on MARCH 18, 2024

Applies to:

Hyperion Planning - Version 11.2.8.0.000 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.8.0.000 version, Configuration and Administration

The Planning application Data source Connection Failed for Essbase connection.

Installed and configured EPM 11.2.8.
Setting up the data source for Planning for essbase section getting error: The Essbase Connection Failed
Essbase Server is running
Ports are open on Planning
Essbase ports are open.

RTC and Path are all properly installed and set 

UI :ERROR
-----------------------
The Essbase connection failed.

 

ERROR from Planning_WebApp.log : 

---------------------------------------------

[2024-02-12T12:34:21.590+00:00] [Planning0] [NOTIFICATION] [HSP-0000000010] [oracle.EPMHSP.olap] [tid: 86] [userId: ] [ecid: XXXXXXXXXXXXX,0:1] [APP: PLANNING] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: com.hyperion.planning.olap.HspEssbaseEnv] [SRC_METHOD: init] Setting ARBORPATH environment variable to /u01/Oracle/Middleware/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0
[2024-02-12T12:34:21.606+00:00] [Planning0] [NOTIFICATION] [] [oracle.EPMHSP.adf.manageds.view.backing] [tid: 86] [userId: ] [ecid: XXXXXXXXXX,0:1] [APP: PLANNING] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: com.hyperion.planning.adf.manageds.view.backing.EditDatasourceBean] [SRC_METHOD: checkESS] The Essbase connection failed.

 

AND 

 

[2024-02-13T06:49:28.521+00:00] [Planning0] [TRACE:16] [] [oracle.EPMHSP.planning] [tid: 112] [userId: <anonymous>] [ecid: XXXXXXXXXXXXXXX,0:1] [APP: PLANNING] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: com.hyperion.planning.HspJSHomeImpl]

[SRC_METHOD: TestEssConnection] Error Code is :0[[
com.hyperion.planning.olap.EssbaseException (1030803)
at com.hyperion.planning.olap.HspEssbaseMainAPI.EssInit(Native Method)
at com.hyperion.planning.olap.HspEssConnection.<init>(HspEssConnection.java:60)
at com.hyperion.planning.olap.HspEssbaseJniOlap.getConnection(HspEssbaseJniOlap.java:2879)
at com.hyperion.planning.HspJSHomeImpl.TestEssConnection(HspJSHomeImpl.java:2005)
at com.hyperion.planning.adf.admin.datacontrol.HspPlanningSysAdminDC.checkEssConnectivity(HspPlanningSysAdminDC.java:470)
at com.hyperion.planning.adf.admin.datacontrol.HspPlanningSysAdminDC.checkEssConnectivity(HspPlanningSysAdminDC.java:475)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.