view all update locks in SAP

Viewing Update Lock Information

      Occasionally, due to a dropped user session or some other unknown

      reason, an update transaction fails.  When this happens, locks

      placed on resources may not be released.  If an object was marked

      as currently being updated, and the update fails, the lock may

      still be present in the SAP system.  Any other transactions

      attempting an update on the “locked” object fail.  Database errors,

      including SAPSQL_ARRAY_INSERT_DUPREC errors, appear in the system

      log.  To remove these update locks, you should try to force the

      update to complete.  If the update cannot be forced to completion,

      the lock should be removed from the object.

1.               Log on to any client in the appropriate SAP system.

2.               Go to transaction SM13.

3.               On the Update Records: Main Menu screen, if you are looking for the update locks produced by a specific user and/or in a specific client, type in the Client and/or User.  Using a From date and To date range can help as well.  But if the originating lock happened some time ago, using a date range will not help.  Normally, there aren’t that many “hanging” update locks at one time, so don’t worry about being too specific.  When you have entered all your information, press Enter.

4.               The Update Records screen contains a list of outstanding update records matching your selection criteria.  If the list is empty, go back to the previous screen and open your search by using “*” in client and user, and a date range of 01-01-2000 through 12-31-2010.  If you still get no results, there are no incomplete update records.

5.               The best way to resolve incomplete update records is to try to force them to completion.  From the top-most menu of the Update Records screen, click Update records → Update → All records.

6.               You will see an Update – Updating update requests which have not yet executed popup.  If, after reading this information message, you decide that deleting the update records would be a wiser decision, skip to step 7.  Otherwise, click the green √ picture-icon.  You will be given one last chance to stop via a Update selected records popup.  Click Yes to start the update.

7.               If the update records are fairly old (a day or so) and/or the update force produces an error, or you are unsure whether forcing the update record to completion is the wisest choice, forcing the update may not be an option.  If this is the case, deleting the update lock is probably your best course of action.  From the top-most menu of the Update Records screen, click Update records → Delete → All records.  You will be given an opportunity to change your selection criteria in the Delete Update Records popup.  Click the green √ picture-icon to continue.  You will be given one last chance to stop via a Delete data will be lost popup.  Click Yes to start the delete.

8.               You will not receive a confirmation message after the update or delete.  You may now leave the SM13 transaction.