dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Fatema,

I have made a fix for the problem with inaccurate aggregate values for data
elements with average aggregation operator (e.g. 51.7 instead of 50) now in
trunk and 2.19.

New build is available from https://www.dhis2.org/downloads in 40 minutes.

regards,

Lars


On Tue, Jun 23, 2015 at 12:48 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>
wrote:

> Okay. Can can you please
>
> - provide the output of the tomcat log for when it fails
>
> - try by downloading 2.18 from https://www.dhis2.org/downloads to rule
> out build issues
>
>
> regards,
>
> Lars
>
>
> On Tue, Jun 23, 2015 at 12:30 PM, Uddin Fatema <fatemacse@xxxxxxxxx>
> wrote:
>
>> Dear Lars,
>>
>> Thanks a lot
>>
>> I just download 2.18 branch code and build the war file. Now i am running
>> my database with this war file with UTC +6 Dhaka time zone  but still shows
>> same error.
>>
>> Is it cash problem or anything else.
>>
>> On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland <larshelge@xxxxxxxxx
>> > wrote:
>>
>>> Hi Fatema,
>>>
>>> we have made a fix to prevent time zone issues for resource table
>>> generation in 2.18 and 2.19 now.
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>> On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema <fatemacse@xxxxxxxxx>
>>> wrote:
>>>
>>>> Yes Lars i found same error in 2.18 too.
>>>>
>>>> Actually I updated version in 2.18 in test server but still time zone
>>>> error remains for  (UTC+60 )Dhaka . You know that some time zone has time
>>>> zone problem in resource table generation. So I Changes time zone UTC+6:30)
>>>> Yaangoon) and update resource table and analytic.
>>>>
>>>> And still I found same error which is described me and Nayeem Al Miftah.
>>>>
>>>> Thanks
>>>>
>>>> On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah <n.mifthah@xxxxxxxxx
>>>> > wrote:
>>>>
>>>>> Dear Lars
>>>>> There are monthly datasets on which a data entry operator input 50 in
>>>>> a cell. Analytic shows that same number as 51.7 in those months which have
>>>>> 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in
>>>>> February as it have 28 days.
>>>>>
>>>>> It has happened as the analytic table calculate the data as Ms. Fatema
>>>>> has described.
>>>>>
>>>>>
>>>>>
>>>>> Nayeem Al Mifthah
>>>>> HMIS Consultant
>>>>> Management Information System
>>>>> Directorate General of Health Services (DGHS), Bangladesh
>>>>> Supported by: UNICEF-Bangladesh
>>>>> Email: n.mifthah@xxxxxxxxx  | nayeem@xxxxxxxxxxxxxxx
>>>>> Cell:+8801914030574
>>>>>
>>>>> On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland <
>>>>> larshelge@xxxxxxxxx> wrote:
>>>>>
>>>>>> Hi Fatema,
>>>>>>
>>>>>> do you think you could explain a bit more about the data elements and
>>>>>> calculation?
>>>>>>
>>>>>> Do you think you cold try with 2.18 / 2.19 ?
>>>>>>
>>>>>> regards,
>>>>>>
>>>>>> Lars
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema <fatemacse@xxxxxxxxx>
>>>>>> wrote:
>>>>>>
>>>>>>> Dear All,
>>>>>>>
>>>>>>>  Data Analytic table retrieve wrong data in Pivot table, data
>>>>>>> visualizer and GIS  and same error remain 2.17 and 2.16 too
>>>>>>>
>>>>>>> Here i attach screen short of Pivote Table Analysis and Data Entry
>>>>>>> Screen
>>>>>>>
>>>>>>>
>>>>>>> In pivote table value shows =  51.7
>>>>>>>
>>>>>>> but originally  dataentry screen shows  = 50
>>>>>>>
>>>>>>> Calculation
>>>>>>> it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
>>>>>>> But it should do  daysxvalue/daysno  = 50*31/31 =50
>>>>>>>
>>>>>>>
>>>>>>> Please have a look on it.
>>>>>>>
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>>
>>>>>>> Fatema
>>>>>>> ------- Forwarded message ----------
>>>>>>> rom: Uddin Fatema <fatemacse@xxxxxxxxx>
>>>>>>> Date: Tue, May 5, 2015 at 5:56 PM
>>>>>>> Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot
>>>>>>> table, data visualizer and GIS.
>>>>>>> To: Jan Henrik Øverland <janhenrik.overland@xxxxxxxxx>
>>>>>>>
>>>>>>>
>>>>>>> Dear Jan,
>>>>>>>
>>>>>>> DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping
>>>>>>> retrieve wrong data from Analytics_2015 or all analytics table.
>>>>>>>
>>>>>>> The problem is in analytics table it store daysxvalue , daysno and
>>>>>>> value
>>>>>>> column but when it retrieve data for pivote table, data-visualizer
>>>>>>> and gis that time it is dividing daysxvalue / 30
>>>>>>> But it should do  daysxvalue/daysno
>>>>>>>
>>>>>>> As a result in pivot table, data visualizer and gis mapping shows
>>>>>>> wrong data.
>>>>>>>
>>>>>>> Could you please solved it additionally, can you please tell me in
>>>>>>> source code in which file i have to change.
>>>>>>>
>>>>>>> Thanks a lot in advance.
>>>>>>>
>>>>>>> Regards,
>>>>>>> *Fatema Uddin*
>>>>>>>
>>>>>>> Technical Advisor (HIS)-Support to the Health Sector Program II
>>>>>>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
>>>>>>> German House
>>>>>>> House 10/A-2, Road 90
>>>>>>> Gulshan 2, Dhaka 1212, Bangladesh
>>>>>>>
>>>>>>> T          +880 9666701000
>>>>>>> F          +880 28823099
>>>>>>> M         +880 19 6206 4721
>>>>>>> I           www.giz.de
>>>>>>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Regards,
>>>>>>> *Fatema Uddin*
>>>>>>>
>>>>>>> Technical Advisor (HIS)-Support to the Health Sector Program II
>>>>>>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
>>>>>>> German House
>>>>>>> House 10/A-2, Road 90
>>>>>>> Gulshan 2, Dhaka 1212, Bangladesh
>>>>>>>
>>>>>>> T          +880 9666701000
>>>>>>> F          +880 28823099
>>>>>>> M         +880 19 6206 4721
>>>>>>> I           www.giz.de
>>>>>>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Lars Helge Øverland
>>>>>> Lead developer, DHIS 2
>>>>>> University of Oslo
>>>>>> Skype: larshelgeoverland
>>>>>> http://www.dhis2.org <https://www.dhis2.org>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> *Fatema Uddin*
>>>>
>>>> Technical Advisor (HIS)-Support to the Health Sector Program II
>>>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
>>>> German House
>>>> House 10/A-2, Road 90
>>>> Gulshan 2, Dhaka 1212, Bangladesh
>>>>
>>>> T          +880 9666701000
>>>> F          +880 28823099
>>>> M         +880 19 6206 4721
>>>> I           www.giz.de
>>>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>
>>>>
>>>>
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> http://www.dhis2.org <https://www.dhis2.org>
>>>
>>>
>>
>>
>> --
>> Regards,
>> *Fatema Uddin*
>>
>> Technical Advisor (HIS)-Support to the Health Sector Program II
>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
>> German House
>> House 10/A-2, Road 90
>> Gulshan 2, Dhaka 1212, Bangladesh
>>
>> T          +880 9666701000
>> F          +880 28823099
>> M         +880 19 6206 4721
>> I           www.giz.de
>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org>
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org>