← Back to team overview

dhis2-users team mailing list archive

Re: dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

 

Thanks Fatema, that's great news.

best regards,

Lars


On Sat, Jul 4, 2015 at 12:55 PM, Uddin Fatema <fatemacse@xxxxxxxxx> wrote:

> Dear Lars,
>
> Thank you very much. I am really happy that 2.19 is working fine. Time
> zone problem solved and aggregated data problem also solved.
>
> Again thanks a lot for you and core teams hard work.
>
> Best Regards
>
> Fatema
>
> On Wed, Jun 24, 2015 at 4:11 PM, Uddin Fatema <fatemacse@xxxxxxxxx> wrote:
>
>> Dear Lars,
>>
>> Here I attached the Error Log file
>>
>> Thanks in advance
>>
>> On Tue, Jun 23, 2015 at 4: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>
>>>
>>>
>>
>>
>> --
>> 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>

References