Error: Exception: Service Documents failed while accessing document with id ####

[ldu...@nyccatteam.org]

I just started new jobs on a new spreadsheet and running into this error message frequently (Side note- I've been using Autocrat on many spreadsheets for a few years now without any issues):

Exception: Service Documents failed while accessing document with id#####

I tried to figure out which document the id is connected to that is being used by my jobs but cannot seem to find it.

I am currently manually running each one and either get the above error or get a timed-out message and have to re-run everything again.

Is this a backend issue or something I can resolve? Any insight would be most appreciated!

[Joseph Schmidt]

Are you trying to use a Team Drive?  Autocrat doesn't work with Team Drives.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
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/4f5adf12-1825-4653-8c55-b4dfc0929704n%40googlegroups.com.

[Paróquia Santa Teresinha Campos RJ]

same problem here. I'm not using a team drive.

[Loreto Dumitrescu]

Sorry I totally missed the reply. Same for me. I’m not using Shared Drive files. I learned that lesson the hard way! I had some help from my fellow work mates and they also were only able to run about 5-15 jobs at a time before getting the error message. 

All the best,

ld

Loreto Dumitrescu OTR/L, ATP
CAT Evaluator- T, Th & F
PS 93 and MS 301- M & W

--
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/uyj_EHPG1wk/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/5e1559a9-ae2e-408f-affd-07a8a040c452n%40googlegroups.com.

[Jay Strumwasser]

I am getting the same error.  I would like to know what we can do to avoid this? Is a timed sheet better?

[Elsje van Leeuwen]

also getting this-can anyone help? 

Op dinsdag 15 juni 2021 om 21:10:58 UTC+2 schreef Jay Strumwasser:

[Jay Strumwasser]

The best way I have found is to delete everything that autocrat started to add like "will be started 6/16/2021".  I then re-run the script with some success.

Also, is there a way to run autocrat across multiple tabs?

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/d9b884c9-2f88-434f-ac99-a84e7defdf58n%40googlegroups.com.

--

Jay Strumwasser

Director of Technology/Chief Information Officer/Data Privacy Officer

40 N. Broadway

Irvington, NY 10533

O: (914) 269-5540

Please report all technology issues and requests here

[Elsje van Leeuwen]

does seem to work-somewhat.Thx 

Op woensdag 16 juni 2021 om 19:23:13 UTC+2 schreef Jay Strumwasser:

[Jay Strumwasser]

You're welcome 

J. Strumwasser

Director of Technology/Chief Information Officer/Data Privacy Officer

Irvington Union Free School District
Irvington, New York 10533
O: 914-269-5540

For student helpdesk, please go to www.tinyurl.com/irvchromebookissues

For staff helpdesk, please use Mojo Helpdesk

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/ff09ec8c-62c4-4705-a469-3761e6194989n%40googlegroups.com.

[Bookhound]

Same issue here (for last week or so) - been using Autocrat without problems for months now.

Restarting the script every few minutes (after deleting half completed rows as also attempted by @Jay Strumwasser) is not a fix - the scripts might fail after one two rows currently. Or it might do 30+. Very inconsistent, and it means we have to nurse a script that previously would do 100s of rows without issue.

Any further thoughts/solutions on this?

Thanks

Sam

[Bookhound]

Digging into this a bit more. My job script creates a new version of a template sheet from a row in master spreadsheet. Then it updates the content on this template and saves a copy as a pdf into a folder, then it deletes the sheet template.

Seeing this error when it can't finish the completion of the sheet before turning it into the pdf - thereby creating many empty Google Sheets in home folder. I'm able to match the ID in the error message with the last created sheet in the home folder.

Might this be using different folders for the jobs here causing issues?

[Bookhound]

Also seeing the old favourite:

Something is wrong. This should not be taking this long :(

 

as well, in the mix of many errors atm...

[Loreto Dumitrescu]

Thanks for doing all the good digging. I wonder if Google changed something yet again in the Drive API? I agree that restarting the jobs manually is not a sustainable solution. We run many documents and procedures through Autocrat and sadly when the job is stuck it doesn’t generate an error email like the one Autocrat sends when the script errs. 

I understand Autocrat is open sourced… anyone have experience with manually adding the script to their needed spreadsheets? Would this resolve the issue?

All the best,

ld

Loreto Dumitrescu OTR/L, ATP
CAT Evaluator- T, Th & F
PS 93 and MS 301- M & W

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/22f70143-16cd-40f6-8221-9839f7819786n%40googlegroups.com.

[Joseph Schmidt]

I'm not aware of any changes.  

Does the job run manually?

I'm not aware of an easy fix.  Does this happen all of the time or just occasional?

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

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/2049cd6b-9ea8-4176-b3b2-3a830109ac51%40Spark.

[Loreto Dumitrescu]

Sadly all the time across multiple spreadsheets. It’s for both timed triggers and on form submit triggers and manual run. 

All the best,

ld

Loreto Dumitrescu OTR/L, ATP
CAT Evaluator- T, Th & F
PS 93 and MS 301- M & W

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTORL2ZxtEORD8cPZQ-ZQe7v87aGgyKobBy4739uPQB_z%3DQ%40mail.gmail.com.

[Joseph Schmidt]

make sure you still have access to the template.  Can you capture the error message?

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/3142f7e2-7a73-44e2-9fdb-d12fc638324e%40Spark.

[Bookhound]

Hi Joe,

template is still connected without issues.

Error message:

ERROR

Exception: Service Spreadsheets timed out while accessing document with id 1xqb9jOLT8CJlAY-6K-HoymQOQgiAQZJrzpRmlxVlh2B.

where 1xqb9jOLT8CJlAY-6K-HoymQOQgiAQZJrzpRmlxVlh2B is ID of duplicate sheet created in root directly of Drive, before it is converted to PDF.

I tried moving all assets into one folder - this didn't help...

Any thoughts?

S

[Joseph Schmidt]

How big is the template or how complicated?  Does it work if you make the output be a doc?

Can you share a copy of the template and a copy of the spreadsheet with glua...@gmail.com?  I will take a look.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/2a767faa-3fc8-47bf-b6ed-6f071bc10820n%40googlegroups.com.

[ric...@zbulo.org]

I'm joining in here. O

1. Ocasionally AutoCrat gets stuck on merge jobs and delivers the below email. This started occurring for me in June.
2. It's a similar error to the once that launched the thread: Service Documents failed while accessing document.
3. I searched Google Drive (not a Team Drive) and the respective sheet for the file ID, but it doesn't actually exist. 
4. The templates are all connected and work fine. I'm also assuming it's note the template file that causes it, but the temporary output that AutoCrat creates. 
5. The template is a single page GDoc with a single merge field. 

I will test whether GDoc over PDF output works. 

Curious if someone managed to resolve the issue?

//////

The Google Sheets add-on AutoCrat is set to run automatically at a specific time interval, when a form is submitted, or both.

The add-on recently ran but was not able to complete successfully for the following reason:

Service Documents failed while accessing document with id 1W4EYZ1OS0HxhgnXU7naRHqrc5bCkAdQPIhseqM5gEiw.

Click to open your spreadsheet

If you need help troubleshooting this issue, head over to the AutoCrat G+ community

This notification email will be sent to you at most once per day.

//////

[mwe...@holmdelschools.org]

Been having the same issue for a few weeks now as well, following the group to see if anyone figures this out.

Mike

[Mr L Fenner]

Same here, we've used it for years with minimal issues. The last month have been experiencing the OP message. Has taken a good couple hours to nurse through a list of 300 or so records to merge. Sometimes only 2 or 3 (or even zero!) go through, other times I can get 100 (and everything in between). I was wondering whether time of day might impact it, I had better success doing a load on a SUnday afternoon.. so not sure if the load was easier then?

[ldu...@nyccatteam.org]

Circling back here... this is still happening across the spreadsheets on our domain. Is anyone successful with resolving it? 

[Joseph Schmidt]

Is it random?  Does it only fail when there are multiple merge jobs on the same spreadsheet?

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/e54e0c8c-42c9-47ce-8cb4-507cb122a937n%40googlegroups.com.

[Gary Levin]

The nature of what we need Autocrat means "Multiple Output Mode" is more helpful, but switching to "Single Output" mode (step 4. File Setting) does prevent the error from occurring, at least on my sheets.

If there is a way to stop the error in "Multiple Output Mode" that would still be extremely helpful.

[Anne Miller]

I also think that it's a problem with "multiple output mode".  While creating a new workflow, I was initially using single output mode and never saw the error.  As soon as I switched to "multiple output mode" and emailing the pdf, the same error started.    If this isn't resolved, I don't know how we can continue to use autocrat and it's a lifesaver!  

[Joseph Schmidt]

Are you using a Team Drive?  Autocrat doesn't work with a Team Drive.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/16cfdd01-2f5f-431a-830e-0e58a07b4e4an%40googlegroups.com.

[ldu...@nyccatteam.org]

I know! This is such a major bummer. I keep hoping this issue will be resolved somehow. I emailed the general New Visions directly (about a week ago) asking for clarification on why this is happening but have not heard anything back yet. I'll let you know if I hear anything back. Sadly, I think I'll start the search for an alternative. I cannot keep manually checking all these spreadsheets next school year.

[Joseph Schmidt]

Are you using a Team Drive?  

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/b42398de-e7c2-4309-a537-b236e8cd2dafn%40googlegroups.com.

[Brian Pugh]

Joe this started to happen to a new job today. Autocrat runs for a few rows, stops, then I see the same message: Exception: Service Documents failed while accessing document with id##### 

Many thanks,

Brian

Brian Pugh: IT & ET Support

bpugh@ahschools.com

Associated Hebrew Schools
252 Finch Ave W, Toronto M2R 1M9
Tel:  (416) 494-7666 x 0
Fax:  (416) 494-2925

Cell: (416) 520-0687

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTORQT1t6raoeuGC72Sw5kV_5L7sJ%3DzTb7YZaoM6q8JUM8w%40mail.gmail.com.