Hourly refresh is not working

Esteban Cosin

started a topic over 2 years ago

Hi, the reason I choose and payed the super pro edition is the possibility to refresh my result hourly, but it is not working.

I deleted the trigger a couple of times, and it is still not working.

Could you please help me?

Thanks

Heidi Virta
said over 2 years ago

Hi Esteban,

Thanks for reaching out. So sorry there's an issue with triggers.

I see you have two triggers that are getting an error, it would be best to delete these and set them up again if they are still needed. The trigger id's with the issues are:
9Vv6Z1HjfKXDm0BdUndLLKbkosHMQV
abh45CML4BlKZqV0XAlTU2YHBk4Ho1

See all your triggers in Add-ons > Supermetrics > Schedule refresh & emailing > Manage triggers in all your files.

Currently Google Sheets is the one running scheduled refreshes on sheets and it sets limits on how long these processes can run per hour. Usually this time is around 6 minutes or so. As this runtime is shared between all your sheets that use triggers, with many files and queries refreshing at the same time, they are not always be completed in time and they are instead pushed to the next hour. This is the most common reason for delays with triggers.

Normally Google provides more time to users with G Suite business account. If you are not using G Suite, upgrading to that can help.

Best regards,

Heidi / Supermetrics