Removing Locks from Database Objects

The server uses a check out facility for database objects (such as calculation scripts, report scripts, and business rules files) to ensure that objects are modified by only one user at one time. By default, objects are locked when you open them to modify them, and then unlocked when you close the object.

You can view and unlock objects, according to your permissions. Users with Administrator permissions can unlock any object. Users without Administrator permissions can unlock only objects that they locked.

Objects in Oracle Hyperion Calculation Manager may be locked when you perform actions on them. To unlock objects, you select the plan type for which you want to unlock objects in the Enterprise View.

To remove a lock from a database:

1. In System View, click the Database Properties icon.
2. In Enterprise View, expand the Oracle Hyperion Planning application type and the application that contains the database for which you want to remove a lock.
3. Right-click the database, and then select Remove Lock(s).