topic Re: Survey123 sqlite database corrupt in ArcGIS Survey123 Questions

Survey123 sqlite database corrupt

Jean-YvesLandry1 — Tue, 05 Jun 2018 20:51:59 GMT

One of my tablets crashed and the surveys disappeared from the application. I copied the .sqlite database to my computer (~8mb) but when I open it the "Surveys" table appear empty. However, when I opened the sqlite in notepad ++ , I can see that the surveys are still there.

I've followed various recovery measures, such as Procedure to recover a corrupted SQLite3 ArcGIS Mobile cache database, but they only dump an empty table.

I've reverted back to a previous .sqlite backup but since this is the first time that I've had an .sqlite database corrupt with Survey123 I was wondering if anyone else has had this happen and what you did to repair the database.

Re: Survey123 sqlite database corrupt

Anonymous User — Wed, 06 Jun 2018 00:23:17 GMT

Hi Jean-Yves,

Are you able to share a copy of the corrupt sqlite database so we can take a look, provided the data is not sensitive or confidential. I haven't seen an exact issue like with the sqlite database and Survey123, but if we can investigate further with your database that would be helpful.

Phil.

Re: Survey123 sqlite database corrupt

Jean-YvesLandry1 — Wed, 06 Jun 2018 03:57:21 GMT

I can't share publicly, but message me privately please.

Re: Survey123 sqlite database corrupt

Anonymous User — Thu, 07 Jun 2018 01:00:05 GMT

Hi Jean-Yves,

I have sent you a private message with my contact details. Once you send through the sqlite db I will take a look and get back to you.

Phil.