1. Administrator's Guide
  2. Managing Planning Databases
  3. Unlocking Applications

Unlocking Applications

Occasionally Oracle Hyperion Planning applications can become locked, for example, if users abnormally exit the application and Planning. The Unlock Application utility clears all records in the HSP_LOCK table. You must run the utility from the Planning application server.

Ensure there are no users connected to the Planning application before running the utility. To confirm this, launch the task manager on the Planning server and ensure there are no processes called hsxser~1 (hsxserver) or hspds.

To unlock Planning applications:

  1. Locate the HspUnlockApp.cmd utility by navigating to the planning1 directory using the command line.

    For the full path to planning1, see About EPM Oracle Instance.

  2. Enter HspUnlockApp.cmd[-f:passwordFile] SERVER_NAME USER_NAME PASSWORD APPLICATION_NAME, where application name is the application to unlock.

    Optional: If an encrypted password file is set up, use [-f:passwordFile] as the first parameter in the command line to read the password from the full file path and name specified in passwordFile. See Suppressing Password Prompts in Planning Utilities.

  3. If prompted, enter your password.
  4. Check the application event logs using the Event Viewer in the console application log to determine whether a success or failure event is reported. For information about logs, see the Oracle Enterprise Performance Management System Installation and Configuration Troubleshooting Guide.