dhis2-devs team mailing list archive

[Ifeanyi Okoye <ifeanyiokoye@xxxxxxxxx>]

Hello Again
DHIS 2 version 2.22Build 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. 
Warm Regards, 

Ifeanyi


Ifeanyi Okoye MB;BS, M.Inf.Sc
Strategic Information Manager,
US Department of Defense-Walter Reed Program Nigeria
Embassy of the United States of America 
Plot 1075 Diplomatic Drive Central Business District, Abuja, Nigeria