How can I recover sqlite database?

Question

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.

NicolasPfeffer-Taggart2 · Answer

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?

JamesTedrick · Answer

Hi Roger,

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