500 Error When Launching App

[blueocean]

Hello,

I keep running into this error when my users try to use the app.

I have already regenerated structure, had them install and reinstall, clear cache and still this problem persist. Is this a localized issue or a system wide issue and what can I do? Thanks!

[Koichi_Tsuji]

Better to drop mail to support@appsheet.com

[blueocean]

Thanks!

[WillowMobileSys]

The error messages are inidicating a “Google drive Internal Server Error…while reading docid=Unknown”.

It seems AppSheet doesn’t know which document in Google to use as the datasource.

Were any changes made in Google with the datasource document?

If you go into the Data->Tables tab, expand the Table and look at the Storage settings, what does it look like? It should be something similar to the image below.

[blueocean]

When I try to input the source path for google, it doesn’t take. here is what mine looks like. But yes I’ve tried regen, refresh, reputting the google source path etc…

[Steve]

I suggest you reach out to support@appsheet.com for help with this.

[blueocean]

Steve:

support@appsheet.com

I just sent out a support email from my customer account.

[WillowMobileSys]

Ah, customer account. You are a co-author then?

I believe, based on other postings, that only the app owner can add datasources.

[Austin]

Only team datasources can be added by non-owners. I have this issue with an app I co-author.

[WillowMobileSys]

Yes, I have had good response times from them and have never gone without an answer. It does depend on availability. I know there other posts they were responding to earlier today - I saw the conversation here in the community.

While you are waiting, if you can elaborate what you meant by the statement below, maybe we can help drill in a bit more?

blueocean:

When I try to input the source path for google, it doesn’t take.

Maybe some screen capture or video of where it goes wrong?

[blueocean]

Notice on your example, the source path has something in there and mine says “Select a source”? When I try to reset that source, it does not update.

[WillowMobileSys]

Yes, I noticed that. But the question is if you are able to correctly access the sheets. Maybe give this a try below.

Here’s an example with an app I copied to help with.

Source dropdown and choose “browse for more data”:

The “GET DATA FROM” screen appears so I can select location I used in past:

Choosing Google, I get the following screen. Note that I cannot navigate anywhere else on My Drive.

If I back up to the “GET DATA FROM” screen and choose “New Data Source”. I am presented with a list of sources to choose from. Choosing Google and then re-authenticating, (NOTE I needed to do this twice) I can now navigate within the Google drive to choose additional workbooks to add to the app as Source Paths or re-select the original source.

[blueocean]

I used the wrong terminology. I am the app owner and account owner. By customer account I meant the email I used to register on appsheet for pro services.

[WillowMobileSys]

Ok then. I agree with @Steve suggestion to contact support. But please post back here once the source of the problem is found so we can ll learn from it.

[blueocean]

Does Appsheet answer their emails? I have reached out before with no luck on another issue. Can anyone attest to this?

[blueocean]

Negative. When I attempt to replicate your steps, I cannot access my drop down list from replicating your actions. I just get “Get new data source” and then “Google” If i click on “google” nothing opens for me.

[blueocean]

Up date for all.
The app was trying to access an xslx excel file…by converting it into a standard excel file, I was able to access the tables and reset the paths. My app is online.