Error 500 (internal server error)

AppSheet AppSheet Q&A
1

image
image690×129 9.31 KB

I’ve been getting this error since yesterday. I know there was a thread where some of the issues were fixed, but unfortunately, I’m still getting this message.

2

Hello @Damian_Godlewski,

I did some research on this and found out that 500 (internal server error) is due to the remote storage provider having an internal error and fails to provide the spreadsheet data to AppSheet.

Typically this is a transient problem and often is hidden from our users because we automatically retry the request.

There is a list of Possible Causes & Fixes on this post.

If you are still experiencing issues, please Contact Support.

3

A 500 error is any unhandled error on AppSheet’s end. It could be a remote storage provider, or it could be anything else. The only thing we can say for sure is that it’s not a problem with the app on the device or browser.

That said, 500 errors are often transient, so waiting a bit and retrying might be all you need to do, but if it persists, ccontact Support so they can investigate on the AppSheet end.

4

The problem stemmed from the Postgres database and the size of a single table. After creating a view with a truncated version of the table, the problem appears to be resolved.

5

Well done.