How To Fix DMC_RT_MSG235 - Sekundärindex enthält doppelte Werte

SAP Error Message - Details

• Message type: E = Error

• Message class: DMC_RT_MSG - DMC: Runtime Object Messages

• Message number: 235

• Message text: Sekundärindex enthält doppelte Werte

Was verursacht dieses Problem?

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.

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Systemantwort

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

Wie behebe ich diesen Fehler?

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.

Vorgehensweise für Systemadministratoren

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE