I can't find a wrong data, it is not possible to download the event report

[Oficial_MEAL_CATATUM (Oficial MEAL CATATUMBO)]

Hi community,
We were able to identify the data that was entered wrong, a date 0200-02-29, but it has been impossible to find the form and the data element/attribute where it was entered, is there any way to find it or know it?

Thanks

[Oficial_MEAL_CATATUM (Oficial MEAL CATATUMBO)]

Complementing this information, this is the message that the analytical tables give us

“PreparedStatementCallback; SQL insert into _dateperiodstructure_temp values (2,2,?,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2)]; Batch entry 1,153 insert into _dateperiodstructure_temp values (‘0200-02-29 00:00:00+00’,200,2000228"200W9’,200WedW9"200ThuW9”,200SatW8",200SunW9",200BiW5,20002,20001B’,200Q1"200NovQ2,200S1"199AprilS2,200NovS1"200",199April,199July,1990ct",200Nov’) was aborted: ERROR: date/time field value out of range: 0200-02-29 00:00:00+00 Call getNextException to see other errors in the batch; nested exception is java. sql. BatchUpdateException: Batch entry 1,153 insert into _dateperiodstructure_temp values (‘0200-02-29
00:00:00+00’,200,2000228"200W9’200WedW9"200ThuW9"200SatW8"200SunW9"200BiW5,20002’20001B’"200Q1"200NovQ2’200S1"199AprilS2"200NovS1"200,199April"199July,1990ct’“200Nov)
was aborted: ERROR: date/time field value out of range: 0200-02-29 00:00:00+00 Call getNextException to see other errors in the batch.”

[Gassim (AL-Gassim Sharaf Addin)]

Hi @Oficial_MEAL_CATATUM

Thank you for your post. It appears that the issue you are facing is similar to these two topics, please have a look as there are helpful tips:

Analytics table update process stucked

Hi all, It’s been two hours and analytic still stay like this. [Inline images 1] This is on DHIS2 2.25. I have done vacuum full and back-up the database before the process. The back-up file is only 4378 KB, I don’t think the analysis process should take a long time. Does anyone know how to solve this? Please find attached file to see analytic table log. Thank you very much. dhis-analytics-table.log (1.15 MB)

···

– Best regards, Karin.

Data Export Issue in DHIS2 Analytics [FIXED]

Dear DHIS2 Community, I am writing to seek assistance regarding an issue I am facing while exporting data to Analytics in DHIS2. I am encountering a problem where the process gets stuck, and I receive the following error message: "PreparedStatementCallback; SQL [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Batch entry 38,043 insert into _dateperiodstructure_temp values ('0100-02-29 00:00:00+00',100,'1000227','100W8','100WedW9','100ThuW9','100SatW9'…