Nightly refresh not completing by 07:00
Ticketclosed
Brimscombe Energy · Nightly refresh not completing by 07:00
The nightly refresh job was completing successfully but after the 07:00 completion window, leaving teams with stale data. Bethan identified that the new CRM source was increasing record volume and sync time, pushing the refresh past the required window.
What happened
What this says
As at Fri 9 Oct 2026The nightly refresh job was completing successfully but after the 07:00 completion window, leaving teams with stale data. Bethan identified that the new CRM source was increasing record volume and sync time, pushing the refresh past the required window.
Problem: The nightly refresh was consistently completing after 07:00, leaving the brain showing yesterday's data. Handling: Bethan reviewed the load history and found the new CRM source was significantly increasing record volume, extending sync and indexing time past the service window. She scheduled optimization of that source's indexing. Watch: Data freshness is a critical service requirement. Confirm that optimization was completed and that refresh now completes by 07:00 consistently. Monitor CRM source performance.
Details
Updated 9 Oct 26Trail
Public reply · Nikhil Rao 4 Jul 2025 09:21Refresh delayed past 07:00 this morning. I checked the load history, job completed successfully but past the window. Teams seeing stale data. Nikhil- created · Nikhil Rao 4 Jul 2025 11:51The nightly refresh didn't complete by the 07:00 window this morning. The job ran successfully, but it's taking longer than it should, and the brain is showing yesterday's data. I checked the load history, this is happening occasionally now. Need to understand what's changed to cause the delay.
- Public reply · Bethan Lister 4 Jul 2025 13:35Thanks for reporting. Just so I've got this right, the refresh job is running to completion, but it's finishing after 07:00 so the data in the brain is stale for that day. Is it consistently late, or just this morning? Can you share the load timestamps from today so I can see how long it took? Thanks, Bethan
- Public reply · Bethan Lister 8 Jul 2025 12:39I've reviewed the load history. The delay is being caused by the new CRM source you added, it's bringing in significantly more records than your previous setup. That increases the sync and indexing time, pushing the refresh past the 07:00 window. I'd suggest we optimize the indexing for that source to get you back inside the window. I'll get that scheduled. Thanks, Bethan
- Status change · 19 Jul 2025 23:59