Hi Bridget, I have entered data to the stage level but I still have the same problem.
Le jeu. 22 nov. 2018 à 10:14, Magoba Bridget <bridget.mag...@gmail.com> a écrit : > Hi Gérard, > Make sure you have some data entered at the stage level since event > reports are generated at by stage. > > Crosscheck that and also run analytics to view your data in reports. > > Good luck > > *Bridget Magoba* > *M&E/DHIS2 Implementer * > [image: HISP Uganda] > *Health Information Systems Program-Uganda* > *www.hispuganda.org/ <http://www.hispuganda.org/>* > *Cell: +256 774659892 / +256703260439 * > *Email:* *bridget.mag...@gmail.com <bridget.mag...@gmail.com>* > *SkypeId:* *magoba.bridget1* > > > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon> > Virus-free. > www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link> > <#m_6837731379111127580_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > On Thu, Nov 22, 2018 at 12:09 PM Gérard Bisama <gerbis2...@gmail.com> > wrote: > >> Hi everyone, >> >> 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. >> >> Thanks >> -- >> Gérard Bisama >> Tel:+243810890810 >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> > -- Gérard Bisama Tel:+243810890810
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
