Pivot Table and Data Visualizer failing to load on DHIS2 v2.21

Hi Folks,

I have a DHIS2 v 2.21 running on an Ubuntu Trusty (14.04.3) via nginx.

I used to be able to access both the Pivot Table and the Data Visualizer apps.

Recently, these load indefinitely and checked through the Javascript console I only found a 400 (Bad Request) error message with the URLs attached here.

The problem seems to originate from a file: ext-all.js line 15

​Any pointers will be appreciated.

Thank you!​

pivot_table-cant-load.txt (887 Bytes)

···

:: Sovello Hildebrand Mgani ::

–If you teach man to fish, you’ll feed him a lifetime–

Hi there,

My guess is that you are a victim of a Tomcat upgrade. The issue is described here:

https://lists.launchpad.net/dhis2-users/msg12117.html

Basically, newer versions of Tomcat do not allow for the “|” character in URLs. So, if you have upgraded your operating system to a version which has this version of Tomcat and it does not work you have two choices.

  1. Downgrade Tomcat to a version which does work. 8.0.36 is known to work.

  2. Upgrade DHIS2 to a version which fixes this issue, which should be a later build of 2.24, 2.25 or 2.26.

···

On Thu, Feb 23, 2017 at 7:53 PM, Sovello Hildebrand Mgani sovellohpmgani@gmail.com wrote:

Hi Folks,

I have a DHIS2 v 2.21 running on an Ubuntu Trusty (14.04.3) via nginx.

I used to be able to access both the Pivot Table and the Data Visualizer apps.

Recently, these load indefinitely and checked through the Javascript console I only found a 400 (Bad Request) error message with the URLs attached here.

The problem seems to originate from a file: ext-all.js line 15

​Any pointers will be appreciated.

Thank you!​

:: Sovello Hildebrand Mgani ::

–If you teach man to fish, you’ll feed him a lifetime–


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Sovello,
Stop DHIS2 application and replace war file then start application.

···

On Feb 23, 2017 6:53 PM, “Sovello Hildebrand Mgani” sovellohpmgani@gmail.com wrote:

Hi Folks,

I have a DHIS2 v 2.21 running on an Ubuntu Trusty (14.04.3) via nginx.

I used to be able to access both the Pivot Table and the Data Visualizer apps.

Recently, these load indefinitely and checked through the Javascript console I only found a 400 (Bad Request) error message with the URLs attached here.

The problem seems to originate from a file: ext-all.js line 15

​Any pointers will be appreciated.

Thank you!​


:: Sovello Hildebrand Mgani ::

–If you teach man to fish, you’ll feed him a lifetime–


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

Thanks Knut.

I have got this working now.

I had to upgrade DHIS2 to 2.26 because those were flagged as security updates for Tomcat and our organizational policy couldn’t allow a roll-back.

I have a side question which maybe needed a separate thread, but after this upgrade I can’t run pivot tables and when I look at the log I get messages like “Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java” and was wondering how do we generate these analytics tables?

Thank you

···

2017-02-23 22:03 GMT+03:00 Knut Staring knutst@gmail.com:

Hi there,

My guess is that you are a victim of a Tomcat upgrade. The issue is described here:

https://lists.launchpad.net/dhis2-users/msg12117.html

Basically, newer versions of Tomcat do not allow for the “|” character in URLs. So, if you have upgraded your operating system to a version which has this version of Tomcat and it does not work you have two choices.

  1. Downgrade Tomcat to a version which does work. 8.0.36 is known to work.
  1. Upgrade DHIS2 to a version which fixes this issue, which should be a later build of 2.24, 2.25 or 2.26.

On Thu, Feb 23, 2017 at 7:53 PM, Sovello Hildebrand Mgani sovellohpmgani@gmail.com wrote:

Hi Folks,

I have a DHIS2 v 2.21 running on an Ubuntu Trusty (14.04.3) via nginx.

I used to be able to access both the Pivot Table and the Data Visualizer apps.

Recently, these load indefinitely and checked through the Javascript console I only found a 400 (Bad Request) error message with the URLs attached here.

The problem seems to originate from a file: ext-all.js line 15

​Any pointers will be appreciated.

Thank you!​

:: Sovello Hildebrand Mgani ::

–If you teach man to fish, you’ll feed him a lifetime–


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

:: Sovello Hildebrand Mgani ::

–If you teach man to fish, you’ll feed him a lifetime–

Dear Knut

I have similar problem. But I am using DHIS2.22 and tomcat version is 8.0.30.

What is the reason?

Regards

Hannan

···

On Fri, Feb 24, 2017 at 1:03 AM, Knut Staring knutst@gmail.com wrote:

Hi there,

My guess is that you are a victim of a Tomcat upgrade. The issue is described here:

https://lists.launchpad.net/dhis2-users/msg12117.html

Basically, newer versions of Tomcat do not allow for the “|” character in URLs. So, if you have upgraded your operating system to a version which has this version of Tomcat and it does not work you have two choices.

  1. Downgrade Tomcat to a version which does work. 8.0.36 is known to work.
  1. Upgrade DHIS2 to a version which fixes this issue, which should be a later build of 2.24, 2.25 or 2.26.

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

On Thu, Feb 23, 2017 at 7:53 PM, Sovello Hildebrand Mgani sovellohpmgani@gmail.com wrote:

Hi Folks,

I have a DHIS2 v 2.21 running on an Ubuntu Trusty (14.04.3) via nginx.

I used to be able to access both the Pivot Table and the Data Visualizer apps.

Recently, these load indefinitely and checked through the Javascript console I only found a 400 (Bad Request) error message with the URLs attached here.

The problem seems to originate from a file: ext-all.js line 15

​Any pointers will be appreciated.

Thank you!​

:: Sovello Hildebrand Mgani ::

–If you teach man to fish, you’ll feed him a lifetime–


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Muhammad Abdul Hannan Khan

DHIS2 Country coordinator & Secretary

HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118

F +88 02 8813 875

M+88 01819 239 241

M+88 01534 312 066

E hannank@gmail.com

S hannan.khan.dhaka

B hannan-tech.blogspot.com

L https://bd.linkedin.com/in/hannankhan

Hi Hannan,
I think you need to upgrade to 2.23. I tried upgrading tomcat and it didn’t work because 2.22 does support that feature (I in URLs). Then so you either downgrade tomcat (something I wouldn’t recommend) or upgrade dhis 2 to 2.23 at least and you’ll be sorted.

Cheers

···

On Feb 27, 2017 20:16, “Hannan Khan” hannank@gmail.com wrote:

Dear Knut

I have similar problem. But I am using DHIS2.22 and tomcat version is 8.0.30.

What is the reason?

Regards

Hannan

On Fri, Feb 24, 2017 at 1:03 AM, Knut Staring knutst@gmail.com wrote:

Hi there,

My guess is that you are a victim of a Tomcat upgrade. The issue is described here:

https://lists.launchpad.net/dhis2-users/msg12117.html

Basically, newer versions of Tomcat do not allow for the “|” character in URLs. So, if you have upgraded your operating system to a version which has this version of Tomcat and it does not work you have two choices.

  1. Downgrade Tomcat to a version which does work. 8.0.36 is known to work.
  1. Upgrade DHIS2 to a version which fixes this issue, which should be a later build of 2.24, 2.25 or 2.26.

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


Muhammad Abdul Hannan Khan

DHIS2 Country coordinator & Secretary

HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118

F +88 02 8813 875

M+88 01819 239 241

M+88 01534 312 066

E hannank@gmail.com

S hannan.khan.dhaka

B hannan-tech.blogspot.com

L https://bd.linkedin.com/in/hannankhan

On Thu, Feb 23, 2017 at 7:53 PM, Sovello Hildebrand Mgani sovellohpmgani@gmail.com wrote:

Hi Folks,

I have a DHIS2 v 2.21 running on an Ubuntu Trusty (14.04.3) via nginx.

I used to be able to access both the Pivot Table and the Data Visualizer apps.

Recently, these load indefinitely and checked through the Javascript console I only found a 400 (Bad Request) error message with the URLs attached here.

The problem seems to originate from a file: ext-all.js line 15

​Any pointers will be appreciated.

Thank you!​

:: Sovello Hildebrand Mgani ::

–If you teach man to fish, you’ll feed him a lifetime–


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Hi Hannan,

The reason is that DHIS2 was using a character which is not strictly allowed in URLs, namely “|”. Tomcat used to accept this even though it is not standard, but in more recent versions, Tomcat has become much stricter, and only accept a small set of characters. Therefore, this has also been fixed in DHIS2, but only in more recent versions (from 2.24, I think).

Knut

···

On Feb 27, 2017 18:16, “Hannan Khan” hannank@gmail.com wrote:

Dear Knut

I have similar problem. But I am using DHIS2.22 and tomcat version is 8.0.30.

What is the reason?

Regards

Hannan

On Fri, Feb 24, 2017 at 1:03 AM, Knut Staring knutst@gmail.com wrote:

Hi there,

My guess is that you are a victim of a Tomcat upgrade. The issue is described here:

https://lists.launchpad.net/dhis2-users/msg12117.html

Basically, newer versions of Tomcat do not allow for the “|” character in URLs. So, if you have upgraded your operating system to a version which has this version of Tomcat and it does not work you have two choices.

  1. Downgrade Tomcat to a version which does work. 8.0.36 is known to work.
  1. Upgrade DHIS2 to a version which fixes this issue, which should be a later build of 2.24, 2.25 or 2.26.

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


Muhammad Abdul Hannan Khan

DHIS2 Country coordinator & Secretary

HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118

F +88 02 8813 875

M+88 01819 239 241

M+88 01534 312 066

E hannank@gmail.com

S hannan.khan.dhaka

B hannan-tech.blogspot.com

L https://bd.linkedin.com/in/hannankhan

On Thu, Feb 23, 2017 at 7:53 PM, Sovello Hildebrand Mgani sovellohpmgani@gmail.com wrote:

Hi Folks,

I have a DHIS2 v 2.21 running on an Ubuntu Trusty (14.04.3) via nginx.

I used to be able to access both the Pivot Table and the Data Visualizer apps.

Recently, these load indefinitely and checked through the Javascript console I only found a 400 (Bad Request) error message with the URLs attached here.

The problem seems to originate from a file: ext-all.js line 15

​Any pointers will be appreciated.

Thank you!​

:: Sovello Hildebrand Mgani ::

–If you teach man to fish, you’ll feed him a lifetime–


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Hello Sovello,

Analytics tables are generated by running analytics through reports module.

At times analytics may fails mid process due to some errors with resource tables or any other reason, be sure to run maintenance under Apps > Data administration > Maintenance. check the relevant options and execute.

Cheers.

···

On 27 Feb 2017 19:57, “Sovello Hildebrand Mgani” sovellohpmgani@gmail.com wrote:

Thanks Knut.

I have got this working now.

I had to upgrade DHIS2 to 2.26 because those were flagged as security updates for Tomcat and our organizational policy couldn’t allow a roll-back.

I have a side question which maybe needed a separate thread, but after this upgrade I can’t run pivot tables and when I look at the log I get messages like “Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java” and was wondering how do we generate these analytics tables?

Thank you


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

2017-02-23 22:03 GMT+03:00 Knut Staring knutst@gmail.com:

Hi there,

My guess is that you are a victim of a Tomcat upgrade. The issue is described here:

https://lists.launchpad.net/dhis2-users/msg12117.html

Basically, newer versions of Tomcat do not allow for the “|” character in URLs. So, if you have upgraded your operating system to a version which has this version of Tomcat and it does not work you have two choices.

  1. Downgrade Tomcat to a version which does work. 8.0.36 is known to work.
  1. Upgrade DHIS2 to a version which fixes this issue, which should be a later build of 2.24, 2.25 or 2.26.


:: Sovello Hildebrand Mgani ::

–If you teach man to fish, you’ll feed him a lifetime–

On Thu, Feb 23, 2017 at 7:53 PM, Sovello Hildebrand Mgani sovellohpmgani@gmail.com wrote:

Hi Folks,

I have a DHIS2 v 2.21 running on an Ubuntu Trusty (14.04.3) via nginx.

I used to be able to access both the Pivot Table and the Data Visualizer apps.

Recently, these load indefinitely and checked through the Javascript console I only found a 400 (Bad Request) error message with the URLs attached here.

The problem seems to originate from a file: ext-all.js line 15

​Any pointers will be appreciated.

Thank you!​

:: Sovello Hildebrand Mgani ::

–If you teach man to fish, you’ll feed him a lifetime–


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org