All Files and Images suddenly stop working for an App

Austin_Lambeth:

The app where they take that picture has no access to the images after they are taken.

Because the app is designed to prevent that access? Or the problem is preventing that access?

Austin_Lambeth:

They do not show up in that app

Because of the problem?

1 Like

With that many files could this be related to Google Drive API limits? I presume Appsheet uses that service when the app uses Gdrive at the backend? I believe there is a 1000 requests/100 seconds per user (default), in which case if the app runs as the creator maybe it is bumping up against that limit.

2 Likes

The app just had no purpose for allowing the stores to view the images after they were taken.

Yes, bc of the issue that is affecting all apps.

We have seen the issue where it hits the upload limit. that results in a error in the audit logs where as this does not result in a audit log error.

2 Likes

I dunno, I’m at a loss. Someone with a deeper view into the AppSheet stack will have to investigate, which means Support.

2 Likes

Appsheet support has been quiet on the email thread since I replied this morning, we have also reached out to our gsuite support as well to see if they have any possible insight. Any app that operates in our My Drives work but in the Shared Drives do not so for now we have to use zapier to copy every files that is added to our shared appsheet folders into the appropriate persons my drive since we use RPA processes that moves files around using the shared drives.

1 Like

So the problem only affects images and files stored in shared drives? Are they team drives?

1 Like

yes,/[TeamDrive]CorpShare/BI - Reference Files/TeamAppSheet/SmartFuelDelivery-

Heres an example from a default folder path

1 Like

Okay, that’s significant. I’ll make sure this gets relayed to Support. Thanks!

2 Likes

Developers have a theory and are working on a possible fix.

2 Likes

3X_d_5_d51363a862e7ab883241c312ac5d7f271579cdd3.gif

3X_c_9_c9a29e31763de6c32cb0fac5e3c775d1aa81331d.gif

(no idea why mines much larger)

1 Like

It’s because those are actual images you’ve downloaded, and they’re large photos. (Hint: After you upload a photo, if you hover over the preview you can shrink it down to 75% or 50% of it’s normal size).

My parrot is so small because it comes from the Parrot as a Service.

3X_2_f_2f63c0b123fff1b686048b7a6a0dae3472434a1a.gif

We have our images and files back up and running. Still no word from support since responding to their email yesterday at 9am eastern. No notification that the developers have found the source; no notification that they might have a possible solution they’re; no notification that it has been resolved. Spent 2 days on nothing but trying to deal with the fallout this issue has caused across various departments at our company. It’s one thing to have issue and that’s understandable but the responses and overall feeling that I get from sending critical issues that completely break the foundation of our apps that we are attempting to put in every aspect of the internal working of our business is terrifying. We would not be attempting even 1/10th of the projects we currently have or are working on without Appsheet because of how amazing it is. From the time Steve responded this post to the time he said “devs think they’ve found it” was 2 hrs. In 5 emails over a 24hr period with support I didn’t even feel like they had gotten past the “hey this guy just doesnt know how to make links to images/files” phase of getting help with this issue. It could just be that support had actually escalated this to devs well before Steve got involved in the conversation and thing were already moving towards being solved. But I don’t know, which to me is almost as big an issue as the reason I contacted support to begin with.

1 Like

@praveen ^^

Austin_Lambeth:

We have our images and files back up and running.

Ick! I forgot to circle back on this. The problem was with some team drive work done the other day. The fix simply requires you to re-save your app configuration. The save process will automatically correct the broken internal configuration. Sorry!

1 Like

@Austin_Lambeth, I hear your meta-point and it is something which is top of mind to address. I do apologize for this instance, but I realize there is actually a more systemic thing we have to change.

2 Likes

I understand that 99% of time a support ticket is just as simple as “they didn’t know how to properly make a link”, so the response being what it was in the beginning is definitely to be expected. It just felt like I couldn’t get the issue to be looked at as if it was beyond that. Normally the response are good and in a perfectly fine spot. An hr or two if the response is “Can I get more details” or a “let me investigate this and get back to you”. Long response times when I was told its being looked at or investigated are good because I have confidence in the devs teams. Any time I’m told an issue is being looked at by the devs, I immediately feel good that the issue is being solved. Please don’t take that to mean just add the devs are looking at it to any email lol

What does re-save your app configuration mean? Is that something we can do ourselves? @Steve

Austin_Lambeth:

What does re-save your app configuration mean? Is that something we can do ourselves?

Yep! Just make any change to the app configuration and save it. If you have nothing that needs changing, just do something trivial, like toggling the Show? setting of a column off and back on.

Would I need to save and verify? I feel like we changed one of the apps when I was under the impression that it was due to the 20k files so I changed the folder location to a backup that I have only a few thousand files on?

1 Like

Austin_Lambeth:

Would I need to save and verify?

Not needed, but you may if you want.

Austin_Lambeth:

I feel like we changed one of the apps when…

That might have been before the fix was put in place.

1 Like