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
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
