← Back to team overview

dhis2-users team mailing list archive

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

 

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>

Follow ups

References