What is the problem? Please be detailed. I'm a water resources engineer using ODK Collect and Aggregate for a citizen science project in Nepal called SmartPhones4Water. Our Aggregate URL is www.s4w-nepal.appspot.com Roughly 1 week ago I noticed that our Google Sheet for our form S4W-Nepal (id: S4…

Hi @Jeff_Davids , @yanokwa ! I wanted to write my insights after taking care of this problem for some days. We found that a duplicated image was causing a crash on the service that makes the uploads for the publishers There was a glitch on GAE/DataStore that would prevent me to find the duplicated …

Just as a quick update, since the app seems to be in a loop our datastore read costs are piling up. I just had to pay $100 dollars in fees, so any help would be greatly appreciated! My only solution to stop the charges at this point would be to delete the form, and since we have 9000+ submission, …

Hi @Jeff_Davids . I'm sorry that you are having problems! Can you please add yanokwa@nafundi.com as an owner on the Google App Engine account. Once I have access, I can take a quick look and see what is going wrong.

Hello @yanokwa . Thanks so much for being willing to look at this! I just added you as an owner on the Google App Engine account. I look forward to seeing what the issue is. Best.

[image] Jeff_Davids: we have 9000+ submission, I don’t want to lose all that data @Jeff_Davids , I'd recommend to back up your data using Briefcase as soon as possible. That way, you could even remove the form and submit it again, and then push the submissions back to the server

@yanokwa could you search for a full stacktrace on the logs? Also, if @Jeff_Davids can point you to a submission that isn't on the google sheets, could you locate it on the Data Store and see if there's any structural problem with it? (comparing to a submission that got to the google sheets)

So, I've traced the exception in the code to these lines in FormServiceCursor.constructExternalService(FormServiceCursor fsc, IForm form, CallingContext cc): try { // ... some stuff return new GoogleSpreadsheet(fsc, form, cc); // ... more stuff } catch (Exception e) { throw new ODKEntityNot…

Hi @ggalmazor thanks so much for working on this! I'm pulling the intances right now to my computer using Briefcase so at least we will have a backup. Right now I'm at 40 or 9000+ so it might be a while... So far so good, but I'll let you know how it finishes. I have several other forms that are…

@Jeff_Davids Briefcase has an experimental pull option in the settings that can drastically speed up pulls. I'd encourage you to use that setting. If you don't see in it settings, update to the latest version of Briefcase: ODK Briefcase v1.9 . I agree with @ggalmazor that this problem is either an i…

Hi @ggalmazor ! Thanks for all your work on this. Indeed, your summary and insights looks spot on. I just took a look at the publishers and everything seems to still be working. If you could transfer ownership of the Google Sheet that has the "BOTH Upload Existing & Stream New Submission Data" ac…

Hi @Jeff_Davids ! I transferred the ownership of the spreadsheet some days ago, could you confirm?

ODK Forum

Google Sheet Publisher Issue - Somehow DB entities for publisher got into problem state

Support