We have an app that has 20,295 files in its default app folder. Suddenly all those images and files are giving a 500 Error Code or not displaying any images. I believe the issue would have to do with the number of files in the folder but cannot find anything relating to limits based on this. I have sent this to support@appsheet.com. In the meantime, I was wondering if anyone else had any similar issues or if any has more than 20k files and everything is working fine?
Due to previous experiences, I struggle internal in deciding to attempt to fix this myself. Whenever we solve issues ourselves the response 9 times out of 10 is we’ll monitor and notify us if it happens again. We have an issue with caching that files are not there (even though all caching options are disabled) for the past 5-6 months and have had no avail with getting that even attempted to be resolved because the response is just open in incognito. If that issue wasn’t contained to the Super User of the system, we would definitely start looking at different solutions for our needs.
I’ve never had an app with so many files, though a current client has the potential to get there.
This sounds to me like it might be a Google Account limit - you should reach out to Google support and see if you’re reaching some sort of invisible limit.
The client referenced above had a limit problem- they had over 100 users accessing their app in less than 100 seconds, a limit we were unaware of.
Our current theory is that the setting to restrict shared drive files to only those within our organization might be the culprit. Our IT department has yet to return our email on whether or not they recently changed this setting. If that is the problem then we have another problem. We would definitely want that to be the case since we have sensitive documents on the shared drives that are not appsheet related.
I like @MultiTech_Visions’ idea that you’re hitting a gDrive limit. I suspect this isn’t an AppSheet problem (though AppSheet may be doing a poor job of handling the gDrive failure).
I’m not clear how the problem surfaces, then. You said in the original post, “all those images and files are giving a 500 Error Code or not displaying”, but now, “if we change a file through appsheet we can see that file”. Can you clarify when the error occurs versus when it does not?
The error occurs on any file that is currently in our apps. Most of our files do not getting added to their folder through appsheet. In the couple of cases we have that they do, they are not added in the app that they are accessed through. Example: we have an app where stores take a picture of a delivery invoice. The app where they take that picture has no access to the images after they are taken. We had an admin app where someone in accounting can view these images. They do not show up in that app but if I edit an entry in the admin version and add a new image it will show up and continue to show up in the admin app.
