How To Fix SCTS_AIM061 - Lock mode conflict (&2 <-> &3) for table &1 with SLAPI-entry &4

SAP Error Message - Details

• Message type: E = Error

• Message class: SCTS_AIM - Messages for the AIM meta data repository

• Message number: 061

• Message text: Lock mode conflict (&2 <-> &3) for table &1 with SLAPI-entry &4

What causes this issue?

For each after import method (AIM), the owner has to declare all tables
the AIM reads from or writes to. If an AIM calls an API then the AIM
owner has to declare this fact and the API owner has to declare the
tables the API is reading from and writing to. These declarations are
made in transaction SLAPI.
Furthermore, for each table accessed by an API, the owner of the API has
to declare if and how the content of the table is protected against
write access by the productive application running in parallel with the
ZDO upgrade.
The API owner provides this information by assigning a "LOCK_MODE" to
each of these tables. The possible values of the LOCK_MODE and their
meanings are described
<DS:DE.OB_LOCK_MODE>here.</>
If different AIMs or APIs declare access to the same table and use
different values of LOCK_MODE, then the system will compute a common
value which is suitable for both APIs or AIMs. Some combinations of
LOCK_MODE values are, however, incompatible to each other. In this case,
the system will report an error.

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

The pairs of compatible and incompatible lock modes can be depicted in
the following matrix:
||' '| X | P | R | U | W
------------------------------------
' '||' '| ! | ! | ! | ! | !
X || ! | X | P | R | U | !
P || ! | P | P | R | ! | ! (! represents a pair of
R || ! | R | R | R | ! | ! incompatible lock modes)
U || ! | U | ! | ! | U | !
W || ! | ! | ! | ! | ! | W
In the current case, table &V1& is declared with two incompatible lock
modes (&V2& and &V3&). The API with the conflicting declaration is &V4&
(see transaction SLAPI -> select &V4& and navigate to "used database
tables").

System Response

In a ZDO upgrade, the tables cannot be correctly classified. This can
lead to a failure of the upgrade.

How to fix this error?

Adjust the LOCK_MODE values for table &V1&.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SCTS_AIM061 - Lock mode conflict (&2 <-> &3) for table &1 with SLAPI-entry &4 ?

  The SAP error message SCTS_AIM061 indicates a lock mode conflict for a specific database table. This error typically arises when two or more processes are trying to access the same table in incompatible modes, leading to a deadlock or lock contention situation. Here’s a breakdown of the components of the error message and potential solutions:
  
  Cause:
  
  Lock Mode Conflict: The error message indicates that there is a conflict between two processes trying to access the same table (&1) with different lock modes. The placeholders &2 and &3 represent the conflicting lock modes, while &4 refers to the specific SLAPI (Service Layer API) entry involved.
  Concurrent Access: This can happen in scenarios where multiple transactions or background jobs are trying to read/write to the same table simultaneously.
  Long-Running Transactions: If one transaction holds a lock for an extended period, it can block other transactions from accessing the same resource.
  
  
  Solution:
  
  
  Identify the Locking Processes:
  
  Use transaction SM12 to