← Back to team overview

dhis2-devs team mailing list archive

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

 

Ok. But can it be solved? It will appear in the next leap-year.

DHIS2 is an excellent work done by all of you (and us) and we are hesitant
to say all users that it's DHIS2's fault.

Regards

Hannan

On Tue, Mar 29, 2016 at 3:58 PM, Lars Helge Øverland <lars@xxxxxxxxx> wrote:

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

References