dhis2-devs team mailing list archive

[Gérard Bisama <gerbis2000@xxxxxxxxx>]

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.magoba@xxxxxxxxx> 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.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>
> <#m_6837731379111127580_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
>>
>

-- 
Gérard Bisama
Tel:+243810890810