script error: this add-on has created too many time-based triggers in this document for this Google

[chris hann]

Hello,

Last week, say March 11 2015, my scheduled report stopped updating each hour, as it has been for many months. I have just deactivated and attempted to reactivate the scheduling at hourly intervals but received an alert "script error: this add-on has created too many time-based triggers in this document for this Google user account".

How can i manage this issue?

PS Thanks for the add-on, it's incredibly useful!

[Philip Walton]

Do you know how to check your active triggers in the script editor? If so, you can look and see how many you actually have. You can click the "X" to delete them as a temporary fix. I've heard of this same problem from a few other people, but since I'm unable to reproduce it myself, I'm not sure how to fix it.

In case it's helpful, here's what's going on behind the scenes:

When you make a change to your schedule, the add-on deletes the previously stored trigger and creates a new one (since triggers aren't editable). However, it sounds like in some cases it loses the reference to the old trigger and is unable to delete it, so you end up just adding more on and quickly running out of allowed triggers.

Like I said, I can't reproduce this myself and I have no idea why the add-on can't find the old trigger to delete it. If you have an unusual set up, or any other information that might help me figure this out, please let me know.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/1ee8d6d6-ed71-4944-be84-a892c79a5860%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[chris hann]

Thanks Philip, I didn't know how to do that, now I do! Removing the old scheduled trigger with script.google.com has resolved the issue. Appreciate the help.

On Monday, 16 March 2015 15:07:33 UTC+11, Philip Walton wrote:

Do you know how to check your active triggers in the script editor? If so, you can look and see how many you actually have. You can click the "X" to delete them as a temporary fix. I've heard of this same problem from a few other people, but since I'm unable to reproduce it myself, I'm not sure how to fix it.

In case it's helpful, here's what's going on behind the scenes:

When you make a change to your schedule, the add-on deletes the previously stored trigger and creates a new one (since triggers aren't editable). However, it sounds like in some cases it loses the reference to the old trigger and is unable to delete it, so you end up just adding more on and quickly running out of allowed triggers.

Like I said, I can't reproduce this myself and I have no idea why the add-on can't find the old trigger to delete it. If you have an unusual set up, or any other information that might help me figure this out, please let me know.

On Sun, Mar 15, 2015 at 8:50 PM, chris hann <gimu...@gmail.com> wrote:

Hello,

Last week, say March 11 2015, my scheduled report stopped updating each hour, as it has been for many months. I have just deactivated and attempted to reactivate the scheduling at hourly intervals but received an alert "script error: this add-on has created too many time-based triggers in this document for this Google user account".

How can i manage this issue?

PS Thanks for the add-on, it's incredibly useful!

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

[Tom Amosmedia]

I can't reproduce. I actually fixed my problem by making a duplicate copy of the spreadsheet as a new file in drive. Then, I went to the GA for sheets add-on and re-scheduled the report schedule. Used the same time/date intervals and literally changed nothing else about the file. Hope this workaround is helpful to anyone else who has the problem.

Thanks Philip for directing me to the thread.

Tom

On Tuesday, March 17, 2015 at 2:22:41 AM UTC-5, chris hann wrote:

Thanks Philip, I didn't know how to do that, now I do! Removing the old scheduled trigger with script.google.com has resolved the issue. Appreciate the help.

On Monday, 16 March 2015 15:07:33 UTC+11, Philip Walton wrote:

Do you know how to check your active triggers in the script editor? If so, you can look and see how many you actually have. You can click the "X" to delete them as a temporary fix. I've heard of this same problem from a few other people, but since I'm unable to reproduce it myself, I'm not sure how to fix it.

In case it's helpful, here's what's going on behind the scenes:

When you make a change to your schedule, the add-on deletes the previously stored trigger and creates a new one (since triggers aren't editable). However, it sounds like in some cases it loses the reference to the old trigger and is unable to delete it, so you end up just adding more on and quickly running out of allowed triggers.

Like I said, I can't reproduce this myself and I have no idea why the add-on can't find the old trigger to delete it. If you have an unusual set up, or any other information that might help me figure this out, please let me know.

On Sun, Mar 15, 2015 at 8:50 PM, chris hann <gimu...@gmail.com> wrote:

Hello,

Last week, say March 11 2015, my scheduled report stopped updating each hour, as it has been for many months. I have just deactivated and attempted to reactivate the scheduling at hourly intervals but received an alert "script error: this add-on has created too many time-based triggers in this document for this Google user account".

How can i manage this issue?

PS Thanks for the add-on, it's incredibly useful!

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.

[Philip Walton]

Interesting. That makes me think the limit is per-spreadsheet and not per-add-on or per-project. It could be that you'll get this same error with your new spreadsheet if/when you change the schedule around a few more times.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/d5771c04-a383-43a7-8616-3d30345d811c%40googlegroups.com.

[Philip Walton]

This bug has been fixed in the most recent release of the add-on (version 61).

Please let me know if you're still experiencing problems.

On Thursday, July 9, 2015 at 4:47:25 PM UTC-7, Philip Walton wrote:

Interesting. That makes me think the limit is per-spreadsheet and not per-add-on or per-project. It could be that you'll get this same error with your new spreadsheet if/when you change the schedule around a few more times.

On Thu, Jul 9, 2015 at 9:12 AM, Tom Amosmedia <tom.am...@gmail.com> wrote:

I can't reproduce. I actually fixed my problem by making a duplicate copy of the spreadsheet as a new file in drive. Then, I went to the GA for sheets add-on and re-scheduled the report schedule. Used the same time/date intervals and literally changed nothing else about the file. Hope this workaround is helpful to anyone else who has the problem.

Thanks Philip for directing me to the thread.

Tom

On Tuesday, March 17, 2015 at 2:22:41 AM UTC-5, chris hann wrote:

Thanks Philip, I didn't know how to do that, now I do! Removing the old scheduled trigger with script.google.com has resolved the issue. Appreciate the help.

On Monday, 16 March 2015 15:07:33 UTC+11, Philip Walton wrote:

Do you know how to check your active triggers in the script editor? If so, you can look and see how many you actually have. You can click the "X" to delete them as a temporary fix. I've heard of this same problem from a few other people, but since I'm unable to reproduce it myself, I'm not sure how to fix it.

In case it's helpful, here's what's going on behind the scenes:

When you make a change to your schedule, the add-on deletes the previously stored trigger and creates a new one (since triggers aren't editable). However, it sounds like in some cases it loses the reference to the old trigger and is unable to delete it, so you end up just adding more on and quickly running out of allowed triggers.

Like I said, I can't reproduce this myself and I have no idea why the add-on can't find the old trigger to delete it. If you have an unusual set up, or any other information that might help me figure this out, please let me know.

On Sun, Mar 15, 2015 at 8:50 PM, chris hann <gimu...@gmail.com> wrote:

Hello,

Last week, say March 11 2015, my scheduled report stopped updating each hour, as it has been for many months. I have just deactivated and attempted to reactivate the scheduling at hourly intervals but received an alert "script error: this add-on has created too many time-based triggers in this document for this Google user account".

How can i manage this issue?

PS Thanks for the add-on, it's incredibly useful!

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/1ee8d6d6-ed71-4944-be84-a892c79a5860%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

[Nathan Brunetti]

That's great that its fixed. How do you know what version of the add-on your on?