Unable to obtain lock for registry database

Issue: 

Unable to obtain registry lock when configuring using EPM Configurator

Cause:

Generally, once the configurator is closed lock is released but sometimes due to various reasons the entries in the table are not deleted. This usually happens when running configurator using silent configuration.

Solution:

Go to Hyperion Shared Service Database or Schema and delete values from EPM_REGISTRY_LOCK table.



To list the lock:

select * from EPM_REGISTRY_LOCK;

To delete:
delete from  EPM_REGISTRY_LOCK;


Good to continue configuration now.