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 [select avg(distinct tei) as value from analytics_enrollment_xkodytbxqxb as ax where enrollmentdate < cast( ‘2021-01-01’ as date )and enrollmentdate >= cast( ‘2020-01-01’ as date )and (uidlevel1 = ‘Ky2CzFdfBuO’ ) limit 100001]; nested exception is org.postgresql.util.PSQLException: ERROR: function avg(character) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Updating 1 object(s) of type Program (DefaultObjectBundleService.java) [system-process]
com.fasterxml.jackson.databind.JsonMappingException: failed to lazily initialize a collection of role: org.hisp.dhis.category.CategoryCombo.userGroupAccesses, could not initialize proxy - no Session (through reference chain: org.hisp.dhis.program.Program[“categoryCombo”]->org.hisp.dhis.category.CategoryCombo[“userGroupAccesses”])
Caused by: org.postgresql.util.PSQLException: ERROR: relation “analytics_event_xkodytbxqxb” does not exist.
I need a help please.
Thank you