Data feed creating duplicate records for assoicated records
I have a A2A data feed which I use to sync data between to environments. Seems when records that have more than one related record associated to another application it creates duplicate records and assign one of assoicate record to each duplicate record.
example: Findings has 3 Remediation Plans associates to it,but when the data feed runs I get 3 duplicate finding records assigned to each Remediation Plan.
- Community Thread
- Forum Thread
- RSA Archer
- RSA Archer Suite
It sounds like you are targetting the Remediation Plan application with your Datafeed.
Try doing it the other way. Update your Remediation Plan application, by targetting the Finding application.
Can you please tell about the key fields you are using . I think you are not defined any key field for Findings application. So that it is creating duplicate records and please make sure that you have checked both Create and Update checkbox in Update / Archive tab.
Frank tracking id's from one instance to another will never match so the data feed is creating new records cause it cannot find a match based on the key fields.
What you can do in your other instances (environments) is create a field called Tracking Id (Source) and populate that field with the tracking id of the source records. Then key off that field.
As David suggested, we need a common field that matches two environment for findings record. So that you will not get duplicate records in Findings application.
I'm having an issue where I am trying to use a data feed to populate the Technologies application with data in an XML file (Archer 5.4 SP1 2). I'm getting duplicate records. For some reason, it will not let me specify any key fields. The Key Field Definitions tab shows a message sayning "Key fields are not configurable for this module." What are the conditions that would make key fields not configurable?
The Technologies application is pretty much locked down from a data feed perspective in that you cannot set key fields resulting in what you are experiencing; duplicate records. The app sole purpose is for vulnerability feeds like Symantec Deep Sight or iDefence to populate that application.
Unfortunately there isn't anything that can be done to get around this.