dhis2-devs team mailing list archive

[Gérard Bisama <gerbis2000@xxxxxxxxx>]

Hi John,

I did all that but nothing happen. Perhaps I will try to install a new
build of the war file.

Le jeu. 22 nov. 2018 à 15:44, Bidemi John <john.bidemi82@xxxxxxxxx> a
écrit :

> 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.
>
> Thank you
>
> John
>
> On Thu, Nov 22, 2018, 3:40 PM Gérard Bisama <gerbis2000@xxxxxxxxx wrote:
>
>> 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_-450435127967545109_m_-4996619741227251611_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
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>

-- 
Gérard Bisama
Tel:+243810890810