When updating the analytical table in DHIS2 2.38.4.3, it says that it has a decimal 1.6 that they intend to convert to bigint. However, after analyzing the data element, it does not contain any value of the type. It is tracker data.
Can anyone help me?
analis.docx (30.7 KB)
Hi @witney
This is a mismatch between the initial datatype configured for the metadata and then a changed occurred in the configuration which is probably why the error happened. This sort of issue is handled in later versions of DHIS2.
Based on the log, it seems that the issue is not with a data element, it’s with a Tracked Entity Attribute. Sorry to see that you’re facing this issue but you’re in luck because another community member has faced this issue and marked the following post as a solution: Unable to export analytics tables in DHIS2 2.38.1 or 2.39.1 - #4 by maikel
You will probably need to investigate where this occurs in your database. The SQL where this issue happens is:
(select cast(value as bigint)
from trackedentityattributevalue
where trackedentityinstanceid = pi.trackedentityinstanceid
and trackedentityattributeid = 1244598
and value ~* '^(-?[0-9]+)(\.[0-9]+)?$')
as "Y7QPS4aaL9j"
– maybe you’ll be able to identify it using the API: /trackedEntityAttributes/Y7QPS4aaL9j
I hope this helps.