← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

 

Hi Hannan,

is this for February 2016? If so I suspect this is a leap-year issue (and
not an issue for other periods). We can look into it but this might not be
critical..

regards,

Lars

On Sun, Mar 27, 2016 at 8:56 AM, Hannan Khan <hannank@xxxxxxxxx> wrote:

> Dear Lars
>
> The problem in this thread arise again. That problem was fixed in the
> trunk and suppose to reflect in the later versions. Can you please check
> this issue and find a solution as soon as possible.
>
> We using version 2.22 build 21827.
>
> Regards
>
> Hannan Khan
> HISP Bangladesh
>
>
> On Sat, Jul 4, 2015 at 4: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>
>>
>>
>> _______________________________________________
>> 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
>>
>>
>


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

Follow ups

References