topic Re: How can I recover sqlite database? in ArcGIS Survey123 Questions

How can I recover sqlite database?

Roger_EduardoVaca_Burgos — Wed, 28 Dec 2016 22:20:03 GMT

Hi everyone,

We were working with a survey using Survey123 with Portal for ArcGIS. The field crew worked 4 days, and then, accidentally, the hosted service (ArcGIS for Server) was deleted, but the Portal item remains.

So, following this approach

Troubleshoot—Survey123 for ArcGIS | ArcGIS

we recovered several databases and upload the survey points and related data to a new service. But we can't open sqlite files from 4 tablets using DB Browser for SQlite:

These files contain 2 days of work. Is there any way to recover the information? We are using Portal for ArcGIS 10.4.1

Regards,

Roger Vaca.

Re: How can I recover sqlite database?

JamesTedrick — Fri, 06 Jan 2017 20:48:14 GMT

Hi Roger,

The database created by Survey123 doesn't have a password. I'll contact you offline to try to help resolve this issue.

Re: How can I recover sqlite database?

NicolasPfeffer-Taggart2 — Tue, 25 Jul 2017 19:14:17 GMT

I've experienced this intermittently when copying the Survey123 SQLite db from my devices... Sometimes a reboot of the mobile device, followed by re-copying the db file would solve the problem. However as of the most recent update to the android app, I seem to always experience this request for a password. Anyone have any workarounds?