DHIS-2 2.15 bug on reporting rate dataset selector in pivot table and visualiser

Not sure if anyone else has seen this issue, but the list of datasets displayed when selecting reporting rates is not complete. I’ve cleared cache and checked the completeness table for the period in question and all of the datasets are in the analytics table. I wonder if the SQL statement used to fill the combo box has a “limit” statement.

···


Randy Wilson

Senior HMIS and Data Use Advisor, Ministry of Health/Rwanda

Integrated Health Systems Strengthening Project

Management Sciences for Health, Inc. (MSH)

BP 371

Kigali, Rwanda

+250-788308835

Skype Name (wilsonrandy_us)

www.msh.org

Stronger health systems. Greater health impact.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

Hi Randy,

thanks for reporting this. Seems it was never backported to 2.15.

I have added “infinite scrolling” and filtering for data sets in PT and DV now.

Jan

···

On Thu, Aug 7, 2014 at 10:04 AM, Wilson, Randy rwilson@msh.org wrote:

Not sure if anyone else has seen this issue, but the list of datasets displayed when selecting reporting rates is not complete. I’ve cleared cache and checked the completeness table for the period in question and all of the datasets are in the analytics table. I wonder if the SQL statement used to fill the combo box has a “limit” statement.


Randy Wilson

Senior HMIS and Data Use Advisor, Ministry of Health/Rwanda

Integrated Health Systems Strengthening Project

Management Sciences for Health, Inc. (MSH)

BP 371

Kigali, Rwanda

+250-788308835

Skype Name (wilsonrandy_us)

www.msh.org

Stronger health systems. Greater health impact.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Dear all i have created the approval level in settings,and have selected facilities as aproval level in settings and when i try to delete it cause i whant to change the level of approval,i get this message:

Object not deleted because it is associated by objects of type DataApproval

but when i also try to create another one like Province i can delete it no problem.does it need to delete it in Back end?
Did any one met this issue?

Regards.

···

Le Jeudi 7 août 2014 10h05, “Wilson, Randy” rwilson@msh.org a écrit :

Not sure if anyone else has seen this issue, but the list of datasets displayed when selecting reporting rates is not complete. I’ve cleared cache and checked the completeness table for the period in question and all of the datasets are in the analytics table. I wonder if the SQL statement used to fill the combo box has a “limit” statement.


Randy Wilson

Senior HMIS and
Data Use Advisor, Ministry of Health/Rwanda

Integrated
Health Systems Strengthening Project

Management
Sciences for Health, Inc. (MSH)

BP 371

Kigali, Rwanda

+250-788308835

Skype Name
(wilsonrandy_us)

www.msh.org

Stronger health systems. Greater health impact.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Thank you Jim GRACE this worked fine.

Dear Nsanzumuhire Venuste,

The message means that some data has already been approved at this level. If you can locate the data that was approved in the approval report, you can remove the approval record by clicking on “Unapprove”. If all data that has been approved at this level is unapproved, then you should be able to remove the approval level.

If you want to remove all data approvals through the back end, you can do:

delete from dataapproval;

Then you can delete any approval level.

If you only want to delete the data approvals for one level, you can look through the approval levels with:

select * from dataapprovallevel;

Note that dataapprovallevelid value for the approval level you want to delete. Then delete the approvals for that level with:

delete from dataapproval where dataapprovallevelid = nnnn;

Then you can delete that approval level.

Cheers,

Jim Grace

···

Le Lundi 11 août 2014 19h35, Jim Grace jimgrace@gmail.com a écrit :

On Mon, Aug 11, 2014 at 1:03 PM, nsanzumuhire venuste vensanze@yahoo.fr wrote:

Dear all i have created the approval level in settings,and have selected facilities as aproval level in settings and when i try to delete it cause i whant to change the level of approval,i get this message:

Object not deleted because it is associated by objects of type DataApproval

but when i also try to create another one like Province i can delete it no problem.does it need to delete it in Back end?
Did any one met this issue?

Regards.

Le Jeudi 7 août 2014 10h05, “Wilson, Randy” rwilson@msh.org a écrit :

Not sure if anyone else has seen this issue, but the list of datasets displayed when selecting reporting rates is not complete. I’ve cleared cache and checked the completeness table for the period in question and all of the datasets are in the analytics table. I
wonder if the SQL statement used to fill the combo box has a “limit” statement.


Randy Wilson

Senior HMIS and
Data Use Advisor, Ministry of Health/Rwanda

Integrated
Health Systems Strengthening Project

Management
Sciences for Health, Inc. (MSH)

BP 371

Kigali, Rwanda

+250-788308835

Skype Name
(wilsonrandy_us)

www.msh.org

Stronger health systems. Greater health impact.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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


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

Hi Anthony,

please check if there is a message in the console. In Chrome, press Ctrl + Shift + j and reload the page.

···

On Sat, Aug 16, 2014 at 2:02 PM, Anthony Danso adanso31@gmail.com wrote:

On Aug 16, 2014, at 12:01 PM, Anthony Danso anthonydanso47@yahoo.com wrote:

i update our instance from 2.13 to 2.15. First of all, 2.13 => 2.14 => 2.15 with a script run before each update.After there upgrade was successful ,Data Visualizer and Pivot Table Modules are not loading.i receive a blank page when i select these two modules.
On Aug 7, 2014, at 10:23 AM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Hi Randy,

thanks for reporting this. Seems it was never backported to 2.15.

I have added “infinite scrolling” and filtering for data sets in PT and DV now.

Jan


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, Aug 7, 2014 at 10:04 AM, Wilson, Randy rwilson@msh.org wrote:

Not sure if anyone else has seen this issue, but the list of datasets displayed when selecting reporting rates is not complete. I’ve cleared cache and checked the completeness table for the period in question and all of the datasets are in the analytics table. I wonder if the SQL statement used to fill the combo box has a “limit” statement.


Randy Wilson

Senior HMIS and Data Use Advisor, Ministry of Health/Rwanda

Integrated Health Systems Strengthening Project

Management Sciences for Health, Inc. (MSH)

BP 371

Kigali, Rwanda

+250-788308835

Skype Name (wilsonrandy_us)

www.msh.org

Stronger health systems. Greater health impact.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Ok, this is likely caused by the browser cache. Please clear the cache completely and try again.

(Press Ctrl + Shift + Delete and follow the instructions.)

···

On Sat, Aug 16, 2014 at 2:07 PM, Anthony Danso adanso31@gmail.com wrote:

This message was displayed the console >Failed to load resource: the server responded with a status of 404 (Not Found) https://www.ghsdhims.org/dhims/dhis-web-visualizer/initialize.action?_dc=1408190637701

Hi Anthony,

please check if there is a message in the console. In Chrome, press Ctrl + Shift + j and reload the page.

On Sat, Aug 16, 2014 at 2:02 PM, Anthony Danso adanso31@gmail.com wrote:

On Aug 16, 2014, at 12:01 PM, Anthony Danso anthonydanso47@yahoo.com wrote:

i update our instance from 2.13 to 2.15. First of all, 2.13 => 2.14 => 2.15 with a script run before each update.After there upgrade was successful ,Data Visualizer and Pivot Table Modules are not loading.i receive a blank page when i select these two modules.
On Aug 7, 2014, at 10:23 AM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Hi Randy,

thanks for reporting this. Seems it was never backported to 2.15.

I have added “infinite scrolling” and filtering for data sets in PT and DV now.

Jan


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, Aug 7, 2014 at 10:04 AM, Wilson, Randy rwilson@msh.org wrote:

Not sure if anyone else has seen this issue, but the list of datasets displayed when selecting reporting rates is not complete. I’ve cleared cache and checked the completeness table for the period in question and all of the datasets are in the analytics table. I wonder if the SQL statement used to fill the combo box has a “limit” statement.


Randy Wilson

Senior HMIS and Data Use Advisor, Ministry of Health/Rwanda

Integrated Health Systems Strengthening Project

Management Sciences for Health, Inc. (MSH)

BP 371

Kigali, Rwanda

+250-788308835

Skype Name (wilsonrandy_us)

www.msh.org

Stronger health systems. Greater health impact.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

Hm, I can see that you are running 2.15, but the PT and DV code is actually version 2.13… Will investigate a bit more.

···

On Sat, Aug 16, 2014 at 2:16 PM, Anthony Danso adanso31@gmail.com wrote:

I have Cleared the Browser cache completely but its still displaying same page as blank.
On Aug 16, 2014, at 12:10 PM, Anthony Danso adanso31@gmail.com wrote:

After the reload >

  1. GET https://www.ghsdhims.org/dhims/dhis-web-visualizer/initialize.action?_dc=1408190994224 404 (Not Found) ext-all.js:15
  2. Ext.define.requestext-all.js:15
  1. (anonymous function)app.js:4838
  1. (anonymous function)app.js:4852
  1. (anonymous function)ext-all.js:15
  1. bext-all.js:15

On Aug 16, 2014, at 12:07 PM, Anthony Danso adanso31@gmail.com wrote:

This message was displayed the console >Failed to load resource: the server responded with a status of 404 (Not Found) https://www.ghsdhims.org/dhims/dhis-web-visualizer/initialize.action?_dc=1408190637701

Hi Anthony,

please check if there is a message in the console. In Chrome, press Ctrl + Shift + j and reload the page.

On Sat, Aug 16, 2014 at 2:02 PM, Anthony Danso adanso31@gmail.com wrote:

On Aug 16, 2014, at 12:01 PM, Anthony Danso anthonydanso47@yahoo.com wrote:

i update our instance from 2.13 to 2.15. First of all, 2.13 => 2.14 => 2.15 with a script run before each update.After there upgrade was successful ,Data Visualizer and Pivot Table Modules are not loading.i receive a blank page when i select these two modules.
On Aug 7, 2014, at 10:23 AM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Hi Randy,

thanks for reporting this. Seems it was never backported to 2.15.

I have added “infinite scrolling” and filtering for data sets in PT and DV now.

Jan


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, Aug 7, 2014 at 10:04 AM, Wilson, Randy rwilson@msh.org wrote:

Not sure if anyone else has seen this issue, but the list of datasets displayed when selecting reporting rates is not complete. I’ve cleared cache and checked the completeness table for the period in question and all of the datasets are in the analytics table. I wonder if the SQL statement used to fill the combo box has a “limit” statement.


Randy Wilson

Senior HMIS and Data Use Advisor, Ministry of Health/Rwanda

Integrated Health Systems Strengthening Project

Management Sciences for Health, Inc. (MSH)

BP 371

Kigali, Rwanda

+250-788308835

Skype Name (wilsonrandy_us)

www.msh.org

Stronger health systems. Greater health impact.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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

I just cleared the nginx cache as well but this does not seem to be the problem.

···

On 16 August 2014 13:16, Anthony Danso adanso31@gmail.com wrote:

I have Cleared the Browser cache completely but its still displaying same page as blank.
On Aug 16, 2014, at 12:10 PM, Anthony Danso adanso31@gmail.com wrote:

After the reload >

  1. GET https://www.ghsdhims.org/dhims/dhis-web-visualizer/initialize.action?_dc=1408190994224 404 (Not Found) ext-all.js:15
  2. Ext.define.requestext-all.js:15
  1. (anonymous function)app.js:4838
  1. (anonymous function)app.js:4852
  1. (anonymous function)ext-all.js:15
  1. bext-all.js:15

On Aug 16, 2014, at 12:07 PM, Anthony Danso adanso31@gmail.com wrote:

This message was displayed the console >Failed to load resource: the server responded with a status of 404 (Not Found) https://www.ghsdhims.org/dhims/dhis-web-visualizer/initialize.action?_dc=1408190637701

Hi Anthony,

please check if there is a message in the console. In Chrome, press Ctrl + Shift + j and reload the page.

On Sat, Aug 16, 2014 at 2:02 PM, Anthony Danso adanso31@gmail.com wrote:

On Aug 16, 2014, at 12:01 PM, Anthony Danso anthonydanso47@yahoo.com wrote:

i update our instance from 2.13 to 2.15. First of all, 2.13 => 2.14 => 2.15 with a script run before each update.After there upgrade was successful ,Data Visualizer and Pivot Table Modules are not loading.i receive a blank page when i select these two modules.
On Aug 7, 2014, at 10:23 AM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Hi Randy,

thanks for reporting this. Seems it was never backported to 2.15.

I have added “infinite scrolling” and filtering for data sets in PT and DV now.

Jan


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, Aug 7, 2014 at 10:04 AM, Wilson, Randy rwilson@msh.org wrote:

Not sure if anyone else has seen this issue, but the list of datasets displayed when selecting reporting rates is not complete. I’ve cleared cache and checked the completeness table for the period in question and all of the datasets are in the analytics table. I wonder if the SQL statement used to fill the combo box has a “limit” statement.


Randy Wilson

Senior HMIS and Data Use Advisor, Ministry of Health/Rwanda

Integrated Health Systems Strengthening Project

Management Sciences for Health, Inc. (MSH)

BP 371

Kigali, Rwanda

+250-788308835

Skype Name (wilsonrandy_us)

www.msh.org

Stronger health systems. Greater health impact.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


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