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

SCTS_AIM059 - Overview

• Message type: E = Error

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

• Message number: 059

• 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_AIM059 - Lock mode conflict (&2 <-> &3) for table &1 with SLAPI-entry &4 ?

  The SAP error message SCTS_AIM059 indicates a lock mode conflict for a specific database table. This error typically arises when there are concurrent attempts to access or modify the same database table in different lock modes, which can lead to conflicts. Here’s a breakdown of the components of the error message and potential solutions:
  Cause
  
  Lock Mode Conflict: The error occurs when one transaction is trying to access a table in a mode that conflicts with another transaction's lock mode. For example, if one transaction has an exclusive lock on a table, another transaction trying to read or write to that table may encounter this error.
  SLAPI Entry: The SLAPI (SAP Lock API) entry mentioned in the error message indicates the specific lock request that is causing the conflict. This could be due to a long-running transaction or a deadlock situation.
  Concurrent Access: Multiple users or processes trying to access the same table simultaneously