Hyperion Planning 11.1.2.4 “Error connecting to database connection DRPLAN:Plan1: [0] MSG_ADM_ERR_LOADING_OBJECT…”

During a recent implementation of a highly distributed and highly available 11.1.2.4 Hyperion Planning environment we came across the following error “Error connecting to database connection DRPLAN:Plan1: [0] MSG_ADM_ERR_LOADING_OBJECTcom.hyperion.ap.hsp.thin.HspException”

ISSUE:

In version 11.1.2.4, an intermittent error occurs when setting up a Financial Reporting (FR) data source connection to Hyperion Planning when you have multiple instances of Hyperion Planning running on the same server or multiple servers.

CAUSE:

Bug in Hyperion Planning when it is vertically or horizontally scaled.

RESOLUTION:

We were provided with a PSE. The number is 21650002.

Check to see if it is available on Oracle Support otherwise you will have to request it from them through an SR.

The change is in the HspAdm.jar file that resides under ADM and ADM-64 path, after applying issue was resolved.

Patch Link: Click Here

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s