dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #07534
Re: [Dhis2-devs] [Bug 1467115] [NEW] Data values not found
on my side it shows empty too, see the snapshot attached
On Sun, Jun 21, 2015 at 8:42 AM, Uddin Fatema <fatemacse@xxxxxxxxx> wrote:
> It shows empty
>
> On Sun, Jun 21, 2015 at 1:27 PM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>> Could you report the result of the following query? Does it return any
>> rows?
>>
>> SELECT startdate,enddate,periodtypeid from period GROUP BY
>> startdate,enddate,periodtypeid HAVING COUNT(*) > 1;
>>
>> Regards,
>> Jason
>>
>>
>> On Sun, Jun 21, 2015 at 8:49 AM, Uddin Fatema <fatemacse@xxxxxxxxx>
>> wrote:
>>
>>> Dear Lionel,
>>>
>>> I am facing this problem last few months in latest version 2.18 and
>>> 2.19, so i could not upgrade our system in new version. I hope developer
>>> can help us on it.
>>>
>>> Thnaks
>>>
>>> On Sun, Jun 21, 2015 at 12:35 PM, Lionel Ruberintwari <
>>> ruberlio@xxxxxxxxx> wrote:
>>>
>>>> Hello,
>>>>
>>>> In fact i was using the wrong timezome (UTC +02.:00) i had set the
>>>> right timezone (UTC +01:00) on local machine (running windows) afther this
>>>> i run once again analytics and experienced the same errors. Any advices?
>>>>
>>>> best regards,
>>>>
>>>>
>>>> On Sun, Jun 21, 2015 at 5:45 AM, Uddin Fatema <fatemacse@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Dear Knut,
>>>>>
>>>>> This is time zone problem in 2.18 and 2.19, I have changes the time
>>>>> zone (UTC+06:30) yangon (Rangoon) that time it is running well, but after
>>>>> back again (UTC+06:00) Dhaka, It shows same error.
>>>>>
>>>>> I am facing same problem. Please sir have a look on it.
>>>>>
>>>>> Thanks
>>>>>
>>>>> On Sat, Jun 20, 2015 at 9:47 PM, Knut Staring <knutst@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Please send to the list instead
>>>>>> On Jun 20, 2015 3:25 PM, "lionel ruberintwari" <ruberlio@xxxxxxxxx>
>>>>>> wrote:
>>>>>>
>>>>>>> Public bug reported:
>>>>>>>
>>>>>>> Hi all,
>>>>>>>
>>>>>>> We installed a fresh DHIS 2 (2.18) instance and we have imported our
>>>>>>> postgres dump, the problem we face is we are not abble to vizualise
>>>>>>> any
>>>>>>> data however if you go through data entry and choose org unit and
>>>>>>> period, we are able to view data but not possible through report
>>>>>>> module
>>>>>>> and dashboard. We have tried to do analytic and we got error as
>>>>>>> attached
>>>>>>> in the snapshot. Thanks in advance for your help
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> ** Affects: dhis2
>>>>>>> Importance: Undecided
>>>>>>> Status: New
>>>>>>>
>>>>>>> ** Attachment added: "Analytique.JPG"
>>>>>>>
>>>>>>> https://bugs.launchpad.net/bugs/1467115/+attachment/4417600/+files/Analytique.JPG
>>>>>>>
>>>>>>> --
>>>>>>> You received this bug notification because you are a member of DHIS 2
>>>>>>> developers, which is subscribed to DHIS.
>>>>>>> https://bugs.launchpad.net/bugs/1467115
>>>>>>>
>>>>>>> Title:
>>>>>>> Data values not found
>>>>>>>
>>>>>>> Status in DHIS 2:
>>>>>>> New
>>>>>>>
>>>>>>> Bug description:
>>>>>>> Hi all,
>>>>>>>
>>>>>>> We installed a fresh DHIS 2 (2.18) instance and we have imported
>>>>>>> our
>>>>>>> postgres dump, the problem we face is we are not abble to vizualise
>>>>>>> any data however if you go through data entry and choose org unit
>>>>>>> and
>>>>>>> period, we are able to view data but not possible through report
>>>>>>> module and dashboard. We have tried to do analytic and we got
>>>>>>> error as
>>>>>>> attached in the snapshot. Thanks in advance for your help
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> To manage notifications about this bug go to:
>>>>>>> https://bugs.launchpad.net/dhis2/+bug/1467115/+subscriptions
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>> More help : https://help.launchpad.net/ListHelp
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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>
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> 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-devs
>>> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+46764147049
>>
>
>
>
> --
> 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>
>
>
Attachment:
SQL Query.PNG
Description: PNG image
Follow ups
References