My Oracle Support Banner

Hyperion Planning Migration from 9.2.x to 11.1.1.x Fails at Login (Doc ID 1313168.1)

Last updated on JULY 31, 2018

Applies to:

HyperionPlanning - Version 9.2.0.0.00 to 11.1.1.3.00 [Release 9.2 to 11.1]
Information in this document applies to any platform.

Symptoms

Migration is being done between two environments: from a 9.2.x to a 11.1.1.3 using the following procedure at the end of which login fails with the following error in the logs:

java.sql.SQLException: [Hyperion][SQLServer JDBC Driver][SQLServer]Invalid object name 'HSP_SYSTEMCFG'.

Procedure followed:
1 - Create a dB on the server 11.1.1.3 with the same name
2 - Create a Planning application using the dB created
3 - Refresh Planning dB
4 - Stop application
5 - Export the 9.2.0 relational dB and copy the application folder under Essbase Server app
6 - Replaced the dB and folder on the new system with the 9.2.0 structures
7 - Start Planning 11.1.1.3
8 - Register application with Shared Services

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
References

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