Event report tables added to dashboards are displayed 'blank' when period is selected as Start-End dates (2.25)

Hi!

We have noticed (tested in https://play.dhis2.org) that any event report table that is defined with a period type ‘Start/end dates’ instead of ‘Fixed and relative periods’ is displayed ‘blank’ when added to a dashboard (see image below).

The error generated is:

{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"Start date or end date is invalid: 2016-07-24T00:00:00.000 - 2016-10-24T00:00:00.000"}

It seems to be related to date format, since removing the bold text in the original query (see below), it works!
[https://play.dhis2.org/demo/api/analytics/events/query/eBAyeGv0exc.json?stage=Zj7UnCAulEk&dimension=ou:O6uvpzGd5pu&dimension=eMyVanycQSC&dimension=qrur9Dvnyt5-Yf6UHoPkdS6&dimension=tUdBD1JDxpn&dimension=sGna2pquXOO&dimension=Kswd1r4qWLh&dimension=gWxh7DiRmG7&dimension=x7PaHGvgWY2&dimension=XCMi7Wvnplm&dimension=hlPt8H4bUOQ&dimension=Thkx2BnO5Kq&dimension=Y7hKDSuqEtH&dimension=K6uUAvq500H&dimension=msodh3rEMJa&dimension=oZg33kd9taw&dimension=GieVkTxp4HH-TBxGTceyzwy&dimension=HS8QXAJtuKV&dimension=fWIAEtYVEGk&dimension=SWfdB5lX0fk&dimension=vV9UWAZohSf-OrkEzxZEH4X&startDate=2016-07-24](https://play.dhis2.org/demo/api/analytics/events/query/eBAyeGv0exc.json?stage=Zj7UnCAulEk&dimension=ou:O6uvpzGd5pu&dimension=eMyVanycQSC&dimension=qrur9Dvnyt5-Yf6UHoPkdS6&dimension=tUdBD1JDxpn&dimension=sGna2pquXOO&dimension=Kswd1r4qWLh&dimension=gWxh7DiRmG7&dimension=x7PaHGvgWY2&dimension=XCMi7Wvnplm&dimension=hlPt8H4bUOQ&dimension=Thkx2BnO5Kq&dimension=Y7hKDSuqEtH&dimension=K6uUAvq500H&dimension=msodh3rEMJa&dimension=oZg33kd9taw&dimension=GieVkTxp4HH-TBxGTceyzwy&dimension=HS8QXAJtuKV&dimension=fWIAEtYVEGk&dimension=SWfdB5lX0fk&dimension=vV9UWAZohSf-OrkEzxZEH4X&startDate=2016-07-24)**T00:00:00.000**&endDate=2016-10-24**T00:00:00.000**&pageSize=50&page=1&displayProperty=NAME


Cheers!

Alejandro

Agree. We are facing the same issue as well. Event reports are being rendered as blank dashboard items, regardless of what configuration they have for periods. When we click on ‘explore’ for that dashboard item, it takes us merely to Event Reports App, but does not render the saved report.

Could you please help fix the issue.

Cheers,

···

On Mon, Oct 24, 2016 at 9:36 PM, Alejandro acasrod@gmail.com wrote:

Hi!

We have noticed (tested in https://play.dhis2.org) that any event report table that is defined with a period type ‘Start/end dates’ instead of ‘Fixed and relative periods’ is displayed ‘blank’ when added to a dashboard (see image below).

The error generated is:


{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"Start date or end date is invalid: 2016-07-24T00:00:00.000 - 2016-10-24T00:00:00.000"}


It seems to be related to date format, since removing the bold text in the original query (see below), it works!
[https://play.dhis2.org/demo/api/analytics/events/query/eBAyeGv0exc.json?stage=Zj7UnCAulEk&dimension=ou:O6uvpzGd5pu&dimension=eMyVanycQSC&dimension=qrur9Dvnyt5-Yf6UHoPkdS6&dimension=tUdBD1JDxpn&dimension=sGna2pquXOO&dimension=Kswd1r4qWLh&dimension=gWxh7DiRmG7&dimension=x7PaHGvgWY2&dimension=XCMi7Wvnplm&dimension=hlPt8H4bUOQ&dimension=Thkx2BnO5Kq&dimension=Y7hKDSuqEtH&dimension=K6uUAvq500H&dimension=msodh3rEMJa&dimension=oZg33kd9taw&dimension=GieVkTxp4HH-TBxGTceyzwy&dimension=HS8QXAJtuKV&dimension=fWIAEtYVEGk&dimension=SWfdB5lX0fk&dimension=vV9UWAZohSf-OrkEzxZEH4X&startDate=2016-07-24](https://play.dhis2.org/demo/api/analytics/events/query/eBAyeGv0exc.json?stage=Zj7UnCAulEk&dimension=ou:O6uvpzGd5pu&dimension=eMyVanycQSC&dimension=qrur9Dvnyt5-Yf6UHoPkdS6&dimension=tUdBD1JDxpn&dimension=sGna2pquXOO&dimension=Kswd1r4qWLh&dimension=gWxh7DiRmG7&dimension=x7PaHGvgWY2&dimension=XCMi7Wvnplm&dimension=hlPt8H4bUOQ&dimension=Thkx2BnO5Kq&dimension=Y7hKDSuqEtH&dimension=K6uUAvq500H&dimension=msodh3rEMJa&dimension=oZg33kd9taw&dimension=GieVkTxp4HH-TBxGTceyzwy&dimension=HS8QXAJtuKV&dimension=fWIAEtYVEGk&dimension=SWfdB5lX0fk&dimension=vV9UWAZohSf-OrkEzxZEH4X&startDate=2016-07-24)**T00:00:00.000**&endDate=2016-10-24**T00:00:00.000**&pageSize=50&page=1&displayProperty=NAME



Cheers!

Alejandro


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

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

Hi!

Mmm. In our case, 2.25, it is just related to that type of period (Start/end dates’), Other Event Reports tables are well rendered in dashboards and correctly opened in Event Report module (see below)…

Regards!

Alejandro

···

On Wed, Oct 26, 2016 at 10:55 AM, Archana Chillala archanac@thoughtworks.com wrote:

Agree. We are facing the same issue as well. Event reports are being rendered as blank dashboard items, regardless of what configuration they have for periods. When we click on ‘explore’ for that dashboard item, it takes us merely to Event Reports App, but does not render the saved report.

Could you please help fix the issue.

Cheers,

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

On Mon, Oct 24, 2016 at 9:36 PM, Alejandro acasrod@gmail.com wrote:

Hi!

We have noticed (tested in https://play.dhis2.org) that any event report table that is defined with a period type ‘Start/end dates’ instead of ‘Fixed and relative periods’ is displayed ‘blank’ when added to a dashboard (see image below).

The error generated is:


{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"Start date or end date is invalid: 2016-07-24T00:00:00.000 - 2016-10-24T00:00:00.000"}


It seems to be related to date format, since removing the bold text in the original query (see below), it works!
[https://play.dhis2.org/demo/api/analytics/events/query/eBAyeGv0exc.json?stage=Zj7UnCAulEk&dimension=ou:O6uvpzGd5pu&dimension=eMyVanycQSC&dimension=qrur9Dvnyt5-Yf6UHoPkdS6&dimension=tUdBD1JDxpn&dimension=sGna2pquXOO&dimension=Kswd1r4qWLh&dimension=gWxh7DiRmG7&dimension=x7PaHGvgWY2&dimension=XCMi7Wvnplm&dimension=hlPt8H4bUOQ&dimension=Thkx2BnO5Kq&dimension=Y7hKDSuqEtH&dimension=K6uUAvq500H&dimension=msodh3rEMJa&dimension=oZg33kd9taw&dimension=GieVkTxp4HH-TBxGTceyzwy&dimension=HS8QXAJtuKV&dimension=fWIAEtYVEGk&dimension=SWfdB5lX0fk&dimension=vV9UWAZohSf-OrkEzxZEH4X&startDate=2016-07-24](https://play.dhis2.org/demo/api/analytics/events/query/eBAyeGv0exc.json?stage=Zj7UnCAulEk&dimension=ou:O6uvpzGd5pu&dimension=eMyVanycQSC&dimension=qrur9Dvnyt5-Yf6UHoPkdS6&dimension=tUdBD1JDxpn&dimension=sGna2pquXOO&dimension=Kswd1r4qWLh&dimension=gWxh7DiRmG7&dimension=x7PaHGvgWY2&dimension=XCMi7Wvnplm&dimension=hlPt8H4bUOQ&dimension=Thkx2BnO5Kq&dimension=Y7hKDSuqEtH&dimension=K6uUAvq500H&dimension=msodh3rEMJa&dimension=oZg33kd9taw&dimension=GieVkTxp4HH-TBxGTceyzwy&dimension=HS8QXAJtuKV&dimension=fWIAEtYVEGk&dimension=SWfdB5lX0fk&dimension=vV9UWAZohSf-OrkEzxZEH4X&startDate=2016-07-24)**T00:00:00.000**&endDate=2016-10-24**T00:00:00.000**&pageSize=50&page=1&displayProperty=NAME



Cheers!

Alejandro


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

Hi there,

this should be fixed now in the latest 2.25 build. Please try again and let us know.

best regards,

Lars

···

On Mon, Oct 31, 2016 at 11:22 AM, Alejandro acasrod@gmail.com wrote:

Hi!

Mmm. In our case, 2.25, it is just related to that type of period (Start/end dates’), Other Event Reports tables are well rendered in dashboards and correctly opened in Event Report module (see below)…

Regards!

Alejandro


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 Wed, Oct 26, 2016 at 10:55 AM, Archana Chillala archanac@thoughtworks.com wrote:

Agree. We are facing the same issue as well. Event reports are being rendered as blank dashboard items, regardless of what configuration they have for periods. When we click on ‘explore’ for that dashboard item, it takes us merely to Event Reports App, but does not render the saved report.

Could you please help fix the issue.

Cheers,

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

On Mon, Oct 24, 2016 at 9:36 PM, Alejandro acasrod@gmail.com wrote:

Hi!

We have noticed (tested in https://play.dhis2.org) that any event report table that is defined with a period type ‘Start/end dates’ instead of ‘Fixed and relative periods’ is displayed ‘blank’ when added to a dashboard (see image below).

The error generated is:


{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"Start date or end date is invalid: 2016-07-24T00:00:00.000 - 2016-10-24T00:00:00.000"}


It seems to be related to date format, since removing the bold text in the original query (see below), it works!
[https://play.dhis2.org/demo/api/analytics/events/query/eBAyeGv0exc.json?stage=Zj7UnCAulEk&dimension=ou:O6uvpzGd5pu&dimension=eMyVanycQSC&dimension=qrur9Dvnyt5-Yf6UHoPkdS6&dimension=tUdBD1JDxpn&dimension=sGna2pquXOO&dimension=Kswd1r4qWLh&dimension=gWxh7DiRmG7&dimension=x7PaHGvgWY2&dimension=XCMi7Wvnplm&dimension=hlPt8H4bUOQ&dimension=Thkx2BnO5Kq&dimension=Y7hKDSuqEtH&dimension=K6uUAvq500H&dimension=msodh3rEMJa&dimension=oZg33kd9taw&dimension=GieVkTxp4HH-TBxGTceyzwy&dimension=HS8QXAJtuKV&dimension=fWIAEtYVEGk&dimension=SWfdB5lX0fk&dimension=vV9UWAZohSf-OrkEzxZEH4X&startDate=2016-07-24](https://play.dhis2.org/demo/api/analytics/events/query/eBAyeGv0exc.json?stage=Zj7UnCAulEk&dimension=ou:O6uvpzGd5pu&dimension=eMyVanycQSC&dimension=qrur9Dvnyt5-Yf6UHoPkdS6&dimension=tUdBD1JDxpn&dimension=sGna2pquXOO&dimension=Kswd1r4qWLh&dimension=gWxh7DiRmG7&dimension=x7PaHGvgWY2&dimension=XCMi7Wvnplm&dimension=hlPt8H4bUOQ&dimension=Thkx2BnO5Kq&dimension=Y7hKDSuqEtH&dimension=K6uUAvq500H&dimension=msodh3rEMJa&dimension=oZg33kd9taw&dimension=GieVkTxp4HH-TBxGTceyzwy&dimension=HS8QXAJtuKV&dimension=fWIAEtYVEGk&dimension=SWfdB5lX0fk&dimension=vV9UWAZohSf-OrkEzxZEH4X&startDate=2016-07-24)**T00:00:00.000**&endDate=2016-10-24**T00:00:00.000**&pageSize=50&page=1&displayProperty=NAME



Cheers!

Alejandro


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Thank you, Lars. It works!

···

On Wed, Nov 2, 2016 at 6:08 PM, Lars Helge Øverland lars@dhis2.org wrote:

Hi there,

this should be fixed now in the latest 2.25 build. Please try again and let us know.

best regards,

Lars

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

On Mon, Oct 31, 2016 at 11:22 AM, Alejandro acasrod@gmail.com wrote:

Hi!

Mmm. In our case, 2.25, it is just related to that type of period (Start/end dates’), Other Event Reports tables are well rendered in dashboards and correctly opened in Event Report module (see below)…

Regards!

Alejandro


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Wed, Oct 26, 2016 at 10:55 AM, Archana Chillala archanac@thoughtworks.com wrote:

Agree. We are facing the same issue as well. Event reports are being rendered as blank dashboard items, regardless of what configuration they have for periods. When we click on ‘explore’ for that dashboard item, it takes us merely to Event Reports App, but does not render the saved report.

Could you please help fix the issue.

Cheers,

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

On Mon, Oct 24, 2016 at 9:36 PM, Alejandro acasrod@gmail.com wrote:

Hi!

We have noticed (tested in https://play.dhis2.org) that any event report table that is defined with a period type ‘Start/end dates’ instead of ‘Fixed and relative periods’ is displayed ‘blank’ when added to a dashboard (see image below).

The error generated is:


{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"Start date or end date is invalid: 2016-07-24T00:00:00.000 - 2016-10-24T00:00:00.000"}


It seems to be related to date format, since removing the bold text in the original query (see below), it works!
[https://play.dhis2.org/demo/api/analytics/events/query/eBAyeGv0exc.json?stage=Zj7UnCAulEk&dimension=ou:O6uvpzGd5pu&dimension=eMyVanycQSC&dimension=qrur9Dvnyt5-Yf6UHoPkdS6&dimension=tUdBD1JDxpn&dimension=sGna2pquXOO&dimension=Kswd1r4qWLh&dimension=gWxh7DiRmG7&dimension=x7PaHGvgWY2&dimension=XCMi7Wvnplm&dimension=hlPt8H4bUOQ&dimension=Thkx2BnO5Kq&dimension=Y7hKDSuqEtH&dimension=K6uUAvq500H&dimension=msodh3rEMJa&dimension=oZg33kd9taw&dimension=GieVkTxp4HH-TBxGTceyzwy&dimension=HS8QXAJtuKV&dimension=fWIAEtYVEGk&dimension=SWfdB5lX0fk&dimension=vV9UWAZohSf-OrkEzxZEH4X&startDate=2016-07-24](https://play.dhis2.org/demo/api/analytics/events/query/eBAyeGv0exc.json?stage=Zj7UnCAulEk&dimension=ou:O6uvpzGd5pu&dimension=eMyVanycQSC&dimension=qrur9Dvnyt5-Yf6UHoPkdS6&dimension=tUdBD1JDxpn&dimension=sGna2pquXOO&dimension=Kswd1r4qWLh&dimension=gWxh7DiRmG7&dimension=x7PaHGvgWY2&dimension=XCMi7Wvnplm&dimension=hlPt8H4bUOQ&dimension=Thkx2BnO5Kq&dimension=Y7hKDSuqEtH&dimension=K6uUAvq500H&dimension=msodh3rEMJa&dimension=oZg33kd9taw&dimension=GieVkTxp4HH-TBxGTceyzwy&dimension=HS8QXAJtuKV&dimension=fWIAEtYVEGk&dimension=SWfdB5lX0fk&dimension=vV9UWAZohSf-OrkEzxZEH4X&startDate=2016-07-24)**T00:00:00.000**&endDate=2016-10-24**T00:00:00.000**&pageSize=50&page=1&displayProperty=NAME



Cheers!

Alejandro


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