Resolution:
Description:
=========
This FAQ addresses difficulties removing locks from potentially hundreds of resources stored in XML Canon when a user no longer employed with an organization.

Environment:
==========
XML Canon: 3.1 and 3.2
OS: All

Resolution:
===========
Run the following SQL against the XML Canon database to break all locks owned by the user. To run the SQL, you must either have the appropriate permissions to the XML Canon database or seek assistance from the DBA.

1. Run the following SQL query to obtain the USER ID based on the user name:

select user_id, l.* from ess_lock l, ess_user u where l.user_id=u.id and u.username='UserName';

2. Run the following SQL query to remove all locks obtained by the user based on the user’s id (obtained from step 1):

delete from ess_lock where user_id=UserID;

3. commit;

Attachments:
===========
None

A user left the organization and I’m unable to unlock resources he/she locked from the XML Canon Web UI.