Repairs jobs still double-counted after upgrade
Ticketclosed
Calderbrook Housing Group · Repairs jobs still double-counted after upgrade
Paul Rigby provided spreadsheet of all duplicated repairs job refs. Bethan Lister verified the sample refs and confirmed duplication originates at source (housing system export), not in BG-Demo's ingestion. Paul asked whether duplicates clear automatically when the housing team fixes their system.
What happened
What this says
As at Fri 9 Oct 2026Paul Rigby provided spreadsheet of all duplicated repairs job refs. Bethan Lister verified the sample refs and confirmed duplication originates at source (housing system export), not in BG-Demo's ingestion. Paul asked whether duplicates clear automatically when the housing team fixes their system.
Problem: Paul provided comprehensive evidence (spreadsheet with all job refs). Bethan checked the sample refs and confirmed they are arriving twice from the housing system itself, not being duplicated during BG-Demo's ingestion.
Handling: This shifts the root cause from BG-Demo to the customer's housing system. Bethan escalated findings to the customer for the housing team to address their post-upgrade export configuration. Paul asked the critical follow-up: will clearing the source automatically fix the brain's data?
Watch: This resolves a three-week investigation spanning five tickets. The root cause is the customer's housing system, not BG-Demo. However, BG-Demo's inability to diagnose quickly has eroded trust.
Details
Updated 9 Oct 26Trail
created · Paul Rigby 5 Feb 2026 11:53Repairs jobs are still double-counted in the brain report. The housing system upgrade from last week is the cause. We've got spreadsheets tracking all of them, job refs attached, and the counts still don't match the source. It's breaking our reports. How long to fix this? Paul- Public reply · Bethan Lister 5 Feb 2026 14:19Hi Paul, thanks for this. I can see the duplication continuing on repairs records. Can you share the spreadsheet with the job refs that are duplicated? That'll help me trace exactly which records are affected and work out where the duplication is happening. Thanks, Bethan
- Public reply · Paul Rigby 9 Feb 2026 10:12Spreadsheet attached with all the job refs that are duplicated. The issue is continuing to come through. We really need to understand what's causing this. How long do you think the fix will take?
- Public reply · Bethan Lister 9 Feb 2026 16:45Got the spreadsheet, thanks. I've checked a sample of those job refs and they're coming through to us twice from the housing system. So the duplication is happening at source, not during our ingestion. That's actually good news: it means the issue is with how the system is exporting the data, not with our brain. Thanks, Bethan
- Internal note · Bethan Lister 11 Feb 2026 10:10Confirmed: duplication at source (housing system export). Sample of refs from customer's spreadsheet verified. Data coming through twice from their system after upgrade. Not ingestion issue. Escalate to customer for housing system connector config review post-upgrade.
- Public reply · Paul Rigby 11 Feb 2026 16:34Okay, so it's the housing system after the upgrade. We're looking into it with the housing team. Once they fix it on their end, will the duplicates clear automatically from the brain, or do we need to do something?
- Status change · 16 Feb 2026 23:59