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

[Gérard Bisama]

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
* INFO  2018-11-22 10:50:15,987 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 count(psi)  from analytics_event_nxjcecijiyg where 
"executiondate" >= '2018-12-17' and "executiondate" <= '2018-12-23' and 
("uidlevel4" = 'YAXW12bKSoq' ) and "ps" = 'dWlyeXKe8Wb' and "yearly" in 
('2018') ]; nested exception is org.postgresql.util.PSQLException: ERROR: 
relation "analytics_event_nxjcecijiyg" does not exist
  Position: 25
at 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419)
at 
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:478)
at 
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:488)
at 
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:498)
at 
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:504)
at 
org.hisp.dhis.analytics.event.data.JdbcEventAnalyticsManager.getEventCount(JdbcEventAnalyticsManager.java:232)
at 
org.hisp.dhis.analytics.event.data.DefaultEventAnalyticsService.getEvents(DefaultEventAnalyticsService.java:569)
at 
org.hisp.dhis.webapi.controller.EventAnalyticsController.getQueryJson(EventAnalyticsController.java:465)
at 
org.hisp.dhis.webapi.controller.EventAnalyticsController$$FastClassBySpringCGLIB$$3953848c.invoke()
at 
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at 
org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:69)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at 
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
at 
org.hisp.dhis.webapi.controller.EventAnalyticsController$$EnhancerBySpringCGLIB$$1cc94c81.getQueryJson()
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
at 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandle

[Dhis2-devs] WHO DQA tool and Zeros not storing in DHIS2

[gerald thomas]

Dear all,
We are looking at the WHO tool and there was a concern about the zeros
which are not storing in the PostgreSQL database.
Please is there any solution for these zeros not storing?
Is there another way for the WHO tool to differentiate between an actual
blank space and Zeros?

Thanks in advance for your contribution.

-- 
Regards,

Gerald
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] WHO DQA tool and Zeros not storing in DHIS2

[gerald thomas]

Dear Barnabas,
Thanks for your help.
The issue now is that we had been ignoring it all this time. Now, we want
to consider it again which means we will have to enable them as a batch by
API method but I am inquiring if the previous missing zeros will appear.

On Thu, Nov 22, 2018 at 9:50 AM Barnabas Akumba 
wrote:

> Hello Gerald,
>
> Storing of zeros in the DHIS2 is configured during the Data Element
> Creation stage. There is an option where you need to enable the Data
> Element to store zero values (see attached screen shot).
> [image: image.png]
> Once that is done for all the Data Elements, then the Form will be able to
> store Zero values.
> Regards
>
> On Thu, Nov 22, 2018 at 10:42 AM gerald thomas 
> wrote:
>
>> Dear all,
>> We are looking at the WHO tool and there was a concern about the zeros
>> which are not storing in the PostgreSQL database.
>> Please is there any solution for these zeros not storing?
>> Is there another way for the WHO tool to differentiate between an actual
>> blank space and Zeros?
>>
>> Thanks in advance for your contribution.
>>
>> --
>> Regards,
>>
>> Gerald
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778
> *Skype:* barnabas.akumba
>


-- 
Regards,

Gerald
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] WHO DQA tool and Zeros not storing in DHIS2

[Barnabas Akumba]

Hello Gerald,

Storing of zeros in the DHIS2 is configured during the Data Element
Creation stage. There is an option where you need to enable the Data
Element to store zero values (see attached screen shot).
[image: image.png]
Once that is done for all the Data Elements, then the Form will be able to
store Zero values.
Regards

On Thu, Nov 22, 2018 at 10:42 AM gerald thomas 
wrote:

> Dear all,
> We are looking at the WHO tool and there was a concern about the zeros
> which are not storing in the PostgreSQL database.
> Please is there any solution for these zeros not storing?
> Is there another way for the WHO tool to differentiate between an actual
> blank space and Zeros?
>
> Thanks in advance for your contribution.
>
> --
> Regards,
>
> Gerald
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 

Barnabas AKUMBA

*Mobile:* +2348036195778
*Skype:* barnabas.akumba
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] WHO DQA tool and Zeros not storing in DHIS2

[Barnabas Akumba]

Hello Gerald,
The Zeros were not stored so there won't be any way of recovering them. The
only option would be for you to update the Data Entry with the Zeros again
after you must have enabled the "Store Zero values" option.

Regards

On Thu, Nov 22, 2018 at 11:02 AM gerald thomas 
wrote:

> Dear Barnabas,
> Thanks for your help.
> The issue now is that we had been ignoring it all this time. Now, we want
> to consider it again which means we will have to enable them as a batch by
> API method but I am inquiring if the previous missing zeros will appear.
>
> On Thu, Nov 22, 2018 at 9:50 AM Barnabas Akumba 
> wrote:
>
>> Hello Gerald,
>>
>> Storing of zeros in the DHIS2 is configured during the Data Element
>> Creation stage. There is an option where you need to enable the Data
>> Element to store zero values (see attached screen shot).
>> [image: image.png]
>> Once that is done for all the Data Elements, then the Form will be able
>> to store Zero values.
>> Regards
>>
>> On Thu, Nov 22, 2018 at 10:42 AM gerald thomas 
>> wrote:
>>
>>> Dear all,
>>> We are looking at the WHO tool and there was a concern about the zeros
>>> which are not storing in the PostgreSQL database.
>>> Please is there any solution for these zeros not storing?
>>> Is there another way for the WHO tool to differentiate between an actual
>>> blank space and Zeros?
>>>
>>> Thanks in advance for your contribution.
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
>> --
>>
>> Barnabas AKUMBA
>>
>> *Mobile:* +2348036195778
>> *Skype:* barnabas.akumba
>>
>
>
> --
> Regards,
>
> Gerald
>


-- 

Barnabas AKUMBA

*Mobile:* +2348036195778
*Skype:* barnabas.akumba
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] WHO DQA tool and Zeros not storing in DHIS2

[gerald thomas]

Thank you for the clarification.

On Thu, Nov 22, 2018 at 10:04 AM Barnabas Akumba 
wrote:

> Hello Gerald,
> The Zeros were not stored so there won't be any way of recovering them.
> The only option would be for you to update the Data Entry with the Zeros
> again after you must have enabled the "Store Zero values" option.
>
> Regards
>
> On Thu, Nov 22, 2018 at 11:02 AM gerald thomas 
> wrote:
>
>> Dear Barnabas,
>> Thanks for your help.
>> The issue now is that we had been ignoring it all this time. Now, we want
>> to consider it again which means we will have to enable them as a batch by
>> API method but I am inquiring if the previous missing zeros will appear.
>>
>> On Thu, Nov 22, 2018 at 9:50 AM Barnabas Akumba 
>> wrote:
>>
>>> Hello Gerald,
>>>
>>> Storing of zeros in the DHIS2 is configured during the Data Element
>>> Creation stage. There is an option where you need to enable the Data
>>> Element to store zero values (see attached screen shot).
>>> [image: image.png]
>>> Once that is done for all the Data Elements, then the Form will be able
>>> to store Zero values.
>>> Regards
>>>
>>> On Thu, Nov 22, 2018 at 10:42 AM gerald thomas 
>>> wrote:
>>>
 Dear all,
 We are looking at the WHO tool and there was a concern about the zeros
 which are not storing in the PostgreSQL database.
 Please is there any solution for these zeros not storing?
 Is there another way for the WHO tool to differentiate between an
 actual blank space and Zeros?

 Thanks in advance for your contribution.

 --
 Regards,

 Gerald
 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp

>>>
>>>
>>> --
>>>
>>> Barnabas AKUMBA
>>>
>>> *Mobile:* +2348036195778
>>> *Skype:* barnabas.akumba
>>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778
> *Skype:* barnabas.akumba
>


-- 
Regards,

Gerald
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] WHO DQA tool and Zeros not storing in DHIS2

[Jason Pickering]

Hi Gerald,
No, they will not appear unless people re-enter the data. When this setting
is used, what happens on the client side, is that even if people enter a
zero, it will never get transmitted to the server. In most cases, having
zeros simply leads to massive numbers of zeros stored in the database,
which are not important when things get aggregated. Users are often not
consistent about entering zeros, and trying to divine what the user's
intent was, can be exceedingly difficult. This is the reason that the
"Complete" button was implemented. With proper training and messaging, this
can be used to indicate that the report it complete, and that everything
which is blank, should be able to be assumed to be zero. Often people want
to try and use a zero to indicate that a particular service is offered, but
that there were simply no clients for that reporting period. The problem of
course is whether the data entry staff understand this. I am not sure what
the need for zeroes actually is in your case, but you may want to consider
to use the completion information instead, if possible. We have seen
numerous cases were more than 60% of the values stored in a DHIS2 database
are zeros. This leads to slower performance of analytics, as well as
inflation of backup sizes, so I hope if you do change this, to think
carefully about whether you really, really need all those zeros!

Best regards,
Jason


On Thu, Nov 22, 2018 at 5:03 AM gerald thomas  wrote:

> Dear Barnabas,
> Thanks for your help.
> The issue now is that we had been ignoring it all this time. Now, we want
> to consider it again which means we will have to enable them as a batch by
> API method but I am inquiring if the previous missing zeros will appear.
>
> On Thu, Nov 22, 2018 at 9:50 AM Barnabas Akumba 
> wrote:
>
>> Hello Gerald,
>>
>> Storing of zeros in the DHIS2 is configured during the Data Element
>> Creation stage. There is an option where you need to enable the Data
>> Element to store zero values (see attached screen shot).
>> [image: image.png]
>> Once that is done for all the Data Elements, then the Form will be able
>> to store Zero values.
>> Regards
>>
>> On Thu, Nov 22, 2018 at 10:42 AM gerald thomas 
>> wrote:
>>
>>> Dear all,
>>> We are looking at the WHO tool and there was a concern about the zeros
>>> which are not storing in the PostgreSQL database.
>>> Please is there any solution for these zeros not storing?
>>> Is there another way for the WHO tool to differentiate between an actual
>>> blank space and Zeros?
>>>
>>> Thanks in advance for your contribution.
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
>> --
>>
>> Barnabas AKUMBA
>>
>> *Mobile:* +2348036195778
>> *Skype:* barnabas.akumba
>>
>
>
> --
> Regards,
>
> Gerald
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[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&E/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-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] WHO DQA tool and Zeros not storing in DHIS2

[Jason Pickering]

Hi Elmarie,
Yes, I think that makes sense, but the bigger issue is that data entry
staff may be spending many cumulative man hours entering a whole bunch of
zeros into a form to make it appear that it is complete. This time could
perhaps be better spent on ensuring that the quality of the data (which is
not zero) is of good quality.

I think absolutely that the WHO app needs to take completeness into account
in situations where the data element is not zero significant. It should
also take into account the other situation, when zeros really are
important, which should be very few cases I think But this app should not
drive DHIS2 implementations to enter zeros which really could be better
inferred with the use of the "Complete" button. I think your solution of
removing the zeros for historical periods makes a lot of sense as well.

We have also seen situations where when zeros are used to assess
"completeness", that some data entry staff will zero out the entire form
early in the data entry cycle, to  make it appear that data has been
entered, only to later go back and fill in the data once it becomes
available. In these cases, looking at the audit log (and even auditing the
completeness action itself) may provide better insight into what is going
on.

As you can tell, I am not a big fan of zeros in the database. For the most
part in DHIS2, zeros are imputed when needed to meaningfully aggregate the
data. Otherwise, it would be really impossible to do any analysis in DHIS2!

Best regards,
Jason


On Thu, Nov 22, 2018 at 6:05 AM Elmarie Claasen  wrote:

> Hi Jason,
>
>
>
> These explanations are helpful. As Gerald mentions it is tricky though if
> you want to use the WHO DQ app to find missing values which then flags all
> nulls as missing whether the complete button on the dataset has been
> pressed or not. So in this scenario we have 2 options – capturing zeros
> which is not advised as you point out as it does not affect the aggregated
> values and bloat the database. The 2nd option is that the WHO app could
> be bit more sophisticated to check for the complete flag before flagging a
> value as missing which in my view is 1st prize.
>
>
>
> In SA we currently implement a solution where we save zero values in order
> to monitor completeness but then delete them at the end of the reporting
> financial year because then completeness monitoring is no longer a priority
> for that period.
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: elma...@hisp.org
>
> Skype:  elmarie.claasen52
>
>
>
> *From:* Dhis2-users  hisp@lists.launchpad.net> *On Behalf Of *Jason Pickering
> *Sent:* Thursday, November 22, 2018 12:34 PM
> *To:* gerald thomas 
> *Cc:* dhis2-us...@lists.launchpad.net; dhis2-devs <
> dhis2-devs@lists.launchpad.net>
> *Subject:* Re: [Dhis2-users] [Dhis2-devs] WHO DQA tool and Zeros not
> storing in DHIS2
>
>
>
> Hi Gerald,
>
> No, they will not appear unless people re-enter the data. When this
> setting is used, what happens on the client side, is that even if people
> enter a zero, it will never get transmitted to the server. In most cases,
> having zeros simply leads to massive numbers of zeros stored in the
> database, which are not important when things get aggregated. Users are
> often not consistent about entering zeros, and trying to divine what the
> user's intent was, can be exceedingly difficult. This is the reason that
> the "Complete" button was implemented. With proper training and messaging,
> this can be used to indicate that the report it complete, and that
> everything which is blank, should be able to be assumed to be zero. Often
> people want to try and use a zero to indicate that a particular service is
> offered, but that there were simply no clients for that reporting period.
> The problem of course is whether the data entry staff understand this. I am
> not sure what the need for zeroes actually is in your case, but you may
> want to consider to use the completion information instead, if possible. We
> have seen numerous cases were more than 60% of the values stored in a DHIS2
> database are zeros. This leads to slower performance of analytics, as well
> as inflation of backup sizes, so I hope if you do change this, to think
> carefully about whether you really, really need all those zeros!
>
>
>
> Best regards,
>
> Jason
>
>
>
>
>
> On Thu, Nov 22, 2018 at 5:03 AM gerald thomas 
> wrote:
>
> Dear Barnabas,
>
> Thanks for your help.
>
> The issue now is that we had been ignoring it all this time. Now, we want
> to consider it again which means we will have to enable them as a batch by
> API method but I am inquiring if the previous missing zeros will appear.
>
>
>
> On Thu, Nov 22, 2018 at 9:50 AM Barnabas Akumba 
> wrote:
>
> Hello Gerald,
>
>
>
> Storing of zeros in the DHIS2 is configured during the Data Element
> Creation stage. There i

Re: [Dhis2-devs] [Dhis2-users] WHO DQA tool and Zeros not storing in DHIS2

[Elmarie Claasen]

Hi Jason,



These explanations are helpful. As Gerald mentions it is tricky though if
you want to use the WHO DQ app to find missing values which then flags all
nulls as missing whether the complete button on the dataset has been
pressed or not. So in this scenario we have 2 options – capturing zeros
which is not advised as you point out as it does not affect the aggregated
values and bloat the database. The 2nd option is that the WHO app could be
bit more sophisticated to check for the complete flag before flagging a
value as missing which in my view is 1st prize.



In SA we currently implement a solution where we save zero values in order
to monitor completeness but then delete them at the end of the reporting
financial year because then completeness monitoring is no longer a priority
for that period.



Regards,



*Elmarie Claasen*

[image: Hisp logo]

Project Manager

Health Information Systems Program

Tel:  041-367 1027

Cell: 082 374 2209

E-mail: elma...@hisp.org

Skype:  elmarie.claasen52



*From:* Dhis2-users  *On Behalf Of *Jason Pickering
*Sent:* Thursday, November 22, 2018 12:34 PM
*To:* gerald thomas 
*Cc:* dhis2-us...@lists.launchpad.net; dhis2-devs <
dhis2-devs@lists.launchpad.net>
*Subject:* Re: [Dhis2-users] [Dhis2-devs] WHO DQA tool and Zeros not
storing in DHIS2



Hi Gerald,

No, they will not appear unless people re-enter the data. When this setting
is used, what happens on the client side, is that even if people enter a
zero, it will never get transmitted to the server. In most cases, having
zeros simply leads to massive numbers of zeros stored in the database,
which are not important when things get aggregated. Users are often not
consistent about entering zeros, and trying to divine what the user's
intent was, can be exceedingly difficult. This is the reason that the
"Complete" button was implemented. With proper training and messaging, this
can be used to indicate that the report it complete, and that everything
which is blank, should be able to be assumed to be zero. Often people want
to try and use a zero to indicate that a particular service is offered, but
that there were simply no clients for that reporting period. The problem of
course is whether the data entry staff understand this. I am not sure what
the need for zeroes actually is in your case, but you may want to consider
to use the completion information instead, if possible. We have seen
numerous cases were more than 60% of the values stored in a DHIS2 database
are zeros. This leads to slower performance of analytics, as well as
inflation of backup sizes, so I hope if you do change this, to think
carefully about whether you really, really need all those zeros!



Best regards,

Jason





On Thu, Nov 22, 2018 at 5:03 AM gerald thomas  wrote:

Dear Barnabas,

Thanks for your help.

The issue now is that we had been ignoring it all this time. Now, we want
to consider it again which means we will have to enable them as a batch by
API method but I am inquiring if the previous missing zeros will appear.



On Thu, Nov 22, 2018 at 9:50 AM Barnabas Akumba 
wrote:

Hello Gerald,



Storing of zeros in the DHIS2 is configured during the Data Element
Creation stage. There is an option where you need to enable the Data
Element to store zero values (see attached screen shot).

[image: image.png]

Once that is done for all the Data Elements, then the Form will be able to
store Zero values.

Regards



On Thu, Nov 22, 2018 at 10:42 AM gerald thomas 
wrote:

Dear all,

We are looking at the WHO tool and there was a concern about the zeros
which are not storing in the PostgreSQL database.

Please is there any solution for these zeros not storing?

Is there another way for the WHO tool to differentiate between an actual
blank space and Zeros?



Thanks in advance for your contribution.


-- 

Regards,



Gerald

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-us...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp




-- 



Barnabas AKUMBA



*Mobile:* +2348036195778

*Skype:* barnabas.akumba



-- 

Regards,



Gerald

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp




-- 

Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049 <+46764147049>

-- 


*This message and any attachments are subject to a disclaimer published

at http://www.hisp.org/policies.html#comms_disclaimer 
. 
Please read the 
disclaimer before opening any attachment or taking any other
action in 
terms of this electronic transmission.  If you cannot access the

disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will b

Re: [Dhis2-devs] [Dhis2-users] WHO DQA tool and Zeros not storing in DHIS2

[gerald thomas]

Dear Jason,
Thanks for the confirmation. Based on our discussions few minutes ago; the
M&Es think this will help them to show the performances of their programs.
For example:
In a particular facility A; during the months Jan, Feb, Mar, Apr, May; the
cases of measles are 5, 8, 9, 0, 10...
In our data collection, Apr will be seeing as no entry ( which means we
can’t identify whether it is zero measle case or no entry was done.

On Thu, 22 Nov 2018 at 10:34, Jason Pickering 
wrote:

> Hi Gerald,
> No, they will not appear unless people re-enter the data. When this
> setting is used, what happens on the client side, is that even if people
> enter a zero, it will never get transmitted to the server. In most cases,
> having zeros simply leads to massive numbers of zeros stored in the
> database, which are not important when things get aggregated. Users are
> often not consistent about entering zeros, and trying to divine what the
> user's intent was, can be exceedingly difficult. This is the reason that
> the "Complete" button was implemented. With proper training and messaging,
> this can be used to indicate that the report it complete, and that
> everything which is blank, should be able to be assumed to be zero. Often
> people want to try and use a zero to indicate that a particular service is
> offered, but that there were simply no clients for that reporting period.
> The problem of course is whether the data entry staff understand this. I am
> not sure what the need for zeroes actually is in your case, but you may
> want to consider to use the completion information instead, if possible. We
> have seen numerous cases were more than 60% of the values stored in a DHIS2
> database are zeros. This leads to slower performance of analytics, as well
> as inflation of backup sizes, so I hope if you do change this, to think
> carefully about whether you really, really need all those zeros!
>
> Best regards,
> Jason
>
>
> On Thu, Nov 22, 2018 at 5:03 AM gerald thomas 
> wrote:
>
>> Dear Barnabas,
>> Thanks for your help.
>> The issue now is that we had been ignoring it all this time. Now, we want
>> to consider it again which means we will have to enable them as a batch by
>> API method but I am inquiring if the previous missing zeros will appear.
>>
>> On Thu, Nov 22, 2018 at 9:50 AM Barnabas Akumba 
>> wrote:
>>
>>> Hello Gerald,
>>>
>>> Storing of zeros in the DHIS2 is configured during the Data Element
>>> Creation stage. There is an option where you need to enable the Data
>>> Element to store zero values (see attached screen shot).
>>> [image: image.png]
>>> Once that is done for all the Data Elements, then the Form will be able
>>> to store Zero values.
>>> Regards
>>>
>>> On Thu, Nov 22, 2018 at 10:42 AM gerald thomas 
>>> wrote:
>>>
 Dear all,
 We are looking at the WHO tool and there was a concern about the zeros
 which are not storing in the PostgreSQL database.
 Please is there any solution for these zeros not storing?
 Is there another way for the WHO tool to differentiate between an
 actual blank space and Zeros?

 Thanks in advance for your contribution.

 --
 Regards,

 Gerald
 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp

>>>
>>>
>>> --
>>>
>>> Barnabas AKUMBA
>>>
>>> *Mobile:* +2348036195778
>>> *Skype:* barnabas.akumba
>>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>
>
>>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>
-- 
Regards,

Gerald
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[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&E/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-devs@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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[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&E/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-devs@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-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[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&E/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-devs@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-us...@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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp