Unable to export analytics tables in DHIS2 2.38.1 or 2.39.1

Hi @swoodworth,

It seems like DHIS2 is trying to convert a decimal number “2.6” to PostgreSQL bigint type. Probably this conversion is failing, as “2.6” is not an integer.

Are you able to identify where this value “2.6” is coming from? It’s probably a value comming from a Tracker Entiry Attribute. If not, a Data Element.

If you can identify it, try to change this number to an integer value, like “2”, or “3”, then try to run again the analytics export.

Thanks,
Maikel

3 Likes