Hyperion Planning Migration from 9.2.x to 11.1.1.x Fails at Login

(Doc ID 1313168.1)

Last updated on JULY 28, 2016

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

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