How To Fix DMC_RT_MSG235 - L'index secondaire contient des doublons

SAP Error Message - Details

• Message type: E = Error

• Message class: DMC_RT_MSG - DMC: Runtime Object Messages

• Message number: 235

• Message text: L'index secondaire contient des doublons

Quelle est la cause de ce problème?

The system cannot either insert a record or update a record in the
target system table, as this would violate a unique secondary index for
the table.

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

Réponse du système

The system stops the transfer of records to the target system.

Comment corriger cette erreur?

By default, to improve performance, the system first reads the entries
from the logging tables in the order of the key fields of the source
table, then reads the entries in the order of the key field of the
logging table (field IUUC_SEQUENCE). This means that the order in which
changes occur in the source system is not considered, which could result
in a potential conflict for the secondary index in the target system. To
preserve the order of the changes in the source system, you can
configure SAP LT Replication Server such that the entries are only read
from the logging table in the order of field IUUC_SEQUENCE.
Two options are possible:
Remove the unique secondary index from the target table<(>,<)> or change
it to a non-unique secondary index. If necessary<(>,<)> reset the status
of the table in the central system. The central system will start
replicating data from the source system table to the target system table
again.
If you want to keep the unique secondary index in the target system<(>
,<)> set the field READ_SEQU_ORDER in table IUUC_PERF_OPTION to ?X? and
reload the table. The SAP LT Replication Server system will read the
entries from the logging table in the order of the key field of the
logging table (field IUUC_SEQUENCE), therefore preserving the order of
the changes in the source system. However, performance is not optimized.
Note that you cannot use the option <ZK>Use Key Fields to Calculate
Ranges</> in transaction LTRS.

Procédure pour les administrateurs système

Extrait du message d'erreur du système SAP. Copyright SAP SE.