Number of submitted records in Kobo toolbox server does not match total

Kobo On Your Own Server
,
1

Hi,

We have a self-hosted version of kobotoolbox using kobo-docker. Recently the server ran out of storage space due to the automated backups. We had to delete some of these backups manually.

During this time the server was not accessible. However, enumerators were still submitting data. The data was successfully sent to the server, according to the devices of the users. We can also see the total amount of submissions match what we expect. However, when trying to view/download data, not all is there. For example, the “Total” value is correct (219) but only 127 records are viewable/downloadable (see screenshot below).

Thanks

image
image1558Ă—1046 36.9 KB

2

@Xiphware wondering if you could help with this one? Is there a way to e.g. remove those records from the server that are not appearing and then get enumerators to re-sync their devices? Unfortunately we cannot manually get the records off the devices as the enumerators are based in rural Uganda and not particularly tech savvy

3

Attn: @Kal_Lam , any ideas?

4

@matt_m have you checked the mongo sync issue? Maybe you need to run this command:

root@kobocat:/srv/src/kobocat# ./manage.py sync_mongo --remongo <username> <asset_ID>

This will show you the Instance count and the Mongo count that should be helpful to troubleshoot!

1 Like
5

Thanks! That looks like it’s fixed it:

root@kobocat:/srv/src/kobocat# ./manage.py sync_mongo --remongo
Your environment is:"onadata.settings.kc_environ"
Updating missing records for aPavr5MKsTv4kTSkSp5by3
-----------------------------------------------
Total no of instances: 219
Only updating missing mongo instances
Total no of mongo instances: 127
Total no of instances to update: 93
100.00 % done...
Updated aPavr5MKsTv4kTSkSp5by3

BTW are running on an older version of kobo-docker so I had to get to the container with the following command:

docker exec -it kobofe_kobocat_1 bash

I didn’t want to pollute this post with another (related) question on the backup limits, but is there any way to prevent the server running out of disk space?: Limit number of kobo-docker backups

1 Like