What happened
What this says
Current to 13 Oct 26Branch system connector refresh was finishing after 08:00 instead of the required 07:00 deadline. Connor optimized the connector query for the expanded branch data volume, restoring the refresh window.
Problem: Merriott Lyle's nightly refresh was running consistently over an hour behind schedule, with the branch system connector finishing after 08:00 instead of by 07:00. Tariq had verified his load logs showed normal record counts, ruling out data volume as the obvious cause.
Handling: Connor investigated and identified that query time had increased due to branch network expansion. He optimized the connector query and deployed the fix, restoring the refresh schedule.
Watch: Monitor the branch connector's performance as Merriott Lyle continues to expand. A similar issue with other connectors could indicate systemic performance degradation.
Details
Updated 9 Oct 26Trail
- created · Tariq Saleem 7 Mar 2025 12:45The nightly refresh window isn't keeping up. We're supposed to have fresh data by 07:00 each morning, but lately it's running over an hour behind. It's been finishing after 08:00 consistently. I've checked the load logs on my side and nothing stands out. Can you check the queue for errors, or let me know if you're seeing this with other customers?
- public_reply · Connor Webb 7 Mar 2025 17:38Thanks for reporting this, Tariq. To track it down, can you tell me which connector is running behind? Is it just one of them, or are all your sources lagging when the refresh runs?
- public_reply · Tariq Saleem 10 Mar 2025 09:29It's the branch system connector. Normal completion is 07:00, but it's been running past 08:00. I've checked the load logs, record counts look normal. Can you check the queue on your side for errors?
- internal_note · Connor Webb 10 Mar 2025 15:21Checked logs. Query time increased due to branch expansion. Optimised the connector's query. Deployed to production this morning, Tariq should see the improvement in tonight's refresh.
- status_change · 21 Mar 2025 23:59