Internal server error when downloading encrypted forms

I’m trying to download an encrypted form from humanitarianresponse.info using ODK briefcase. Other, non-encrypted forms are downloading properly, but when I try to get the encrypted form I get this error message:

Submission not retrieved: org.opendatakit.briefcase.util.ServerFetcher$SubmissionDownloadException: Fetch of a submission failed.  Detailed error: INTERNAL SERVER ERROR (500) while accessing: https://kc.humanitarianresponse.info/lmh_rmel/view/downloadSubmission?formId=aYUb6osNQkDVsmqcpVzk5c%5B%40version%3DvyBmy5CEezkKt2b6tnFQes+and+%40uiVersion%3Dnull%5D%2Fdata%5B%40key%3Duuid%3A50833497-f4b9-4f6a-8c22-f131e02065f8%5D
Please verify that the URL, your user credentials and your permissions are all correct.

This survey data is of critical importance to us, any help on this would be really appreciated. Thanks

Hi
When I look at the issue you are having, I can say that this is potentially an issue with your encryption and not the system. This is affecting your retrieval

Regards
Stephane

Thanks for your response Stephane!

It’s not a decryption issue. When I manually place the few instances I have in the ODK Briefcase Storage directory, they decrypt (using export) with no problems. It’s specifically an issue with pulling forms from the database, where I get the Internal Server Error (500).

Also not an issue with my credentials, since I’m able to download non-encrypted forms.

Hi,

In case you are still struggling with this issue:
I had the same. It is bug in ODK Briefcase in versions greater than 1.15. I filed a bug report to the developers. Meanwhile, the only workaround I could find is sticking to version 1.15.0

Cheers!

1 Like

Additional information (I have just wasted 45 minutes of this, so if it can help someone…):
ODK Briefcase v1.15 is not able to handle a pulldata() call in a calculate field. So if, like me, you have an encrypted form with a pulldata() call in a calculate field, you need to do the following:

  1. Use ODK Briefcase v1.15 to pull the encrypted data from the form
  2. Close it and use a more recent ODK Briefcase (I used v1.16.3 and it worked) to export the decrypted data.

Cheers!

2 Likes

Hi @freedim,

Thank you for sharing this to the entire community! It should benefit the entire users!

Have a great day!

1 Like

FYI @Kal_Lam,

It seems that this issue remains, or has resurfaced with Briefcase 1.18, as raised by @wb_cjc. I’ve also experienced this issue - with failing to load media files.

A discussion on the briefcase github concluded that the issue lies with kobotoolbox, rather than with briefcase.

Can we look into this? Can’t tell you how terrifying it is to collect data and then to not be able to pull it. I’ve also had issues where we wouldn’t be able to have someone from kobotoolbox decrypt it for us, otherwise it would be an IRB violation.

@figuredio, have you tried using Briefcase v1.15?

I wasn’t able to do it with v1.15, but tinkered around with different versions and was able to download with v1.11.0, then had to use a later version to actually decrypt.

1 Like

Thank you @figuredio for sharing this with the entire community.