Skip to first unread message
Kate Isabelli
Jul 18, 2019, 4:27:26 PM7/18/19
to NV Autocrat Add-on
I've used autoCrat for many projects, and despite its occasional quirkiness, I love it! However, I am having crazy issues this week. We're a school so most of our autoCrat projects are not running over the summer. I'm working on a new project and I assumed the issue was with my new project that I started at the beginning of this week. However, today I went back and tried to run a very simple autoCrat demo that I have and got the same random results and error messages.
Not only am I getting error messages I've never seen before, but if I run autoCrat for the EXACT SAME RECORDS different times, which results work and don't work vary. One record will fail once and work another time!
Result on row 4 when I ran a test this morning:
Document successfully created; Document successfully merged; Failed to add michell...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Here is a link to my Google sheet for the project I'm really trying to work on:
https://docs.google.com/spreadsheets/d/1PBaCcBn1Am_RSF0JYqTL66kFxFauZ3npBOMTdlo7RRE/edit?usp=sharing
Here is a link to the demo file that I have had for several years and never had an issue with, so you can see results I got today!
Neal Sonnenberg
Jul 26, 2019, 10:27:15 AM7/26/19
to NV Autocrat Add-on
Hi Kate,
I have the exact same problem happening, just as you stated. Works fine on some records and then gets the 'rate limit exceeded' on others. I looked back and this problem started around June 22nd and I would say happens now on every 3rd iteration.
In my specific instance I am emailing the created document (via autocrat) to the person that needs to edit it; even though it sounds like they do not have editing access due to this error, they can still edit since the document goes into a drive folder where they have edit access. Not sure if that helps in your specific case.
Hopefully someone is checking this thread and can give us some help. Thanks for posting,
Neal
On Thursday, July 18, 2019 at 4:27:26 PM UTC-4, Kate Isabelli wrote:
I've used autoCrat for many projects, and despite its occasional quirkiness, I love it! However, I am having crazy issues this week. We're a school so most of our autoCrat projects are not running over the summer. I'm working on a new project and I assumed the issue was with my new project that I started at the beginning of this week. However, today I went back and tried to run a very simple autoCrat demo that I have and got the same random results and error messages.
Not only am I getting error messages I've never seen before, but if I run autoCrat for the EXACT SAME RECORDS different times, which results work and don't work vary. One record will fail once and work another time!Result on row 4 when I ran a test this morning:
Document successfully created; Document successfully merged; Failed to add michel...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer...@d128.org,amaya.pe...@d128.org; CC: michel...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer...@d128.org,amaya.pe...@d128.org; CC: michel...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Kate Isabelli
Jul 26, 2019, 11:25:01 AM7/26/19
to NV Autocrat Add-on
Neal,
Thank you very much for responding to my post! This at least helps me know that this issue is probably outside anything that we might be doing incorrectly on our autoCrats or within our data. My biggest concern is that these errors both came up on NEW projects we are doing. And thank you also for letting me know how you are working around the issue a bit for now, as I can factor that into my thinking as well.
However, we use autoCRAT a lot during the school year, for a large number of different projects, and school starts on 8/12/19 for us. I'm going to have to do some more testing, but if this is not corrected and is going to affect ALL of our autoCrat projects, we are going to be in a world of hurt by about the 2nd week of August. (And I am NOT going to want to answer my phone or look at my Inbox!)
Do you have multiple autoCrat projects running? And have all been impacted since this started? If I find it's that global, I might have to try to look at switching some of my projects to other approaches. (Assuming that those tools aren't also impacted as well, if this is something on the Google side.
I'm with you... Fingers crossed that someone in a position to do something about this (or at the very least shed additional light on it) sees this thread. Summer is not the best time to get things resolved or know how global an issue is, because so many people are not working and so many processes are not running.
Good luck!
Kate
On Friday, July 26, 2019 at 9:27:15 AM UTC-5, Neal Sonnenberg wrote:
Hi Kate,I have the exact same problem happening, just as you stated. Works fine on some records and then gets the 'rate limit exceeded' on others. I looked back and this problem started around June 22nd and I would say happens now on every 3rd iteration.In my specific instance I am emailing the created document (via autocrat) to the person that needs to edit it; even though it sounds like they do not have editing access due to this error, they can still edit since the document goes into a drive folder where they have edit access. Not sure if that helps in your specific case.Hopefully someone is checking this thread and can give us some help. Thanks for posting,
Neal
On Thursday, July 18, 2019 at 4:27:26 PM UTC-4, Kate Isabelli wrote:
I've used autoCrat for many projects, and despite its occasional quirkiness, I love it! However, I am having crazy issues this week. We're a school so most of our autoCrat projects are not running over the summer. I'm working on a new project and I assumed the issue was with my new project that I started at the beginning of this week. However, today I went back and tried to run a very simple autoCrat demo that I have and got the same random results and error messages.
Not only am I getting error messages I've never seen before, but if I run autoCrat for the EXACT SAME RECORDS different times, which results work and don't work vary. One record will fail once and work another time!Result on row 4 when I ran a test this morning:
Document successfully created; Document successfully merged; Failed to add michel...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer...@d128.org,amaya.pete...@d128.org; CC: michel...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer...@d128.org,amaya.pete...@d128.org; CC: michel...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Amanda Smith
Jul 29, 2019, 4:08:21 PM7/29/19
to NV Autocrat Add-on
Hey Kate & Neal,
Thank you for sharing all these details.
I'm curious about this API rate limit error you both are seeing.
Can you please provide your user key from the Autocrat drop down? ( make sure you are only logged into one Google account while retrieving the key, multiple accounts open can cause permission errors)
The user key points to errors that are being logged on the backend, hopefully, we can get some clues from there.
Thanks!
On Thursday, July 18, 2019 at 4:27:26 PM UTC-4, Kate Isabelli wrote:
I've used autoCrat for many projects, and despite its occasional quirkiness, I love it! However, I am having crazy issues this week. We're a school so most of our autoCrat projects are not running over the summer. I'm working on a new project and I assumed the issue was with my new project that I started at the beginning of this week. However, today I went back and tried to run a very simple autoCrat demo that I have and got the same random results and error messages.
Not only am I getting error messages I've never seen before, but if I run autoCrat for the EXACT SAME RECORDS different times, which results work and don't work vary. One record will fail once and work another time!Result on row 4 when I ran a test this morning:
Document successfully created; Document successfully merged; Failed to add michell...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer....@d128.org,amaya.pe...@d128.org; CC: michell...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer....@d128.org,amaya.pe...@d128.org; CC: michell...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Kate Isabelli
Jul 29, 2019, 4:36:41 PM7/29/19
to nv-autocr...@googlegroups.com
Here's mine: AMWRuYh7ypopDSOZyR8CGUtemcK/h/hdanc0d9eooNNJZByjMXAOFepenMiipZvH/HDNxGjvK1Ya
I believe I was correctly logged out of any potentially conflicting accounts.
Thank you in advance for any help on this. We actually start back to school very early, so I have staff returning next week and 7 related autocrat projects I'm supposed to be launching this week, not to mention the additional ones that are about to go into operation once the school year starts. I am pretty much in a panic about the possible implications here...
We LOVE autoCrat!
Kate Isabelli
Tech Integration Specialist
Community High School District 128
Libertyville High School / Vernon Hills High School
On Mon, Jul 29, 2019 at 3:08 PM Amanda Smith <asm...@newvisions.org> wrote:
Hey Kate & Neal,Thank you for sharing all these details.I'm curious about this API rate limit error you both are seeing.Can you please provide your user key from the Autocrat drop down? ( make sure you are only logged into one Google account while retrieving the key, multiple accounts open can cause permission errors)The user key points to errors that are being logged on the backend, hopefully, we can get some clues from there.
Thanks!
On Thursday, July 18, 2019 at 4:27:26 PM UTC-4, Kate Isabelli wrote:
I've used autoCrat for many projects, and despite its occasional quirkiness, I love it! However, I am having crazy issues this week. We're a school so most of our autoCrat projects are not running over the summer. I'm working on a new project and I assumed the issue was with my new project that I started at the beginning of this week. However, today I went back and tried to run a very simple autoCrat demo that I have and got the same random results and error messages.
Not only am I getting error messages I've never seen before, but if I run autoCrat for the EXACT SAME RECORDS different times, which results work and don't work vary. One record will fail once and work another time!Result on row 4 when I ran a test this morning:
Document successfully created; Document successfully merged; Failed to add michell...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Here is a link to my Google sheet for the project I'm really trying to work on:https://docs.google.com/spreadsheets/d/1PBaCcBn1Am_RSF0JYqTL66kFxFauZ3npBOMTdlo7RRE/edit?usp=sharingHere is a link to the demo file that I have had for several years and never had an issue with, so you can see results I got today!
--
You received this message because you are subscribed to a topic in the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-autocrat-add-on/aGsgkNr97eQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/c76d9ee8-2149-45b5-9d26-8cc8840cbf5f%40googlegroups.com.
Pursuant to Illinois’ public records law, this electronic communication may constitute a public record. Please be advised that this email may be subject to monitoring and disclosure to third parties.
HUNTER MÉXICO
Jul 29, 2019, 4:47:23 PM7/29/19
to nv-autocr...@googlegroups.com
Thanks For the retro
Now the plataform is working, y ereased the data that Tells you when the Jon started,
THX!
El lun., 29 de julio de 2019 15:08, Amanda Smith <asm...@newvisions.org> escribió:
Hey Kate & Neal,Thank you for sharing all these details.I'm curious about this API rate limit error you both are seeing.Can you please provide your user key from the Autocrat drop down? ( make sure you are only logged into one Google account while retrieving the key, multiple accounts open can cause permission errors)The user key points to errors that are being logged on the backend, hopefully, we can get some clues from there.
Thanks!
On Thursday, July 18, 2019 at 4:27:26 PM UTC-4, Kate Isabelli wrote:
I've used autoCrat for many projects, and despite its occasional quirkiness, I love it! However, I am having crazy issues this week. We're a school so most of our autoCrat projects are not running over the summer. I'm working on a new project and I assumed the issue was with my new project that I started at the beginning of this week. However, today I went back and tried to run a very simple autoCrat demo that I have and got the same random results and error messages.
Not only am I getting error messages I've never seen before, but if I run autoCrat for the EXACT SAME RECORDS different times, which results work and don't work vary. One record will fail once and work another time!Result on row 4 when I ran a test this morning:
Document successfully created; Document successfully merged; Failed to add michell...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Here is a link to my Google sheet for the project I'm really trying to work on:https://docs.google.com/spreadsheets/d/1PBaCcBn1Am_RSF0JYqTL66kFxFauZ3npBOMTdlo7RRE/edit?usp=sharingHere is a link to the demo file that I have had for several years and never had an issue with, so you can see results I got today!
--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
Neal Sonnenberg
Jul 29, 2019, 5:24:34 PM7/29/19
to nv-autocr...@googlegroups.com
Hi Amanda,
Thank you SO MUCH for looking into this. Here is my user key:
AMWRuYjayzbYwFKBnKlSBGNMNsSpgb/tpWOw3WXv4DCrHblvMGeZYiawWZqpXz+gvRyU/eIGm33S
For what its worth my spreadsheet has autocrat set to run on form submit and since July 22nd I have had 12 users submit an entry; 7 of those created the API error, and 5 have worked successfully. So strange ..
If you need any other info, like access to the spreadsheet, please let me know.
Thanks again,
Neal
 | Neal Sonnenberg Technology Integration Specialist, Medfield Public Schools    |
Get a signature like this: Click here!
On Mon, Jul 29, 2019 at 4:08 PM Amanda Smith <asm...@newvisions.org> wrote:
Hey Kate & Neal,Thank you for sharing all these details.I'm curious about this API rate limit error you both are seeing.Can you please provide your user key from the Autocrat drop down? ( make sure you are only logged into one Google account while retrieving the key, multiple accounts open can cause permission errors)The user key points to errors that are being logged on the backend, hopefully, we can get some clues from there.
Thanks!
On Thursday, July 18, 2019 at 4:27:26 PM UTC-4, Kate Isabelli wrote:
I've used autoCrat for many projects, and despite its occasional quirkiness, I love it! However, I am having crazy issues this week. We're a school so most of our autoCrat projects are not running over the summer. I'm working on a new project and I assumed the issue was with my new project that I started at the beginning of this week. However, today I went back and tried to run a very simple autoCrat demo that I have and got the same random results and error messages.
Not only am I getting error messages I've never seen before, but if I run autoCrat for the EXACT SAME RECORDS different times, which results work and don't work vary. One record will fail once and work another time!Result on row 4 when I ran a test this morning:
Document successfully created; Document successfully merged; Failed to add michell...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Here is a link to my Google sheet for the project I'm really trying to work on:https://docs.google.com/spreadsheets/d/1PBaCcBn1Am_RSF0JYqTL66kFxFauZ3npBOMTdlo7RRE/edit?usp=sharingHere is a link to the demo file that I have had for several years and never had an issue with, so you can see results I got today!
--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/c76d9ee8-2149-45b5-9d26-8cc8840cbf5f%40googlegroups.com.
This electronic transmission is for the intended recipient only and may contain information that is privileged, confidential, or otherwise protected from disclosure. Any review, dissemination, or use of this transmission or any of its contents by persons other than the intended recipient is strictly prohibited. If you receive this transmission in error, please notify the sender immediately upon receipt and delete or destroy the communication and its attachments. Thank you for your cooperation.
Amanda Smith
Jul 30, 2019, 11:36:17 AM7/30/19
to NV Autocrat Add-on
Hello Neal and Kate,
Thank you so much for sharing your user keys.
Neal: the only error I see logged for your key is "Multiple Accounts" being open when trying to run the add-on.
You most likely got prompted to sign out of one of the accounts ( since there was two open under the same domain) and then this would not have caused the behavior you are seeing.
The job you are running is very small, 12 rows should not be causing an error. Are you running many other Autocrat jobs at the same time?
Neal and Kate:
The rate limit error seems to be connected to a quota, do you know what type of Google account your domain has? ( ex: Gsuite free, Gsuite basic, Gsuite for edu) and is the spreadsheet this job is running on very heavy with many rows, tabs and formulas?
How many autocrat jobs total is your account currently running?
Thank you!!!
On Monday, July 29, 2019 at 5:24:34 PM UTC-4, Neal Sonnenberg wrote:
Hi Amanda,Thank you SO MUCH for looking into this. Here is my user key:AMWRuYjayzbYwFKBnKlSBGNMNsSpgb/tpWOw3WXv4DCrHblvMGeZYiawWZqpXz+gvRyU/eIGm33SFor what its worth my spreadsheet has autocrat set to run on form submit and since July 22nd I have had 12 users submit an entry; 7 of those created the API error, and 5 have worked successfully. So strange ..If you need any other info, like access to the spreadsheet, please let me know.Thanks again,Neal
Technology Integration Specialist, Medfield Public Schools
Get a signature like this: Click here!
On Mon, Jul 29, 2019 at 4:08 PM Amanda Smith wrote:
Hey Kate & Neal,Thank you for sharing all these details.I'm curious about this API rate limit error you both are seeing.Can you please provide your user key from the Autocrat drop down? ( make sure you are only logged into one Google account while retrieving the key, multiple accounts open can cause permission errors)The user key points to errors that are being logged on the backend, hopefully, we can get some clues from there.
Thanks!
On Thursday, July 18, 2019 at 4:27:26 PM UTC-4, Kate Isabelli wrote:
I've used autoCrat for many projects, and despite its occasional quirkiness, I love it! However, I am having crazy issues this week. We're a school so most of our autoCrat projects are not running over the summer. I'm working on a new project and I assumed the issue was with my new project that I started at the beginning of this week. However, today I went back and tried to run a very simple autoCrat demo that I have and got the same random results and error messages.
Not only am I getting error messages I've never seen before, but if I run autoCrat for the EXACT SAME RECORDS different times, which results work and don't work vary. One record will fail once and work another time!Result on row 4 when I ran a test this morning:
Document successfully created; Document successfully merged; Failed to add michell...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer....@d128.org,amaya.pe...@d128.org; CC: michell...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer....@d128.org,amaya.pe...@d128.org; CC: michell...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Here is a link to my Google sheet for the project I'm really trying to work on:https://docs.google.com/spreadsheets/d/1PBaCcBn1Am_RSF0JYqTL66kFxFauZ3npBOMTdlo7RRE/edit?usp=sharingHere is a link to the demo file that I have had for several years and never had an issue with, so you can see results I got today!
--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add-on+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/c76d9ee8-2149-45b5-9d26-8cc8840cbf5f%40googlegroups.com.
Neal Sonnenberg
Jul 30, 2019, 12:49:06 PM7/30/19
to nv-autocr...@googlegroups.com
Hi Amanda,
I just logged out of all accounts (like I did yesterday) and went into the spreadsheet and got my user key. It appears to be the same as the one yesterday:
AMWRuYjayzbYwFKBnKlSBGNMNsSpgb/tpWOw3WXv4DCrHblvMGeZYiawWZqpXz+gvRyU/eIGm33S
I have a question and maybe this is part of the problem. With about 1/2 of the times I use Autocrat I mask the user so that the email does not come from me (i.e. we send emergency student information to all parents at the start of the year; I don't want this coming from my school account). To do this I will go into the dummy account and create the initial setup and then will share the spreadsheet with editing access to my own account where I will do the bulk of the work, set up etc. So in this particular case where I am having the error, the trigger is set by jski...@email.medfield.net (our HR person) but I do all the back end work. Is this possibly causing a problem? Furthermore, is there a better way around this - otherwise I end up with access to a lot of email accounts I don't really want (HR, Nurses, Superintendent, etc).
Here is the spreadsheet - you can see the error starts in row 29 and happens sporadically for the remaining 30 rows. Autocrat info is in Column Z.
Thanks for your help,
Neal
| | Neal Sonnenberg Technology Integration Specialist, Medfield Public Schools |
Get a signature like this: Click here!
Document successfully created; Document successfully merged; Failed to add michell...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Here is a link to my Google sheet for the project I'm really trying to work on:https://docs.google.com/spreadsheets/d/1PBaCcBn1Am_RSF0JYqTL66kFxFauZ3npBOMTdlo7RRE/edit?usp=sharingHere is a link to the demo file that I have had for several years and never had an issue with, so you can see results I got today!
--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/c76d9ee8-2149-45b5-9d26-8cc8840cbf5f%40googlegroups.com.
This electronic transmission is for the intended recipient only and may contain information that is privileged, confidential, or otherwise protected from disclosure. Any review, dissemination, or use of this transmission or any of its contents by persons other than the intended recipient is strictly prohibited. If you receive this transmission in error, please notify the sender immediately upon receipt and delete or destroy the communication and its attachments. Thank you for your cooperation.
--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/5af2cf1c-af49-4924-ac15-d8c4cd9fcaf1%40googlegroups.com.
Kate Isabelli
Jul 30, 2019, 3:17:59 PM7/30/19
to nv-autocr...@googlegroups.com
We are G Suite for Edu. The specific spreadsheet that I am using only has about 6 records in it. However, I do have ONE calculated column in it that is using an ArrayFormula to replicate a calc down the column as form submissions come in.
I do not personally use autoCrat for any ongoing tasks, but I teach it to individuals and probably have a lot of dummy ones that I could delete AND may own a few other people's at this point. I'd have to check. When we first received the errors on one of these projects, the autoCrat project was owned by the other person, who would own few if any autoCrat projects (as she doesn't even know how to set it up herself).
Is there an easy way for me to check how many autoCrat jobs I am running? And if I delete the spreadsheets where I installed those (the ones that I don't need any more) will that automatically delete the autoCrat job from my count?
Would these limits be likely to be individual limits or some kind of domain limit?
If you would like me to supply copies of a spreadsheet or two where we are running into this error, I would be happy to do so.
Kate
Document successfully created; Document successfully merged; Failed to add michell...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer....@d128.org,amaya.p...@d128.org; CC: michell...@d128.org,kate.i...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Here is a link to my Google sheet for the project I'm really trying to work on:https://docs.google.com/spreadsheets/d/1PBaCcBn1Am_RSF0JYqTL66kFxFauZ3npBOMTdlo7RRE/edit?usp=sharingHere is a link to the demo file that I have had for several years and never had an issue with, so you can see results I got today!
--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/c76d9ee8-2149-45b5-9d26-8cc8840cbf5f%40googlegroups.com.
This electronic transmission is for the intended recipient only and may contain information that is privileged, confidential, or otherwise protected from disclosure. Any review, dissemination, or use of this transmission or any of its contents by persons other than the intended recipient is strictly prohibited. If you receive this transmission in error, please notify the sender immediately upon receipt and delete or destroy the communication and its attachments. Thank you for your cooperation.
--
You received this message because you are subscribed to a topic in the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-autocrat-add-on/aGsgkNr97eQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/5af2cf1c-af49-4924-ac15-d8c4cd9fcaf1%40googlegroups.com.
Joseph Schmidt
Jul 30, 2019, 3:26:44 PM7/30/19
to nv-autocr...@googlegroups.com
I took a quick look and here is the complete message. Failed to add mbilsborough@enet as viewer: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded:
The problem seems to be when sharing the file.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPhsf5Nd_78WCprORmR0VGkH8Bx7Bco3SfyTXcLZ6E_PhGc-0A%40mail.gmail.com.
Joseph Schmidt
Jul 30, 2019, 3:34:56 PM7/30/19
to nv-autocr...@googlegroups.com
Kate and Amanda,
Amanda can help with the issue. Failed to add kate.i...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded
It appears to still be a drive issue but you are trying to add different permissions.
I discovered somewhere along the way that just deleting a spreadsheet doesn't stop Autocrat. You have to remove the spreadsheet from the Trash. I think that removes the triggers. It is best to remove the time triggers that are not needed even if the file is needed.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAEy803wd584Ch3VZXHEsB7WCOG6dNocEkjm_PqD%3DOn8HCV-KkQ%40mail.gmail.com.
Kate Isabelli
Jul 30, 2019, 3:46:46 PM7/30/19
to nv-autocr...@googlegroups.com
Yes, that is the basic complete message. I did receive variations on it in the various results that I received. But the frustrating part is that the same item that just failed, if I cleared the autoCrat columns again, would then run properly. The error seemed random (hence my poor subject line) and not specifically due to a piece of actual data that was causing the problem.
For example, here is one of my early testing sheets when I first discovered the problem. Once I realized there were issues, I COPIED the results column to column AQ, then cleared my autoCrat columns, submitted one more new form and let them all run again. As you can see, without even changing data, I got different results on a couple of them the next time around.
https://docs.google.com/spreadsheets/d/1PBaCcBn1Am_RSF0JYqTL66kFxFauZ3npBOMTdlo7RRE/edit?usp=sharing
I realize that this one sheet doesn't make this look like much of a problem, but I've been testing other examples since then and getting similar inconsistent results.
I would actually be thrilled if we could find some user error here, because then it would be something I could just fix on my end!
Kate Isabelli
Tech Integration Specialist
Community High School District 128
Libertyville High School / Vernon Hills High School
You received this message because you are subscribed to a topic in the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-autocrat-add-on/aGsgkNr97eQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOQL%3DipWAXdd7fjcv4gKSC_yUgHoAL-vyU%2BaVhrmNK74Fw%40mail.gmail.com.
Joseph Schmidt
Jul 30, 2019, 8:01:22 PM7/30/19
to nv-autocr...@googlegroups.com
Kate,
I feel your pain. With the more complete error message it appears the problem is when Autocrat attempts to change the Sharing Setting of the file that was just created.
I hope the folks at NV can find the problem and get it solved quickly.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAEy803zDj9Xet2brEURQma5MCA1GHz4x1n9sB-kcagwwXyRbXQ%40mail.gmail.com.
Kate Isabelli
Jul 30, 2019, 9:31:08 PM7/30/19
to nv-autocr...@googlegroups.com
This is the most current view of the issue, based on some work I did this afternoon. I thought it might be helpful if I shared this sheet. You'll see that I ran the autoCrat 3 times and got different results. The last set of results is currently in the autoCrat status columns, and my error messages from the 2 runs before that are pasted to the right of the autoCrat columns. This way you can also see the one calculated column that I do have in my sheet. (column right before the autoCrat status columns)
Kate Isabelli
Tech Integration Specialist
Community High School District 128
Libertyville High School / Vernon Hills High School
Josh O
Jul 30, 2019, 9:57:59 PM7/30/19
to NV Autocrat Add-on
I am getting the same error on my AutoCrat process, very similar to the others listed here. The first occurrence was the 25th of June. Nothing changed around that time.
On Friday, 19 July 2019 06:27:26 UTC+10, Kate Isabelli wrote:
I've used autoCrat for many projects, and despite its occasional quirkiness, I love it! However, I am having crazy issues this week. We're a school so most of our autoCrat projects are not running over the summer. I'm working on a new project and I assumed the issue was with my new project that I started at the beginning of this week. However, today I went back and tried to run a very simple autoCrat demo that I have and got the same random results and error messages.
Not only am I getting error messages I've never seen before, but if I run autoCrat for the EXACT SAME RECORDS different times, which results work and don't work vary. One record will fail once and work another time!Result on row 4 when I ran a test this morning:
Document successfully created; Document successfully merged; Failed to add michel...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer...@d128.org,amaya.pe...@d128.org; CC: michel...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer...@d128.org,amaya.pe...@d128.org; CC: michel...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Michael Fricano
Aug 1, 2019, 4:23:54 AM8/1/19
to NV Autocrat Add-on
Hi, Amanda!
I am also having this same problem on a spreadsheet and a G Suite Edu account.
This is my user key: AMWRuYglvRtwhjxDG1N2wTX4sXP3Jv1Tv9n2ISMNola0Mq5wNOV7pW8kK2146mOJo1bMDOYD87g
The spreadsheet is pretty basic and I'm trying to add the user filling out the form and other collaborators as editors to a Google Doc that autocrat creates. But each instance is failing to update the share permissions of the Google Doc.
The Document Merge Status reads:
Document successfully created; Document successfully merged; Failed to add _____ as editor: API call to drive.permissions.insert failed with error: Invalid permission value; Failed to add ___ as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 3 Kaneshiro Curriculum Guide"; !!Error Sending Emails: Invalid email: ___; Run via form trigger as ____; Timestamp: Jul 16 2019 8:51 PM
Please advise what I should do. This spreadsheet is for teachers to create their Curriculum Guide Templates for beginning of school year. Currently the system is not working on promised to administration...
Michael Fricano
Aug 1, 2019, 4:26:22 AM8/1/19
to NV Autocrat Add-on
On a side note, this only starting happening today on one spreadsheet with four entries all happening within minutes of each other. I have a very similar spreadsheet with the same exact setup with Autocrat and is running just fine with an entry as recent as July 29.
Joseph Schmidt
Aug 1, 2019, 8:33:23 AM8/1/19
to nv-autocr...@googlegroups.com
Michael,
Is it possible to set the sharing at the Folder level. That way you wouldn't need to have Autocrat set the permissions. I have not tested this but it might help until NV and Google figure this out.
Try sharing with the permission of "anyone with the link". If that doesn't work, use FormMule to tell folks about the file.
--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/7d627196-2e9d-4029-94a4-bbf6bfac7fbd%40googlegroups.com.
Joseph Schmidt
Aug 1, 2019, 9:13:52 AM8/1/19
to nv-autocr...@googlegroups.com
Michael I think you are on to something. I suspect that the one that is running is only having one response at a time. The error seems to be when there are multiple requests to update the file permissions in a very short period of time.
I'm guessing that if you ran Autocrat manually and ran only one row at a time, the error would go away.
That isn't really a solution but it would help to identify the problem.
Amanda, I found https://developers.google.com/drive/api/v3/handle-errors I have no idea if there is anything useful there.
--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/bd2ce67e-da01-4aa0-9c6e-f701691dcfe0%40googlegroups.com.
Lucas Reis
Aug 2, 2019, 3:26:00 PM8/2/19
to NV Autocrat Add-on
Hi all,
I'm new to this group. I am using autocrat and just got a message saying
Document successfully created; Document successfully merged; Failed to add <<Writing Tutor's Email>> as editor: API call to drive.permissions.insert failed with error: Invalid permission value; Failed to add {my_email} as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: {students_email}_Lívia Liberata_OTT1_Test1_Integrated Writing"; !!Error Sending Emails: Invalid email: <<Writing Tutor's Email>>; Run via form trigger as {my_email}; Timestamp: Aug 1 2019 6:53 PM
I have no idea why this happened, but it is very worrying, as I have very various jobs in autocrat. I'm a newbie on this, so I have no idea where to start...
Any suggestions on what's going on?
Thank you,
Lucas
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add-on+unsub...@googlegroups.com.
Kate Isabelli
Aug 5, 2019, 5:32:09 PM8/5/19
to NV Autocrat Add-on
Unfortunately, other than what you would have already been able to see in this thread, I don't know anything else. I believe that as we get closer to more and more schools starting we are likely to see more posts under this category because I do think there's some kind of issue here that is creating problems under specific conditions. Unfortunately, in the summer not as many people are running their autoCrats so it's hard to tell the scope of an issue.
Our staff returns this Thursday, and students Monday, so I am expecting to start hearing that at least some more of our ongoing autoCrat projects are not working. (I really, really would like to be wrong.)
In the meantime, our best plan is really just to monitor all of our spreadsheets to look for errors, and also, where appropriate, to put some broad share settings on folders in hopes that it will help us bypass some of the Share errors. Obviously this is not going to work in all scenarios.
In other words, I'm also very worried but don't have any better ideas!
Kate
Ryan Horne
Aug 14, 2019, 9:52:20 AM8/14/19
to NV Autocrat Add-on
Joe & Michael,
I was having the same "rate limit" issues. The problem was fixed when I changed the sharing permission of the folder containing the merged docs to "anyone with the link" as Joe suggested!
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add-on+unsub...@googlegroups.com.
Ryan Horne
Aug 14, 2019, 9:58:00 AM8/14/19
to NV Autocrat Add-on
So, I might have spoken too soon. It does look the rate limit error is occurring when more than one row of data is having the autocrat process applied at the same time.
Joseph Schmidt
Aug 14, 2019, 9:59:21 AM8/14/19
to nv-autocr...@googlegroups.com
Ryan,
Thanks for the update. I think sharing the file as a PDF also fixes the problem.
Joe & Michael,
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/7d627196-2e9d-4029-94a4-bbf6bfac7fbd%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/2a76e48e-d6e1-4059-9a74-3290dc9fc6b0%40googlegroups.com.
Kate Isabelli
Aug 14, 2019, 10:14:17 AM8/14/19
to NV Autocrat Add-on
Just an update on our situation since I started this thread. We've started back to school and the forms where this was an issue are now actively in use. Given what we're using them for, sharing the documents as a PDF instead of a Google Doc is not an option. (Basically editing forms as part of a routing process for approvals.) But so far we have actually NOT had this error re-occur since back when I last posted an update a couple weeks ago. Not enough data to be conclusive, but currently not experiencing the error again. (Is there a cyberspace equivalent for "knock on wood"?!)
Also, currently the folders where the documents are being placed are only shared with specific individuals. We are still relying on the individual document shares via autocrat to allow the specified others to see the documents.
Kate
On Thursday, July 18, 2019 at 3:27:26 PM UTC-5, Kate Isabelli wrote:
I've used autoCrat for many projects, and despite its occasional quirkiness, I love it! However, I am having crazy issues this week. We're a school so most of our autoCrat projects are not running over the summer. I'm working on a new project and I assumed the issue was with my new project that I started at the beginning of this week. However, today I went back and tried to run a very simple autoCrat demo that I have and got the same random results and error messages.
Not only am I getting error messages I've never seen before, but if I run autoCrat for the EXACT SAME RECORDS different times, which results work and don't work vary. One record will fail once and work another time!Result on row 4 when I ran a test this morning:
Document successfully created; Document successfully merged; Failed to add michell...@d128.org as editor: API call to drive.permissions.insert failed with error: Rate limit exceeded. User message: "These item(s) could not be shared because a rate limit was exceeded: 8/23/2019 Michelle Jones The Arctic Circle"; Emails Sent: [To: jennifer....@d128.org,amaya.pe...@d128.org; CC: michell...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 9:59 AM
Result on row 4 (NO changes to data) when I ran another test this afternoon.:
Document successfully created; Document successfully merged; Emails Sent: [To: jennifer....@d128.org,amaya.pe...@d128.org; CC: michell...@d128.org,kate.isab...@d128.org]; Manually run by kate.i...@d128.org; Timestamp: Jul 18 2019 4:10 PM
Chad Hinton
Aug 30, 2019, 8:45:50 PM8/30/19
to NV Autocrat Add-on
I had this problem yesterday with a manual run. The problem is that the person gets the email that it was shared but the sharing permissions were not granted so I then get the email from them request access and have to grant it individually. My email and workload do not need the extra step. Hope a fix comes soon.
This occurred 8/29/19
Chad Hinton
Sep 9, 2019, 11:02:16 AM9/9/19
to NV Autocrat Add-on
Any updates on the rate limit error not sharing the documents with users? I have the issue for sheets that I trigger manually and on sheets that I have set to trigger on form submit. There is no rhyme or reason as to why some share and some don't.
Thanks
Chad
Kate Isabelli
Sep 10, 2019, 12:59:37 PM9/10/19
to NV Autocrat Add-on
No updates on my end. We're just working around this as creatively as we can for now. Definitely adds to the workload!
Reply all
Reply to author
Forward
0 new messages