Cannot Regenerate Table Schema

AppSheet AppSheet Q&A
,
1

I cannot regenerate table schema on my tables. The only error it shows is:

Your changes couldn’t be saved. Please check the app errors highlighted in red.

**Data table ‘table’ is not accessible due to: Cannot read data of table ‘AppID:Version:Table’. Spreadsheet data for ‘AppID:Version:Table’ could not be read..
**

I tried all basic troubleshooting like

  • Schema regeneration while app is Paused or unpaused.
  • Check the file path or permissions. All are correct.
  • File name is correct.
  • Removed any protected ranges.

I also encountered this error yesterday. The initial fix was I just removed all the protected ranges on the table. Now, even that fix is not working. Yesterday I also encountered the 504 gateway timeout error in appsheet.

Now, whenever the “Your changes couldn’t be saved. Please check the app errors highlighted in red.” appears it automatically shows “A newer version of the app exists. Reload the page to get the latest changes.” and just returning to the initial table schema.

Is this a server or appsheet bug?

2

For each and every table (not just the problem ones), reselect the Storage settings:

image
image1412×744 82.8 KB

My guess is one of your spreadsheet files was replaced, or a worksheet renamed, or something else on the Google Drive side of things.

3

Thanks for this Steve! The cause really was the change in the password or user so all of the Storage Source Path and Qualifier needs to be refreshed.

I also referred to this article in case someone will encounter the same problem in the future:

4

Outstanding, glad you figured it out! Thanks, too, for sharing the resolution here.