SAP Message RSAN_RT639 - Duplicate records when writing data to table &1

Diagnosis
An analysis process does not take uniqueness of data recordsinto account when processing data according to any availablekey fields. A database table, however, does consider uniqueness.When writing data to table &V1& there may only be one data record for eacharacteristic combination of key fields. If another unique index isavailable in the table, the data also has to be unique according to thisindex.

System Response
The analysis process terminates because not all of the data could bewritten to table &V1&.

Procedure
Check and change the definition of the analysis process. Using asuitable definition of the analysis process, ensure that duplicaterecords do not arise during updating, for example:

  • Check whether all key fields are filled correctly in the field mapping
  • on the data flow arrow before the data target.
    • Insert an aggregation node in front of the data target and aggregate
    • the data to fit the key fields of the data target. Use the key fieldsof the data target as grouping fields in the settings for the
      aggregation nodes. Use all of the other fields as aggregation fields.