Error in generating Event Report for any data element linked with the Option set

[didate (Mamadou Lamarana)]

Hello, I had a similar problem in the past

Dhis 2.33 Event Report/Visualizer Issue

Hello Everyone I’m facing an issue when I’m trying to use Event Report/Visualizer apps with Data Element Linked with option Set, Like Gender (M,F). I don’t get a result, the spinner spins indefinitely. When I use only simple Data Element, I get result. Here is the error in log Query failed, likely because the requested analytics table does not exist (AbstractJdbcEventAnalyticsManager.java [tomcat-http-16]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar …

Hope this will helps.