Exception: service invoked too many times for one day: urlfetch

[seanhowe]

** Provide a general summary of the issue in the Title above ** We are using Project Aid for JIRA add-on and trying to load filters from JIRA

** Provide a more detailed information of the issue ** When I select the Add-on drop down and then Project Aid for JIRA then List issues from filter, it tries to load filters but is unable to do so, and fatally fails with the error in the title.

** Provide Debugging information ** For further investigation, please activate Debugging in "About" dialog, provide us with your "Temp. User Key" and then perform at least one another try. This way it will log the error and debug information to project owners StackDriver logging account where we can analyze it better.

Note: User credentials are not transmitted in any log data.

Steps to reproduce

** Provide a set of unambiguous steps to reproduce this bug include code, if relevant **

1. See the detailed information section

Expected result

** Tell us what should happen **

1. It should provide a list of filters that I can select from

Actual result

** Tell us what happens instead **

1. See detailed information section

[ljay79]

Hi @seanhowe ,

thats the first time someone reports a quota limit. According to google docs (https://developers.google.com/apps-script/guides/services/quotas) you would have at least a limit of 20.000 URL Fetch calls per day as a standard user or more for G-Suite users.

A) To see, if you can solve the issue at least temporary for further (debugging), try to uninstall the add-on completly. Create a new empty google sheet (not shared) and then install the add-on again. Due to the quota limit, you sadly might even have to wait for <24h before you should re-install the add-on.

B) For debugging / for me getting a better understanding how this is happen and if this is really to be expected. Can you maybe describe a little more detailed your usage of the add-on.

• shared sheets with other users, using the functionality
• how many docs and sheets
• description / estimate on how many custom function calls are in use
• estimation of how many jira lists (jira issues or sheet rows) your are loading from Jira
• how often you manually refresh all of these sheets with jira data ... This might give some insight of the use case but also if you maybe are really just a power user and reaching the quota limits naturally. On the other hand it could provide me a better insight, of how and where i can investigate for tweaks, having such limits reached only less often.

I must admit, im a very very low user of Jira inside sheet since a while :)

[ljay79]

Hi @seanhowe. any update to that issue?

[seanhowe]

Hi! The filters are showing up today so I think it must have been a temporary issue. Thank you for following up though.

[ljay79]

Glad it appears solved now, what did you do? Did you reinstall the addon? I guess it might be temporary but also possible to reoccur again.

It would be very helpful if you could provide more details to the questions in my last comment. Otherwise it's very likely you soon will hit this issue again.

[ljay79]

Hi @seanhowe can you confirm, your issue is permanently solved?

[seanhowe]

Hello, I believe this issue has since been resolved. Thanks

[ljay79]

Ok, glad its not occuring anymore. Just in case, this is an occasional issue i'll keep it open for the future. Maybe others have similar issues...