dhis2-users team mailing list archive

[Magoba Bridget <bridget.magoba@xxxxxxxxx>]

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.magoba@xxxxxxxxx <bridget.magoba@xxxxxxxxx>*
*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>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Thu, Nov 22, 2018 at 12:09 PM Gérard Bisama <gerbis2000@xxxxxxxxx> 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-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>