[FIXED] AppOfflineError while reading from a Google Sheet

Anvil Q&A
#1

Hi everyone :wave: some of you may remember me from a while ago when I used to be a Dev Advocate at Anvil.

Well long story short, I’m now a developer at a company that uses Anvil :smiley: . Soon they will ALL be using Anvil.

That brings me to the issue at hand, we’re having trouble with one of our apps…

What I’m trying to do:

I’m getting AppOfflineError when reading from a Google Sheet. It runs the first two lines fine, but the out_sheet.fields raises the exception.

    db = app_files.my_google_sheet
    out_sheet = db['History']
    fields = out_sheet.fields

Here’s the error log

AppOfflineError: Connection to server failed (1006)
at anvil-services/anvil/google/sheets.py, line 208
called from anvil-services/anvil/google/sheets.py, line 169
called from anvil-services/anvil/google/sheets.py, line 152
called from Form1, line 32

This started happening at 1522 GMT today, the app hasn’t been modified since 8th and it’s been working since then.

It feels like a problem with the connection between Anvil Central and Google Drive.

What I’ve tried and what’s not working:

I’ve checked that the Google Sheet is indeed still there :white_check_mark:

2 Likes
AppOfflineError: Connection to server failed (1006)
#2

This person is getting the same error today, although in their case they are calling an Uplink function:

#3

Hello, stranger! :slight_smile:

Does this happen reliably? If so, could you shoot the app’s ID to support@anvil.works, with instructions for reproducing the issue, so we can take a look?

#4

One more piece of info: the Google Sheet was modified last night around 21:30 GMT. But it still looks normal, the change didn’t do anything odd.

#5

Thanks for the reproduction info by email. This is now fixed!

2 Likes