Hyperion Planning application can get unlocked at times. If, for example, users abnormally exit planning application, or if planning dump import is done without caution, etc, Planning application can be locked.
We can use the UNLOCK APPLICATION UTILITY (HspUnlockApp.cmd) to unlock the application in such situations. The HspUnlockApp.cmd utility is available in the Planning bin, which is usually the "\\PlanningServer\d$\oracle\Middleware\user_projects\epmsystem1\Planning\planning1" directory, and the utility clears all records in the HSP_LOCK table.
These are the steps that need to be taken to run this utility to unlock Planning Application.
Before running the utility, make sure:
1. The users are no users connected to Planning application.
2. Planning services are not running
Process to run the script:
1. Open a command prompt.
2. Change directory to the Planning1 directory, say for example, "\d$\oracle\Middleware\user_projects\epmsystem1\Planning\planning1" where I have the HspUnlockApp.cmd file.
3. Type in HspUnlockApp.cmd servername username password application_name.
4. If asked for password, type it in and ENTER.
5. Check for logs to see if the unlock process was successful or if it failed.
In case the utility does not work, we can clear out the HSP_LOCK table manually and then restart Planning.
We can use the UNLOCK APPLICATION UTILITY (HspUnlockApp.cmd) to unlock the application in such situations. The HspUnlockApp.cmd utility is available in the Planning bin, which is usually the "\\PlanningServer\d$\oracle\Middleware\user_projects\epmsystem1\Planning\planning1" directory, and the utility clears all records in the HSP_LOCK table.
These are the steps that need to be taken to run this utility to unlock Planning Application.
Before running the utility, make sure:
1. The users are no users connected to Planning application.
2. Planning services are not running
Process to run the script:
1. Open a command prompt.
2. Change directory to the Planning1 directory, say for example, "\d$\oracle\Middleware\user_projects\epmsystem1\Planning\planning1" where I have the HspUnlockApp.cmd file.
3. Type in HspUnlockApp.cmd servername username password application_name.
4. If asked for password, type it in and ENTER.
5. Check for logs to see if the unlock process was successful or if it failed.
In case the utility does not work, we can clear out the HSP_LOCK table manually and then restart Planning.
No comments:
Post a Comment