Solved
Schedule refresh not working
Hi I've added a trigger for schedule refresh but it's not updating the data.
I set it up at 12:30pm for a 1pm refresh, waited an hour but no data was updated.
Hi I've added a trigger for schedule refresh but it's not updating the data.
I set it up at 12:30pm for a 1pm refresh, waited an hour but no data was updated.
Hi,
Thanks for contacting us. Sorry for the issue with triggers.
Best regards,
Supermetrics team
Ok, i'm not sure if thats the issues though, I mean how long should it really take I've been waiting hours for it to update.
I've tried pressing the process all triggers now button and it still doesn't update - is that what's causing the email triggers I've got setup on completely different sheets to all be sent?....
I've only just started using Supermetrics so only have 2 triggers setup.
Hi,
if a query is updated within one hour before the trigger is supposed to run (or the Process all triggers button is clicked) then nothing will update as the results are cached.
If you have emailing triggers, the Process all triggers now -button presses will trigger the email send. It literally processes all triggers.
My advice is, set up the triggers as you want them to be and give them at least one trigger run cycle to see if they really work (in other words at least 24 hours with daily triggers). Avoid manual refreshes on the sheet if possible.
Best,
Heidi / Supermetrics
Hi Heidi,
Ok great thank you, I did that and the schedule worked! =)
We have set the refresh schedule every 12AM. In the last 2 days, it hasn't been refreshing and we have to manually do it every 10AM Sydney. Kindly advice.
Hi Katrina,
Sorry to hear about the issue with scheduled refreshes. If the refreshes were working and stopped at a certain date/time, we recommend to do the following in general:
1. Delete the trigger
2. Manually refresh the queries
3. Create a new schedule refresh
But there might be other reasons that can cause this in which we need to investigate further. And the investigation requires some sensitive information exchange so could you kindly send us a private ticket from here https://support.supermetrics.com/support/tickets/new
Best regards,
Supermetrics team
NOTE:
Please send us a private ticket from here https://support.supermetrics.com/support/tickets/new for any schedule refresh related issues as those type of issues require further investigations.
Best regards, Supermetrics Team