|
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.
|