What happened
What this says
Current to 11 Oct 26Mismatches between repairs statuses in brain and housing system; records showing as open in brain but closed in system. Support investigating connector logs and schema.
Problem: Repairs jobs showed different status in the brain than in the housing system; about twenty jobs were showing as open when the system showed them resolved. Handling: Bethan Lister requested examples to trace through logs and schema. Paul Rigby provided a list of about twenty examples from the past week. Internal investigation found the connector was running but status updates were not coming through; suspected housing system field name change or connector query issue.
Details
Updated 9 Oct 26Trail
- created · Paul Rigby 2 Mar 2026 10:30We're getting mismatches between the repairs data in the brain and what's actually in the housing management system. Some jobs are showing up with different status than what's in the system, and it's making it hard to trust the dashboard first thing in the morning. I've got a list of examples if that helps you track down what's going on.
- public_reply · Bethan Lister 2 Mar 2026 14:45Thanks, Paul. Can you send over the list of examples so I can trace them through? I'll need the job ref, the status it's showing in the brain, what the housing system shows, and roughly when it started. Thanks, Bethan
- public_reply · Paul Rigby 4 Mar 2026 12:48List attached. Most of them are from the past week or so. The housing system shows them as resolved but the brain still has them as open. There's about twenty of them. Paul
- internal_note · Bethan Lister 4 Mar 2026 15:37Checking the connector logs from 2 Mar 2026 onwards. Repairs connector is running but status updates aren't coming through, housing system may have changed a field name or the connector query needs tweaking. Will check schema with Ewan.
- status_change · 13 Mar 2026 23:59