Correcting Problems with Locks

Due to the complex nature of Integration Services and the other software components with which it interacts, you may experience problems that result in locks not being released from OLAP models or metaoutlines. Unreleased locks can result in an inability to save, even if no other users are on the system. Unreleased locks can also prevent you from opening an OLAP model or metaoutline.

If you suspect that unreleased locks remain from previous sessions, delete the locks by selecting Servers, then OLAP Metadata Catalog, then Delete Locks. Deleting locks from the menu removes only your locks; it does not delete locks held by other users.

If you suspect that unreleased locks remain from other user sessions, check to see which users have locks. See Viewing Integration Services Users with Locks. If you are convinced that some or all of the locks are from terminated user sessions, delete them. See Deleting Locks for Integration Services Users.