ERROR: date/time field value out of range: "0000-06-11"

Support - Assistance technique
1

Hi,

We have been

Erreur table analytique.docx (37.1 KB)

looking for solutions to this error for a week now. It occurred after the analytical tables were launched without success: ERROR: date/time field value out of range: “0000-06-11”.

DHIS2 version 2.38.3.1 Java 11.0.23

See the attached global message content.

2

@Gassim

3

in your database the event table (programstageinstance) has a column called eventdatavalues, which is a JSONB object

Inside that JSON, there can be key-value pairs

{
“fIkY2qBQA5U”: {“value”: “25”},
“nnUQYGyQPw1”: {“value”: “2025-08-20”},

…

…

}

which strictly says fIkY2qBQA5U is numeric and nnUQYGyQPw1 is date/time fields

when your analytics run

it assume and validate but in your case numeric field might contain not numeric data and date field might contant wrong format and throws error

how to solve/solution:

Select, Find, Clean / Fix the Data

2 Likes
4

Thank you for your contribution, @rcpoudel. I have received your message and will review it before getting back to you.

1 Like