How To Fix SHDI020 - Tables locked by user &1.

SHDI020 - Overview

• Message type: E = Error

• Message class: SHDI - Texts Image archive Transaction variants

• Message number: 020

• Message text: Tables locked by user &1.

What causes this issue?

You attempted to edit a root node in the change mode.
Someone else is currently editing this root node.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Wait until the other user completes editing and releases the block.

Procedure for System Administrators

The key root directory is locked in table SHDFOLTREE.
If necessary, this lock entry can be removed with transaction SM12.

Error message extract from SAP system. Copyright SAP SE.

SHDI020 - Details

• The SAP error message SHDI020 indicates that a specific table is locked by a user, which prevents other users from accessing or modifying that table. This can occur in various scenarios, such as during data updates, batch processing, or when a user is performing a transaction that locks the table for exclusive access.
  
  Cause:
  
  User Lock: A user is currently accessing or modifying the table, which results in a lock being placed on it.
  Long-Running Transactions: A transaction that takes a long time to complete may hold a lock on the table longer than expected.
  Deadlocks: In some cases, deadlocks can occur where two or more transactions are waiting for each other to release locks.
  Background Jobs: Background jobs that are processing data may also lock tables, preventing other users from accessing them.
  
  
  Solution:
  
  
  Identify the Locking User:
  
  Use transaction code SM12 to view the list of locks in the system. You can filter by the table name