Deleting Locks for Integration Services Users

If you are certain that the other users who have read or write locks on an OLAP model or a metaoutline that you want to save do not need their locks, delete their locks from the CB_CONCURRENCY table.

Caution!

Make sure the users do not need their locks before you delete the locks.

  To delete read and write locks on OLAP models or metaoutlines:

  1. Determine which users have locks.

    See Viewing Integration Services Users with Locks.

  2. Delete the rows containing the unwanted locks.

    For example, to delete all locks held by the sa user, issue the following DELETE statement in the OLAP Metadata Catalog database, using the tools for the data source:

    DELETE FROM CB_CONCURRENCY WHERE CB_USER_NAME = 'sa'