The maximum time that a user can hold a lock on data is set in the Application Properties window. Occasionally, you may need to release a lock before the allotted time expires. For example, if you are calculating a database that has active locks on data, and the calculation encounters a lock, the calculation must wait. If you release the lock, the calculation can resume.
You can manage data locks at the Essbase Server level. You need Administrator permissions to view and unlock user locks on data.
Releasing a user's lock disconnects the user from the current session.
User locks on data are different from locks on database objects, such as calculation scripts and rules files. For more information on object locks, see Locking and Unlocking Objects.
Note: | Data locks do not apply to aggregate storage databases. |
To unlock one or more user locks on data:
In Enterprise View or a custom view, select the Essbase Server for which you want to manage data locks.
Right-click and select Edit, then Locks.
In the Locks window, select a row.
To select multiple adjacent rows, select the first row, press Shift, and select the last row.
To select multiple nonadjacent rows, select the first row, press Ctrl, and select the other rows.
Click Unlock.
Click OK.
To refresh the list of data locks, click Refresh.
listlocks (ESSCMD) in the Oracle Essbase Technical Reference
removelocks (ESSCMD) in the Oracle Essbase Technical Reference