|Applies To||RSA Product Set: Archer|
RSA Version/Condition: 5.x,6.x
|Issue||When outputting record content via Data Publication Service (DPS) from Archer to a target database you notice that there are duplicate key fields in the target database when they should be unique.|
|Tasks||Verify if you have an records that have this value in the same field more than once. If so, the field is set to be a "key" field, but not a "Unique" field.|
|Resolution||Edit the field in question to still be "Unique"|
This will prevent future records from having non-unique values. Now you still may need to deal with a sub-set of records that have duplicate key field data. Consider doing the following:
Run a report using the Tracking ID (system ID, not application) and the field in question. Apply any desired filters. Export to CSV. Change the duplicate values to unique values. Re-import using either the Data Import feature or the Data Feeds.