Common Issues Using Hyperion Planning after Upgrade to Planning 11.1.2.4


1.  Planning cannot be accessed via Workspace and the following error is found in the Planning_WebApp.log file:
Servlet failed with Exception
java.lang.RuntimeException: Your session has timed out or was terminated by the application owner or an administrator. Please log on again.

2. Forms Folder cannot be expanded

3. No forms are visible in the Planning application

4. Attempting to export Planning applications using LCM results in the following error:
Source: APPNAME (Application) Destination: HP-APPNAME (File System)
EPMLCM-14000: Error reported from Hyperion Planning.
/Configuration/Adhoc Options:- Error loading objects from data source: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]The multi-part identifier “o1.object_id” could not be bound.
/Relational Data/Tablet Access:- Error loading objects from data source: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]The multi-part identifier “o1.object_id” could not be bound.

 

Reason- The required ADF patches for 11.1.2.4 have not been applied. These should be installed during the upgrade by the system

To Fix-

The solution is to install the ADF Patches manually on the Planning server
The patches are: 16964825, 18514458 and 20326778

Assuming EPM is installed to E:\Oracle\Middleware
Edit E:\Oracle\Middleware to your specific location in all instructions below

Check which ADF Patches are applied:

1. Open Command Prompt.
2. CD to E: drive
3. run E:\Oracle\Middleware\EPMSystem11R1\OPatch\opatch.bat lsinventory -oh E:\Oracle\Middleware\oracle_common -jdk E:\Oracle\Middleware\jdk160_35 | findstr -i applied

Roll back any patches you find applied:

1. Stop All EPM Services on the Planning server
2. Open command prompt
3. CD to E:\Oracle\Middleware\oracle_common\OPatch
4. run opatch rollback -id 123456 -oh E:\Oracle\Middleware\oracle_common -jdk E:\Oracle\Middleware\jdk160_35

Apply the new ADF patches:

1. Stop All EPM Services on the Planning server
2. Open command prompt
3. CD to E:\Oracle\Middleware\oracle_common\OPatch\Patches\16964825
4. run E:\Oracle\Middleware\EPMSystem11R1\OPatch\opatch apply -oh E:\Oracle\Middleware\oracle_common -jdk E:\Oracle\Middleware\jdk160_35

5. CD to E:\Oracle\Middleware\oracle_common\OPatch\Patches\18514458
6. run E:\Oracle\Middleware\EPMSystem11R1\OPatch\opatch apply -oh E:\Oracle\Middleware\oracle_common -jdk E:\Oracle\Middleware\jdk160_35

7. CD to E:\Oracle\Middleware\oracle_common\OPatch\Patches\20326778\oui
8. run E:\Oracle\Middleware\EPMSystem11R1\OPatch\opatch apply -oh E:\Oracle\Middleware\oracle_common -jdk E:\Oracle\Middleware\jdk160_35

9. Start All EPM Services

Hope this will help.

Thanks,

~KKT~

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s