I am using tracker to capture individual case and everything seem fine. I can also display program summary report. But when I go in the event report app to display attributes of cases after selecting attributes, period and orgunit, the table is empty.
I have triggered the analytics process manually but I don’t still have data in my report.
When I check the log, I have the following information when I click on “update” in the event report. I use version 2.29
NFO 2018-11-22 10:50:15,989 Query failed, likely because the requested analytics table does not exist (JdbcEventAnalyticsManager.java [http-bio-8082-exec-8])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select psi,ps,executiondate,longitude,latitude,ouname,oucode,“ou”,“VNKpiI6YU9N”,“jYHf43Di8TO”,“uMfREBn1pLQ” from analytics_event_nxjcecijiyg where “executiondate” >= ‘2018-12-17’ and “executiondate” <= ‘2018-12-23’ and (“uidlevel4” = ‘YAXW12bKSoq’ ) and “ps” = ‘dWlyeXKe8Wb’ and “yearly” in (‘2018’) limit 100 offset 0]; nested exception is org.postgresql.util.PSQLException: ERROR: relation “analytics_event_nxjcecijiyg” does not exist
For more details here is enclosed the complete output of my log.
You would need to manually run the analytics for data entered to show in any of the analysis modules.
Go to Report Module, locate the Analytics options by the left and click on the start export button. Once this is done. Go to the event report module and check again.
I am using tracker to capture individual case and everything seem fine. I can also display program summary report. But when I go in the event report app to display attributes of cases after selecting attributes, period and orgunit, the table is empty.
I have triggered the analytics process manually but I don’t still have data in my report.
When I check the log, I have the following information when I click on “update” in the event report. I use version 2.29
NFO 2018-11-22 10:50:15,989 Query failed, likely because the requested analytics table does not exist (JdbcEventAnalyticsManager.java [http-bio-8082-exec-8])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select psi,ps,executiondate,longitude,latitude,ouname,oucode,“ou”,“VNKpiI6YU9N”,“jYHf43Di8TO”,“uMfREBn1pLQ” from analytics_event_nxjcecijiyg where “executiondate” >= ‘2018-12-17’ and “executiondate” <= ‘2018-12-23’ and (“uidlevel4” = ‘YAXW12bKSoq’ ) and “ps” = ‘dWlyeXKe8Wb’ and “yearly” in (‘2018’) limit 100 offset 0]; nested exception is org.postgresql.util.PSQLException: ERROR: relation “analytics_event_nxjcecijiyg” does not exist
For more details here is enclosed the complete output of my log.
The event report app has two tabs for showing aggregated values and events. So if you want to see the individual records, make sure that you click on the events tab and update. it will display the list for you.
Absolom
Hi John,
I did all that but nothing happen. Perhaps I will try to install a new build of the war file.
On Thursday, November 22, 2018 6:19 PM, Gérard Bisama gerbis2000@gmail.com wrote:
Hello Bisama,
You would need to manually run the analytics for data entered to show in any of the analysis modules.
Go to Report Module, locate the Analytics options by the left and click on the start export button. Once this is done. Go to the event report module and check again.
I am using tracker to capture individual case and everything seem fine. I can also display program summary report. But when I go in the event report app to display attributes of cases after selecting attributes, period and orgunit, the table is empty.
I have triggered the analytics process manually but I don’t still have data in my report.
When I check the log, I have the following information when I click on “update” in the event report. I use version 2.29
NFO 2018-11-22 10:50:15,989 Query failed, likely because the requested analytics table does not exist (JdbcEventAnalyticsManager.java [http-bio-8082-exec-8])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select psi,ps,executiondate,longitude,latitude,ouname,oucode,“ou”,“VNKpiI6YU9N”,“jYHf43Di8TO”,“uMfREBn1pLQ” from analytics_event_nxjcecijiyg where “executiondate” >= ‘2018-12-17’ and “executiondate” <= ‘2018-12-23’ and (“uidlevel4” = ‘YAXW12bKSoq’ ) and “ps” = ‘dWlyeXKe8Wb’ and “yearly” in (‘2018’) limit 100 offset 0]; nested exception is org.postgresql.util.PSQLException: ERROR: relation “analytics_event_nxjcecijiyg” does not exist
For more details here is enclosed the complete output of my log.