Planning Error: "The application version is invalid. Existing Version: 9.3.1, Expected Version: 11.1.1.3." followed by "An error occurred while processing this page. Check the log for details."

(Doc ID 1052219.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Planning - Version: 9.3.1.0.00 to 11.1.1.3.00 - Release: 9.3 to 11.1
Information in this document applies to any platform.

Symptoms

Problem migrating Planning 9.3.1 application to 11.1.1.3.


When user tries to log in first time they are notified that the version is incompatible and gives option to migrate; user enters the user  name and password and click on migrate they get error below in the Planning running in foreground mode.

invalid login credentials provided please check if user exists in domain or password is correct
java.lang.exception general error
hsplogon.handle (unknown source)

Changes

User trying to migrate a Planning app from 9.3.1 to 11.1.1.3 fails after the following steps:

  1. Create a new relational database for 11.1.1.3 Planning App
  2. Create a datasource for the 11.1.1.3 app
  3.  Create blank application
  4.  Go into the database tables for the planning app and copy the SID value against user 50001 in the HSP_USERS table
  5. Go into the database system tables and HSPSYS_APPLICATION , clear out the version field for the application created
  6. Stop Planning services
  7. Restore the 9.3.1 planning relational database from backup to 11.1.1.3
  8. Go into the HSP_USERS tables and copy back the SID value for user id 50001
  9. Start planning 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