Dateperiodstructure not being generated 2025

waviles · 8 January 2025 18:54

Hi community,

I am running v2.36 and problem is that data from 2025 is not shown in analytics. I search on the tables and the table _dateperiodstructure doesnt have any entry for 2025.

Does anyone have the same problem this year?

Thanks

William

Gassim · 9 January 2025 14:45

Hi @waviles

Welcome back to the community!

How are you generating the analytics tables? Using the regular analytics tables export from the Data Administration app? Are you seeing any errors in the Catalina.out log?

I’m wondering if this is related to this recent issue: https://dhis2.atlassian.net/browse/DHIS2-18738 but I’ll need to ask the team as well.

Please share as much more information if there’s anything additional that could help with the debugging. Thank you!

waviles · 10 January 2025 14:13

Hello @Gassim

Yes, trying to generate the analytics using the Data Administration App. No errors in the log file.

What I could notice is that analytics tables are generated for 2025 but no records are generated for the _dateperiodstructure table this year.

Best

William

waviles · 10 January 2025 14:47

Hi all

New piece of information, when trying to get the data from event reports using fixed periods i got this in the browser log:

{
“httpStatus”: “Internal Server Error”,
“httpStatusCode”: 500,
“status”: “ERROR”,
“message”: “org.springframework.validation.BeanPropertyBindingResult: 2 errors\nField error in object ‘eventsAnalyticsQueryCriteria’ on field ‘endDate’: rejected value [10-01-2025]; codes [typeMismatch.eventsAnalyticsQueryCriteria.endDate,typeMismatch.endDate,typeMismatch.java.util.Date,typeMismatch]; arguments [org.springframework.context.support.DefaultMessageSourceResolvable: codes [eventsAnalyticsQueryCriteria.endDate,endDate]; arguments ; default message [endDate]]; default message [Failed to convert property value of type ‘java.lang.String’ to required type ‘java.util.Date’ for property ‘endDate’; nested exception is java.lang.IllegalArgumentException: Invalid format: "10-01-2025" is malformed at "25"]\nField error in object ‘eventsAnalyticsQueryCriteria’ on field ‘startDate’: rejected value [01-01-2025]; codes [typeMismatch.eventsAnalyticsQueryCriteria.startDate,typeMismatch.startDate,typeMismatch.java.util.Date,typeMismatch]; arguments [org.springframework.context.support.DefaultMessageSourceResolvable: codes [eventsAnalyticsQueryCriteria.startDate,startDate]; arguments ; default message [startDate]]; default message [Failed to convert property value of type ‘java.lang.String’ to required type ‘java.util.Date’ for property ‘startDate’; nested exception is java.lang.IllegalArgumentException: Invalid format: "01-01-2025" is malformed at "25"]”
}

Thanks

William

Gassim · 12 January 2025 11:05

Hi @waviles

Thank you for the updates and the information. This information and logs are helpful in debugging the issue. I still see that it could be related to the ticket issue but I’ll keep it as a separate post.

For now I’ve merged all the related topics here: Capture Data not reflecting on analytics app - #24

Does any of the posts seem relevant?

Thank you!