dhis2-devs team mailing list archive

[Ifeanyi Okoye <1596275@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Hello Again

DHIS 2 version 2.22
Build 22057


I created 2 category option groups/groupsets to use for data approvals and assigned users to either one or both groups. The approvals did not work as envisaged probably because I may not have set them up correctly. So I deleted the approval levels and the workflow but did not remove the users from the approval levels and also removed the approval workflow from the datasets as well.

For some inexplicable reason all the analytics on that system are not
working also (have reported this on the mailing list already and
awaiting feedback).

The catalina logs show this:

and "uidlevel1" in ('C983g0J6p9m') and ( "sASLYFgAkiG" in ('CW20DvNk041') ) and ( "LKC6LlcxjzT" in ('jj2GfLHSgGP') ) group by "dx","co","monthly","uidlevel1"]; nested exception is org.postgresql.util.PSQLException: ERROR: column "sASLYFgAkiG" does not exist
  Position: 1213

Checked the reference from the API
<identifiableObject xmlns="http://dhis2.org/schema/dxf/2.0"; created="2016-06-15T09:39:32.539+0000" lastUpdated="2016-06-18T10:47:00.363+0000" name="WRP-N" href="http://../api/categoryOptionGroupSets/sASLYFgAkiG"; id="sASLYFgAkiG">
<displayName>WRP-N</displayName>
<publicAccess>rw------</publicAccess>
<externalAccess>false</externalAccess>
<user id="eLLQLkoS0hq"/>
<userGroupAccesses/>
<attributeValues/>
</identifiableObject>


I exported all the metadata and entered data from the server to a local instance on my computer (v2.22 Build 22075). I was trying to run a dataset report for different periods on my laptop instance and one of the reports did not run. I reviewed the logs (on my laptop) to see whats was going on and found this:

* INFO  2016-06-26 07:33:25,499 Create table SQL: create table
_categoryoptiongroupsetstructure_temp (categoryoptioncomboid integer not
null, "WRP-N" varchar(230), "sASLYFgAkiG" character(11), "MODHIP"
varchar(230), "LKC6LlcxjzT" character(11), primary key
(categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-2])


I then tried to remove the selected dimension restrictions for data
analytics for each user on the server but when I remove it and save, and
open the user details again to check, the dimension restriction is still
applied. I have tried this several times for different users but not
working.

The user metadata import failed for the instance on my laptop, so I do
not have the users with the restrictions and analytics are running well
except for the time period October 2015 (dataset reports and pivot
tables) - not sure why.


How do I resolve this issue? Is this a bug?

Would gladly provide any more required information.

** Affects: dhis2
     Importance: Undecided
         Status: New


** Tags: analytics approvals reports restriction users

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1596275

Title:
  Remove selected dimension restrictions for data analytics from user

Status in DHIS:
  New

Bug description:
  Hello Again

  DHIS 2 version 2.22
  Build 22057

  
  I created 2 category option groups/groupsets to use for data approvals and assigned users to either one or both groups. The approvals did not work as envisaged probably because I may not have set them up correctly. So I deleted the approval levels and the workflow but did not remove the users from the approval levels and also removed the approval workflow from the datasets as well.

  For some inexplicable reason all the analytics on that system are not
  working also (have reported this on the mailing list already and
  awaiting feedback).

  The catalina logs show this:

  and "uidlevel1" in ('C983g0J6p9m') and ( "sASLYFgAkiG" in ('CW20DvNk041') ) and ( "LKC6LlcxjzT" in ('jj2GfLHSgGP') ) group by "dx","co","monthly","uidlevel1"]; nested exception is org.postgresql.util.PSQLException: ERROR: column "sASLYFgAkiG" does not exist
    Position: 1213

  Checked the reference from the API
  <identifiableObject xmlns="http://dhis2.org/schema/dxf/2.0"; created="2016-06-15T09:39:32.539+0000" lastUpdated="2016-06-18T10:47:00.363+0000" name="WRP-N" href="http://../api/categoryOptionGroupSets/sASLYFgAkiG"; id="sASLYFgAkiG">
  <displayName>WRP-N</displayName>
  <publicAccess>rw------</publicAccess>
  <externalAccess>false</externalAccess>
  <user id="eLLQLkoS0hq"/>
  <userGroupAccesses/>
  <attributeValues/>
  </identifiableObject>

  
  I exported all the metadata and entered data from the server to a local instance on my computer (v2.22 Build 22075). I was trying to run a dataset report for different periods on my laptop instance and one of the reports did not run. I reviewed the logs (on my laptop) to see whats was going on and found this:

  * INFO  2016-06-26 07:33:25,499 Create table SQL: create table
  _categoryoptiongroupsetstructure_temp (categoryoptioncomboid integer
  not null, "WRP-N" varchar(230), "sASLYFgAkiG" character(11), "MODHIP"
  varchar(230), "LKC6LlcxjzT" character(11), primary key
  (categoryoptioncomboid)) (JdbcResourceTableStore.java
  [taskScheduler-2])


  I then tried to remove the selected dimension restrictions for data
  analytics for each user on the server but when I remove it and save,
  and open the user details again to check, the dimension restriction is
  still applied. I have tried this several times for different users but
  not working.

  The user metadata import failed for the instance on my laptop, so I do
  not have the users with the restrictions and analytics are running
  well except for the time period October 2015 (dataset reports and
  pivot tables) - not sure why.

  
  How do I resolve this issue? Is this a bug?

  Would gladly provide any more required information.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1596275/+subscriptions