Hello,
There is a need to restore a Hyperion Planning application from the relational database backup to a different environment, and i was wondering if it is possible to create a new HP application in the test environment, and then modify the datasource to point to the old backup db.
I have the backup of the relational databases of all hyperion planning modules, including HP_APP_bck that holds the relational metadata for a Hyperion Planning application that was initially hosted on a Production environent.
These databases reside in "Prod_SqlServer", so i :
- Created in my "Test" environment a datasource that points to the test Sql server,
- Created a Hyperion Planning application on my test environment,
- And then changed the datasource to point to the backup of the relational database of the production environment. In order to do this the following tables were modified:
- SYS_PLAN.HSPSYS_DATASOURCE.app_id
- SYS_PLAN.HSPSYS_DATASOURCE.rdb_server_url
- SYS_PLAN.HSPSYS_DATASOURCE.db_catalog_name
- APP.HSPSYS_APPLICATION.app_id
- APP.HSP_SYSTEMCFG.eie_server
- The above modifications, in summary, consisted of replacing all references in the Prod application db to the prod server with the test server, and replacing the application_id of test server with the one from the Prod backup.
After the described changes, i attempted to open the Planning app, only to receive the following messages
Error 403--Forbidden
[Planning0] [TRACE] [] [oracle.EPMHSP.planning] [tid: 18] [userId: <anonymous>] [ecid: 00iw_26vH63Fw00Fzzw0w00000vK0000NB,0:1] [APP: PLANNING#11.1.2.0] [SRC_CLASS: HspEnterDataHelper] [SRC_METHOD: Handle] [[
com.hyperion.planning.HspRuntimeException: Your session is not valid. Please logon again.
Are additional modifications needed? I failed to find any reerences to the application id anywhere else (HSS etc)
Thank you for sharing your thoughts on this