Article Content
Article Number | 000030020 |
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. |