Duplicate records in the system
Ticketclosed
Ardenmore Pension Administration · Duplicate records in the system
Customer reported duplicate records in trustee data affecting reports. BB-Demo identified duplicate key in indexing and ran deduplication to resolve.
What happened
What this says
Current to 13 Oct 26Customer reported duplicate records in trustee data affecting reports. BB-Demo identified duplicate key in indexing and ran deduplication to resolve.
Problem: Harjit Bains reported duplicate entries for trustees in the brain, causing confusion in reports ahead of trustee meetings. The source system showed clean data, indicating the issue was on BB-Demo's side.
Handling: Bethan Lister identified a duplicate key issue in the trustee records and ran a deduplication process. The fix was confirmed and the customer received a single record per trustee.
Details
Updated 9 Oct 26Trail
- internal_note · Bethan Lister 19 Sep 2024 13:50Duplicate key issue in trustee records. Will dedup and confirm with customer.
created · Harjit Bains 19 Sep 2024 17:27Hi, I've just noticed that we've got duplicate records appearing in the brain for a few of our schemes. When I'm searching for client information ahead of next week's trustee meetings, I'm getting two or three entries for the same trustee, which is causing confusion in my reports. I've checked our source system and the data looks clean there, so the issue seems to be on the brain's side. Can you help me understand what's happening and how we can clean this up?- public_reply · Bethan Lister 19 Sep 2024 20:46Hi Harjit, thanks for reporting this. I've found the issue - there's a duplicate key in your trustee records. I'm going to run a deduplication for you now, which should clear this up. Once that's done you should see only one record per trustee.
- status_change · 4 Oct 2024 23:59