dhis2-users team mailing list archive

[Lionel Ruberintwari <ruberlio@xxxxxxxxx>]

Any update on how to resolve this bug? I have deleted all table ressource
beginning with _ in Pg database and regenerate ressources tables in DHIS
but the issue was not sorted out. Please any advice will be more than
welcome

Regards,

Lionel

On Mon, Jun 22, 2015 at 12:26 AM, romain@xxxxxxxxxxx <rtohouri@xxxxxxxxx>
wrote:

> Hi Jason and Uddin,
> I thank I’m experimenting similar problem. Migrating a database form 2.16
> to 2.17 works well but migrating the same database from 2.17 to 2.18 show
> empty analytics tables.
> I’ve tried to execute analytics several time but same problem and no error
> message in the catalina logs so no way to guess the problem…
> I’m working on but still no solution so any advise will be more than
> welcome.
>
> Thx,
>
> Romain
>
> On Jun 21, 2015, at 08:10, Jason Pickering <jason.p.pickering@xxxxxxxxx>
> wrote:
>
> Looks like it may be related to the bug which Morten was working on but
> maybe a bad period.
>
> What does this return?
>
> SELECT a.startdate,a.enddate,b.name as periodtype from period a
> INNER JOIN periodtype b on a.periodtypeid = b.periodtypeid where
> a.startdate = '2015-04-01';
>
> Regards,
> Jason
>
>
> On Sun, Jun 21, 2015 at 10:01 AM, Lionel Ruberintwari <ruberlio@xxxxxxxxx>
> wrote:
>
>> 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>
>>>
>>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>  _______________________________________________
> 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
>
>
>