We have an inspection app. Each row on inspection tabel have 4 photos collumns (2 of them required).
We fill the inspection form, take the photos (see below), but when it syncs, SOMETIMES the photos just doesnt sync. The image path doesnt sync into the collumn (see audit log below) and the image doesnโt upload to the cloud (Google Drive).
The photo goes to the deviceโs gallery.
What is bugging me is that it happens for some photos (like 40%), not all of them. Its happening with at least 2 different devices and I havenโt found any pattern on it.
Hi @hcquadros! Thank you for bringing this to our attention. Weโll have someone follow up when we have a bit more information for you.
Hi @hcquadros,
Can you please let me know which users are facing this issue (Either here or email support@appsheet.com), as well as your appโs name?
Are they all using Android device?
Hello!
Apps owner: 1016406
Apps: Lifting Gear Inspection and Controle documentos
Users:
hugo.quadros@aquaload.com.br
and levi.ventura@aquaload.com.br
Yes, all of them using Android devices.
I have the same problem and I think it is because sync/offline behaviorโฆI was using a full offline behavior without automatics syncs or wifi/lte useโฆhad saved all my data and images and laterโฆmaybe 6 hours later, I was in my house or in my job with good internet connection and press syncโฆall data is ok but images are not sent to my s3 file storage and my SQL database have empty strings โโ in url columnโฆtoday I have changed the sync/behavior to donโt need to press sync and send a little portion of data automaticallyโฆthe app is better than before!
Thanks for the details @hcquadros, @jader_james,
Seems like the issue might happen when trying to sync an image in an app that wasnโt synced recently.
This is most likely to affect apps without sync on start or offline apps.
Weโre working on a fix and will let you know as soon as itโs ready.
Ok following
Hi @hcquadros @jader_james,
Weโve just release update 13.6 to the Android app with the fix for this issue. This update is in a rollout, so it might take a few days until itโs visible to everyone.
Please let me know if youโre still seeing any issues with the new version.
the problem continues, maybe in a little scale, but some of the images is not syncing
Hi @jader_james, Could you please provide me with some more details?
In particular:
Hello, @Gil!
Hi @hcquadros,
We think we finally found the cause of this issue and have a fix on the way. Would you mind if I take a look in your audit logs to verify we are talking about the same issue?
To enable me to do that can you please go to https://www.appsheet.com/account/account#_tab_acctConfig and set the โAllow AppSheet staff to access my apps for support and maintenance?โ checkbox?
Also, Iโll need you to point me to a recent audit log that is missing the image. If you can provide me the app name and timestamp of the log that would be very helpful.
Hello @Gil,
It has not happened recently. Iโll keep monitoring. But weโve noticed a different kind of photo related issue.
The image (jpg file) is uploaded to the data source (Google Drive), the correct file address and name is added to the row (Google Sheets), but the image doesnโt show on the app, it just shows an exclamation.
Note: In the initial issue, the photo doesnt sync to the data source or sheet. This one differs ont that.
Is it possible to be server caching issue?
App names, image and log below for the photo issue. Iโve also checked the โAllow AppSheet staff [โฆ]โ checkbox.
App name 1: AnchorPointInspectionApp-703578
App name 2: LiftingGearInspection-702918
Properties:
{
โTableNameโ: โInspecoesโ,
โapiLevelโ: โ2โ,
โappStartTimeโ: โ2020-03-17T13:54:47.666Zโ,
โappTemplateVersionโ: โ1.000209โ,
โbuildโ: โ1652bc386c40300ff27e-1584384632775-7b47d53ea4โ,
โcheckCacheโ: โtrueโ,
โclientIdโ: โ7d29c399-a318-4b23-a3b5-682095e2f95fโ,
โdataStampโ: โ2020-03-17T15:47:49.156Zโ,
โisPreviewโ: โfalseโ,
โlastSyncTimeโ: โ2020-03-17T11:10:47.5508951Zโ,
โlocalVersionโ: โ1.000209โ,
โlocaleโ: โpt-BRโ,
โmechanismโ: โFormโ,
โrequestIdโ: โ46907764โ,
โrequestStartTimeโ: โ2020-03-17T17:07:30.407Zโ,
โtimestampโ: โ2020-03-17T13:38:51.518Zโ,
โtzOffsetโ: โ180โ,
โviewNameโ: โInspecoes_Formโ,
โRowSizeโ: 480,
โAppTemplateNameโ: โ5fcb0032-5656-48b4-bee7-7ac9aedd9865โ,
โOperationโ: โAdd rowโ,
โRecordTypeโ: โStopโ,
โReturnedFromCacheโ: false,
โPerformanceโ: โ{โVersionโ:1,โTimeโ:โ00:00:30.6726386โ,โPerformanceTimingRootโ:{โMidโ:1,โParamsโ:{โParamListโ:[{โPidโ:13,โValueโ:โInspecoesโ}]},โTimerโ:{โTimeโ:โ00:00:30.6726386โ},โChildrenโ:[{โMidโ:3,โTimerโ:{โTimeโ:โ00:00:30.6672110โ},โChildrenโ:[{โMidโ:100,โTimerโ:{โTimeโ:โ00:00:30.6653641โ},โChildrenโ:[{โMidโ:108,โTimerโ:{โTimeโ:โ00:00:30.6652984โ},โChildrenโ:[{โMidโ:101,โTimerโ:{โTimeโ:โ00:00:30.1756673โ},โChildrenโ:[{โMidโ:111,โTimerโ:{โTimeโ:โ00:00:28.4826025โ},โChildrenโ:[{โMidโ:224,โParamsโ:{โParamListโ:[{โPidโ:1,โValueโ:โFoto_1โ}]},โTimerโ:{โTimeโ:โ00:00:26.5119714โ},โChildrenโ:[{โMidโ:227,โTimerโ:{โTimeโ:โ00:00:00.2624810โ}},{โMidโ:225,โTimerโ:{โTimeโ:โ00:00:02.1860068โ},โChildrenโ:},{โMidโ:226,โTimerโ:{โTimeโ:โ00:00:24.0632755โ},โChildrenโ:[{โMidโ:228,โTimerโ:{โTimeโ:โ00:00:22.6057261โ},โChildrenโ:[{โMidโ:97,โParamsโ:{โParamListโ:[{โPidโ:17,โValueโ:โFotos/SSA20-0205.3Rev.1/EST_III-13/EST_III-13 14 03-17-2020 10-37-44.Foto_1.170728.jpgโ}]},โTimerโ:{โTimeโ:โ00:00:22.6056530โ}}]},{โMidโ:268,โTimerโ:{โTimeโ:โ00:00:01.4574420โ}}]}]},{โMidโ:224,โParamsโ:{โParamListโ:[{โPidโ:1,โValueโ:โFoto_3โ}]},โTimerโ:{โTimeโ:โ00:00:27.7608320โ},โChildrenโ:[{โMidโ:227,โTimerโ:{โTimeโ:โ00:00:00.2601058โ}},{โMidโ:225,โTimerโ:{โTimeโ:โ00:00:02.1880496โ},โChildrenโ:[{โMidโ:32,โParamsโ:{โParamListโ:},โTimerโ:{โTimeโ:โ00:00:02.1877558โ},โChildrenโ:[{โMidโ:32,โParamsโ:{โParamListโ:[{โPidโ:13,โValueโ:โTorresโ}]},โTimerโ:{โTimeโ:โ00:00:02.1877192โ},โChildrenโ:[{โMidโ:241,โTimerโ:{โTimeโ:โ00:00:00.3995230โ},โChildrenโ:[{โMidโ:32,โParamsโ:{โParamListโ:},โTimerโ:{โTimeโ:โ00:00:00.3265602โ},โChildrenโ:[{โMidโ:32,โParamsโ:{โParamListโ:[{โPidโ:13,โValueโ:โOS_READโ}]},โTimerโ:{โTimeโ:โ00:00:00.3265309โ},โChildrenโ:[{โMidโ:33,โParamsโ:{โParamListโ:[{โPidโ:9,โValueโ:โ23โ}]},โTimerโ:{โTimeโ:โ00:00:00.3262876โ},โChildrenโ:[{โMidโ:133,โTimerโ:{โTimeโ:โ00:00:00.3250658โ},โChildrenโ:[{โMidโ:95,โTimerโ:{โTimeโ:โ00:00:00.1735395โ},โChildrenโ:[{โMidโ:94,โTimerโ:{โTimeโ:โ00:00:00.1734614โ}}]},{โMidโ:238,โTimerโ:{โTimeโ:โ00:00:00.1513365โ},โChildrenโ:[{โMidโ:240,โTimerโ:{โTimeโ:โ00:00:00.1504072โ}}]}]}]}]}]},{โMidโ:32,โParamsโ:{โParamListโ:},โTimerโ:{โTimeโ:โ00:00:00.0644560โ},โChildrenโ:[{โMidโ:32,โParamsโ:{โParamListโ:[{โPidโ:13,โValueโ:โLogsโ}]},โTimerโ:{โTimeโ:โ00:00:00.0644214โ},โChildrenโ:[{โMidโ:33,โParamsโ:{โParamListโ:[{โPidโ:9,โValueโ:โ291โ}]},โTimerโ:{โTimeโ:โ00:00:00.0641446โ},โChildrenโ:[{โMidโ:30,โParamsโ:{โParamListโ:[{โPidโ:12,โValueโ:โPresentโ},{โPidโ:11,โValueโ:โAnchorPointInspectionApp-703578:1.000209:LogsDocId=1yw_L5xnJLZgsXF-qD-dReMSlshkwovwXI-FD2BxAE5cLogs-1016406โ}]},โTimerโ:{โTimeโ:โ00:00:00.0620790โ}}]}]}]}]},{โMidโ:33,โParamsโ:{โParamListโ:[{โPidโ:9,โValueโ:โ74โ}]},โTimerโ:{โTimeโ:โ00:00:01.7879038โ},โChildrenโ:[{โMidโ:133,โTimerโ:{โTimeโ:โ00:00:01.0876462โ},โChildrenโ:[{โMidโ:95,โTimerโ:{โTimeโ:โ00:00:00.7701871โ},โChildrenโ:[{โMidโ:94,โTimerโ:{โTimeโ:โ00:00:00.7701018โ}}]},{โMidโ:238,โTimerโ:{โTimeโ:โ00:00:00.3173149โ},โChildrenโ:[{โMidโ:240,โTimerโ:{โTimeโ:โ00:00:00.3164228โ}}]}]},{โMidโ:35,โTimerโ:{โTimeโ:โ00:00:00.6984636โ},โChildrenโ:[{โMidโ:22,โTimerโ:{โTimeโ:โ00:00:00.6984066โ},โChildrenโ:[{โMidโ:32,โParamsโ:{โParamListโ:},โTimerโ:{โTimeโ:โ00:00:00.6976409โ},โChildrenโ:[{โMidโ:32,โParamsโ:{โParamListโ:[{โPidโ:13,โValueโ:โParquesโ}]},โTimerโ:{โTimeโ:โ00:00:00.6976098โ},โChildrenโ:[{โMidโ:33,โParamsโ:{โParamListโ:[{โPidโ:9,โValueโ:โ14โ}]},โTimerโ:{โTimeโ:โ00:00:00.6973488โ},โChildrenโ:[{โMidโ:133,โTimerโ:{โTimeโ:โ00:00:00.6966652โ},โChildrenโ:[{โMidโ:95,โTimerโ:{โTimeโ:โ00:00:00.3243206โ},โChildrenโ:[{โMidโ:94,โTimerโ:{โTimeโ:โ00:00:00.3242389โ}}]},{โMidโ:238,โTimerโ:{โTimeโ:โ00:00:00.3721754โ},โChildrenโ:[{โMidโ:240,โTimerโ:{โTimeโ:โ00:00:00.3719988โ}}]}]}]}]}]}]}]}]}]}]}]},{โMidโ:226,โTimerโ:{โTimeโ:โ00:00:25.3122383โ},โChildrenโ:[{โMidโ:228,โTimerโ:{โTimeโ:โ00:00:24.0662706โ},โChildrenโ:[{โMidโ:97,โParamsโ:{โParamListโ:[{โPidโ:17,โValueโ:โFotos/SSA20-0205.3Rev.1/EST_III-13/EST_III-13 14 03-17-2020 10-37-44.Foto_3.170728.jpgโ}]},โTimerโ:{โTimeโ:โ00:00:24.0661972โ}}]},{โMidโ:268,โTimerโ:{โTimeโ:โ00:00:01.2458699โ}}]}]},{โMidโ:224,โParamsโ:{โParamListโ:[{โPidโ:1,โValueโ:โFoto_2โ}]},โTimerโ:{โTimeโ:โ00:00:28.4821243โ},โChildrenโ:[{โMidโ:227,โTimerโ:{โTimeโ:โ00:00:00.2609071โ}},{โMidโ:225,โTimerโ:{โTimeโ:โ00:00:02.1875237โ},โChildrenโ:},{โMidโ:226,โTimerโ:{โTimeโ:โ00:00:26.0334725โ},โChildrenโ:[{โMidโ:228,โTimerโ:{โTimeโ:โ00:00:24.0630189โ},โChildrenโ:[{โMidโ:97,โParamsโ:{โParamListโ:[{โPidโ:17,โValueโ:โFotos/SSA20-0205.3Rev.1/EST_III-13/EST_III-13 14 03-17-2020 10-37-44.Foto_2.170728.jpgโ}]},โTimerโ:{โTimeโ:โ00:00:24.0629454โ}}]},{โMidโ:268,โTimerโ:{โTimeโ:โ00:00:01.9703476โ}}]}]}]},{โMidโ:21,โTimerโ:{โTimeโ:โ00:00:01.6910595โ},โChildrenโ:[{โMidโ:25,โTimerโ:{โTimeโ:โ00:00:00.0594042โ}},{โMidโ:53,โTimerโ:{โTimeโ:โ00:00:01.5719409โ},โChildrenโ:[{โMidโ:95,โTimerโ:{โTimeโ:โ00:00:00.3481314โ},โChildrenโ:[{โMidโ:94,โTimerโ:{โTimeโ:โ00:00:00.3480388โ}}]},{โMidโ:75,โTimerโ:{โTimeโ:โ00:00:01.2237091โ},โChildrenโ:[{โMidโ:71,โTimerโ:{โTimeโ:โ00:00:00.4921560โ}},{โMidโ:74,โTimerโ:{โTimeโ:โ00:00:00.4032074โ}},{โMidโ:93,โTimerโ:{โTimeโ:โ00:00:00.3279733โ}}]}]},{โMidโ:34,โTimerโ:{โTimeโ:โ00:00:00.0594612โ}}]}]}]}]}]}]},โIsEmptyโ:false}โ,
โResultโ: โSuccessโ
}
Hi @hcquadros,
A few questions:
Hi @Gil!
I have edited it (getting the photo from Google Drive, and uploading it again), but the original row value is on the log above and the photo is still on the Data Source. The data matches.
What Iโve noticed just now is that it is duplicated on Google Drive. A jpg file with 0 KB (damaged file) and the functional one, both with exactly same name. I guess the app was fetching the damaged one and couldnโt open.
Perhaps a connectivity fluctuation during upload resulted in the damaged file?
Couldnโt find in Google drive settings a way to always replace files with same name.
Thanks @hcquadros,
Thatโs weird, not sure how is it possible to end up with 2 files with the same name. How often do you see image failures like that?
Is it always the case that you see see 2 files with one of them being 0 KB?
When this happens, does the sync shows any error to the user?
This doesnโt seem to be related to the phoneโs connectivity. At the point the files is saved into your Drive, the image should have been already uploaded.
The symptom (the image not appearing the the app - just an exclamation) doesnโt happens frequently. Iโd say that happens in like 1-2% of the rows. Thatโs the first time Iโve noticed it has 2 files. Iโm not sure if thatโs always the cause. Iโll keep checking.
Doesnโt appear any error message to the user. Usually we use the app completely offline and sync afterwards.
Do you use Delta Sync?
Yes. That might be causing this?
It has to do with bringing in backend infoโฆ I find that ANYTIME you are manually messing with images/folders/data, which is usually during dev, things get weird with that setting enabledโฆ I leave it OFF during dev, and turn it on after the app is up and running out of betaโฆ itโs an efficiency gain.
Hi @Grant_Stead and @Gil!
Iโll try to turn Delta sync off. Sync time is not really an issue for us, since we sync once and then the app runs offline.
Returning to the original and main issue, today Iโve noticed it happening again: required photo field and file doesnt sync to the data source. This time I was able to retrieve the log.
Properties:
{
โTableNameโ: โInspecoesโ,
โapiLevelโ: โ2โ,
โappStartTimeโ: โ2020-03-18T11:18:31.331Zโ,
โappTemplateVersionโ: โ1.000209โ,
โbuildโ: โ1652bc386c40300ff27e-1584436299790-b927b7b010โ,
โcheckCacheโ: โtrueโ,
โclientIdโ: โ0fedcbdf-43f7-4c8c-8f4a-f8015625ab58โ,
โdataStampโ: โ2020-03-18T13:56:54.527Zโ,
โisPreviewโ: โfalseโ,
โlastSyncTimeโ: โ2020-03-18T11:19:58.2258108Zโ,
โlocalVersionโ: โ1.000209โ,
โlocaleโ: โpt-BRโ,
โmechanismโ: โFormโ,
โrequestIdโ: โ78684399โ,
โrequestStartTimeโ: โ2020-03-18T17:21:32.533Zโ,
โtimestampโ: โ2020-03-18T13:02:10.457Zโ,
โtzOffsetโ: โ180โ,
โviewNameโ: โInspecoes_Formโ,
โRowSizeโ: 140,
โAppTemplateNameโ: โ5fcb0032-5656-48b4-bee7-7ac9aedd9865โ,
โOperationโ: โAdd rowโ,
โRecordTypeโ: โStopโ,
โReturnedFromCacheโ: false,
โPerformanceโ: โ{โVersionโ:1,โTimeโ:โ00:00:01.3239428โ,โPerformanceTimingRootโ:{โMidโ:1,โParamsโ:{โParamListโ:[{โPidโ:13,โValueโ:โInspecoesโ}]},โTimerโ:{โTimeโ:โ00:00:01.3239428โ},โChildrenโ:[{โMidโ:3,โTimerโ:{โTimeโ:โ00:00:01.3215489โ},โChildrenโ:[{โMidโ:100,โTimerโ:{โTimeโ:โ00:00:01.3203054โ},โChildrenโ:[{โMidโ:108,โTimerโ:{โTimeโ:โ00:00:01.3202722โ},โChildrenโ:[{โMidโ:101,โTimerโ:{โTimeโ:โ00:00:01.2710890โ},โChildrenโ:[{โMidโ:23,โTimerโ:{โTimeโ:โ00:00:00.0983106โ},โChildrenโ:[{โMidโ:28,โTimerโ:{โTimeโ:โ00:00:00.0982746โ},โChildrenโ:[{โMidโ:29,โTimerโ:{โTimeโ:โ00:00:00.0915579โ}}]}]},{โMidโ:21,โTimerโ:{โTimeโ:โ00:00:01.1721999โ},โChildrenโ:[{โMidโ:53,โTimerโ:{โTimeโ:โ00:00:01.1690361โ},โChildrenโ:[{โMidโ:95,โTimerโ:{โTimeโ:โ00:00:00.4536807โ},โChildrenโ:[{โMidโ:94,โTimerโ:{โTimeโ:โ00:00:00.4535968โ}}]},{โMidโ:75,โTimerโ:{โTimeโ:โ00:00:00.7152639โ},โChildrenโ:[{โMidโ:71,โTimerโ:{โTimeโ:โ00:00:00.2489185โ}},{โMidโ:74,โTimerโ:{โTimeโ:โ00:00:00.2842712โ}},{โMidโ:93,โTimerโ:{โTimeโ:โ00:00:00.1817237โ}}]}]}]}]}]}]}]}]},โIsEmptyโ:false}โ,
โResultโ: โSuccessโ
}
Hi @hcquadros,
Do you know how big were the image files? Any chance those are really big images?
How much time has passed between taking the picture and syncing the app?
Hi @Gil!
The original ones are about 2mb-3mb. About 5h has passed from taking the picture to syncing the app.
Thanks @hcquadros,
Weโre working on a fix and will let you know when itโs coming out.
Any update on this. I am still getting similar issue
I am also getting similar issue, any updtade will be appreciated.
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |