Unable to Validate Data Source In Planning Administration due to Environment Variables Picking Wrong ARBORPATH (Doc ID 2096146.1)

Last updated on JANUARY 19, 2016

Applies to:

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

Symptoms

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

ERROR
-----------------------
[2015-12-28T10:20:59.813+00:00] [Planning0] [NOTIFICATION] [HSP-00009] [oracle.EPMHSP.olap] [tid: 12] [userId: ] [ecid: 00iXcZlpNVJ5yW0LryXBiY0005og0000Ak,0:1] [APP: PLANNING#11.1.2.0] [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\11.1.2.0
[2015-12-28T10:20:59.894+00:00] [Planning0] [NOTIFICATION] [] [oracle.EPMHSP.adf.manageds.view.backing] [tid: 12] [userId: ] [ecid: 00iXcZlpNVJ5yW0LryXBiY0005og0000Ak,0:1!
 ] [APP: P
LANNING#11.1.2.0] [URI: /HyperionPlanning/faces/AppWizardTF/AppWizardMain] [SRC_CLASS: com.hyperion.planning.adf.manageds.view.backing.EditDatasourceBean] [SRC_METHOD: checkESS] The Essbase connection failed.

Changes

 Environment Variables got changed 

Cause

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