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 NOVEMBER 06, 2019

Applies to:

Hyperion Planning - Version to [Release 9.2 to 11.1]
Information in this document applies to any platform.


Migration is being done between two environments: from a 9.2.x to a 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 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
8 - Register application with Shared Services


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

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