Hyperion Planning: Unable to Validate Data Source in Planning Administration due to Environment Variables ARBORPATH

(Doc ID 2096146.1)

Last updated on JULY 17, 2018

Applies to:

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


Unable to validate data source in planning administration. Encounter an Essbase connection failed error . Verified and found all the credentials correct. 

[2015-12-28T10:20:59.813+00:00] [Planning0] [NOTIFICATION] [HSP-00009] [oracle.EPMHSP.olap] [tid: 12] [userId: ] [ecid: 00iXcZlpNVJ5yW0LryXBiY0005og0000Ak,0:1] [APP: PLANNING#] [URI: /HyperionPlanning/faces/AppWizardTF/AppWizardMain] [SRC_CLASS: com.hyperion.planning.olap.HspEssbaseEnv] [SRC_METHOD: init] Setting ARBORPATH environment variable to D:\Oracle\Middleware\EPMSystem11R1;D:\Oracle\Middleware\ohs\common\EssbaseRTC-64\
[2015-12-28T10:20:59.894+00:00] [Planning0] [NOTIFICATION] [] [oracle.EPMHSP.adf.manageds.view.backing] [tid: 12] [userId: ] [ecid: 00iXcZlpNVJ5yW0LryXBiY0005og0000Ak,0:1!
 ] [APP: PLANNING#] [URI: /HyperionPlanning/faces/AppWizardTF/AppWizardMain] [SRC_CLASS: com.hyperion.planning.adf.manageds.view.backing.EditDatasourceBean] [SRC_METHOD: checkESS] The Essbase connection failed.


 Environment Variable EPM_ORACLE_HOME on Planning server is incorrect


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