"Failed to list assets" error on custom server

[djole]

I have Kobo installed back in 2018. on a private custom server. Recently, after logging in, the error “failed to list assets” appears, and loading the projects never ends.

I noticed that the same problem was also present on the public humanitarianresponse server and that it was solved later, probably by an upgrade. My idea is to definitely upgrade my server, but even that won’t go smoothly considering it’s an older installation. I wanted to ask if there was any quick fix that would allow me at least temporary work to be able to back up the data?

[ks_1]

Did you make any changes to your server recently?
I faced a similar issue and it was caused due to incorrect environment variables.

[djole]

Hmm, not that I know, maybe one of my colleagues changed something. What exactly could I check?

[ks_1]

See if any files inside kobo-docker or kobo-env were changed recently. If they were, you might need to revert them from a backup.

However as a permanent solution I would advise you to upgrade to the latest version. It will be more complex for you than the usual upgrade process, because you have the version with a single database for kobocat and kpi. But here are the instructions:

Upgrading to separate databases for KPI and KoBoCAT

Background KoBoToolbox previously used a shared Postgres database for its two Django applications, KPI and KoBoCAT. Since this has some disadvantages—including the requirement that Django be updated in lockstep across both apps—we’ve decided to give KPI and KoBoCAT their own, separate Postgres databases. KoBoCAT has responsibility for storing all form submissions and, as a result, generally has a larger amount of data than KPI. For this reason, our approach is to copy the KPI tables from the or…

[djole]

Thanks, I’ll take a look.