subject:"Re\: \[Dhis2\-users\] \[Dhis2\-devs\] Event report does not shows the tracker informations"

Re: [Dhis2-users] [Dhis2-devs] Event report does not shows the tracker informations

2018-11-23 Thread Absolom MURAMIRA

Hello Gérard,
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 

On Thursday, November 22, 2018 6:19 PM, Gérard Bisama 
 wrote:
 

 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  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  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 MagobaM/DHIS2 Implementer   Health Information Systems 
Program-Ugandawww.hispuganda.org/
Cell: +256 774659892 / +256703260439  Email: bridget.magoba@gmail.comSkypeId: 
magoba.bridget1


|  | Virus-free. www.avast.com  |


On Thu, Nov 22, 2018 at 12:09 PM Gérard Bisama  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




-- 
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


   ___
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

Re: [Dhis2-users] [Dhis2-devs] Event report does not shows the tracker informations

2018-11-22 Thread Gérard Bisama

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  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 
>> 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 
>> 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/DHIS2 Implementer *
>>>   [image: HISP Uganda]
>>> *Health Information Systems Program-Uganda*
>>> *www.hispuganda.org/ *
>>> *Cell: +256 774659892 / +256703260439  *
>>> *Email:* *bridget.mag...@gmail.com *
>>> *SkypeId:* *magoba.bridget1*
>>>
>>>
>>>
>>> 
>>>  Virus-free.
>>> www.avast.com
>>> 
>>> <#m_-450435127967545109_m_-4996619741227251611_m_683773137927580_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>>
>>> On Thu, Nov 22, 2018 at 12:09 PM Gérard Bisama 
>>> 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
>>
>

-- 
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

Re: [Dhis2-users] [Dhis2-devs] Event report does not shows the tracker informations

2018-11-22 Thread Bidemi John

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  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  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/DHIS2 Implementer *
>>   [image: HISP Uganda]
>> *Health Information Systems Program-Uganda*
>> *www.hispuganda.org/ *
>> *Cell: +256 774659892 / +256703260439  *
>> *Email:* *bridget.mag...@gmail.com *
>> *SkypeId:* *magoba.bridget1*
>>
>>
>>
>> 
>>  Virus-free.
>> www.avast.com
>> 
>> <#m_-4996619741227251611_m_683773137927580_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>> On Thu, Nov 22, 2018 at 12:09 PM Gérard Bisama 
>> 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
>
___
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

Re: [Dhis2-users] [Dhis2-devs] Event report does not shows the tracker informations

2018-11-22 Thread Gérard Bisama

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  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/DHIS2 Implementer *
>   [image: HISP Uganda]
> *Health Information Systems Program-Uganda*
> *www.hispuganda.org/ *
> *Cell: +256 774659892 / +256703260439  *
> *Email:* *bridget.mag...@gmail.com *
> *SkypeId:* *magoba.bridget1*
>
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_683773137927580_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> On Thu, Nov 22, 2018 at 12:09 PM Gérard Bisama 
> 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

Re: [Dhis2-users] [Dhis2-devs] Event report does not shows the tracker informations

2018-11-22 Thread Magoba Bridget

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/DHIS2 Implementer *
  [image: HISP Uganda]
*Health Information Systems Program-Uganda*
*www.hispuganda.org/ *
*Cell: +256 774659892 / +256703260439  *
*Email:* *bridget.mag...@gmail.com *
*SkypeId:* *magoba.bridget1*



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Thu, Nov 22, 2018 at 12:09 PM Gérard Bisama  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
>
___
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

Re: [Dhis2-users] [Dhis2-devs] Event report does not shows the tracker informations

Re: [Dhis2-users] [Dhis2-devs] Event report does not shows the tracker informations

Re: [Dhis2-users] [Dhis2-devs] Event report does not shows the tracker informations

Re: [Dhis2-users] [Dhis2-devs] Event report does not shows the tracker informations

Re: [Dhis2-users] [Dhis2-devs] Event report does not shows the tracker informations

5 matches

Site Navigation

Mail list logo

Footer information