[Dhis2-devs] [Bug 1467115] [NEW] Data values not found

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

Dear Lionel,

please change your timezone and try to re-run analytics.

Attempt to check the period table and see if there are periods with wrong periodtypeids and if they exist delete them and re-run analytics.

Alex

···

On Sat, Jun 20, 2015 at 6: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

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

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

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

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@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,

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

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

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

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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

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

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

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 my side it shows empty too, see the snapshot attached

image

···

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

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@gmail.com wrote:

on my side it shows empty too, see the snapshot attached

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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

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