Unlocking Applications

Unlocking Applications

Many time when we try to do some operation like loading metadata or data via ODI , while refreshing data to Essbase etc we get error Planning application is locked. Few Ex:

com.hyperion.planning.HspCubeRefreshInProgressException: Cannot complete your request because the database is being refreshed.

com.hyperion.odi.planning.ODIPlanningException: com.hyperion.planning.ObjectIsLockedException 

When ever we perform an operation where planning need to put a lock on any object an entry goes to HSP_LOCK table. Planning enters a record in this table when it acquires a lock and deletes the record the moment lock is released. 

Lets refresh our database and check if we get any entry in HSP_LOCK table:

Here are the records of HSP_LOCK table for App1:

I clicked refresh database for my application App1, let go back and check the records of this table:

Once the refresh operation is complete:

Planning clears the record from this table:

Now lets manually enter a record in HSP_LOCK table

Lets refresh the database

If you manually delete the record with restarting services and try refreshing agiain

Lets run HSP_UNLOCK utiilty:

Tried refreshing the application after executing HspUnlock refresh was successful.

Occasionally 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.

Here is the link for more information on above:

http://docs.oracle.com/cd/E17236_01/epm.1112/hp_admin/ch04s02.html

Cheers..!!!