How To Fix DI804 - Lock mode & for table & is not allowed

DI804 - Overview

• Message type: E = Error

• Message class: DI - Dictionary messages: Indexes

• Message number: 804

• Message text: Lock mode & for table & is not allowed

What causes this issue?

Only the values 'E' (= Exclusive), 'S' (=Shared), 'X' (=Exclusive, not
cumulative) and ' ' (= do no lock) are allowed for the
<DS:TX.DDDOK_ENQU_MODE>lock mode</> of a base table in a lock object.
In the current lock object, however, another lock mode is maintained
for a base table.

System Response

The action was cancelled.

How to fix this error?

Check in the maintenance transaction of the ABAP/4 Dictionary that all
base tables have an allowed lock mode.

Error message extract from SAP system. Copyright SAP SE.

DI804 - Details

• The SAP error message DI804 typically indicates that there is a lock mode issue with a specific table in the database. This error occurs when an operation attempts to access a table in a way that is not permitted due to the current lock settings. Here’s a breakdown of the cause, potential solutions, and related information:
  
  Cause:
  
  Locking Mechanism: SAP uses a locking mechanism to prevent data inconsistencies when multiple users or processes try to access or modify the same data simultaneously. If a table is locked in a certain mode (e.g., exclusive lock), other operations that require a different lock mode (e.g., shared lock) will be blocked.
  Long-Running Transactions: If a transaction is taking too long to complete, it may hold locks longer than expected, causing other transactions to fail with this error.
  Incorrect Lock Mode: The operation being performed may require a different lock mode than what is currently set for the