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
···
On Mon, Jun 22, 2015 at 12:26 AM, romain@tohouri.com rtohouri@gmail.com 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@gmail.com 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
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
On Sun, Jun 21, 2015 at 10:01 AM, Lionel Ruberintwari ruberlio@gmail.com wrote:
on my side it shows empty too, see the snapshot attached
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
On Sun, Jun 21, 2015 at 8:42 AM, Uddin Fatema fatemacse@gmail.com wrote:
It shows empty
On Sun, Jun 21, 2015 at 1:27 PM, Jason Pickering jason.p.pickering@gmail.com 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
–
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
On Sun, Jun 21, 2015 at 8:49 AM, Uddin Fatema fatemacse@gmail.com 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
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
–
On Sun, Jun 21, 2015 at 12:35 PM, Lionel Ruberintwari ruberlio@gmail.com 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,
–
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
On Sun, Jun 21, 2015 at 5:45 AM, Uddin Fatema fatemacse@gmail.com 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@gmail.com wrote:
Please send to the list instead
On Jun 20, 2015 3:25 PM, “lionel ruberintwari” ruberlio@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
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