Friday, September 16, 2011

System Administrator responsibility disappear from user menu

Hi All.


This is the first time that I see this issue.After the ATG rup 7 upgrade the System Administrator responsibility disappear from SYSADMIN user menu. It was OK until I run the required post installation step for ATG rup 7 Workflow Directory Services User/Role Validation concurrent.


Another issue when I'm stopping concurrent manager I get the following error:
Shutting down concurrent managers for PROD ...
Please enter a valid responsibility. The responsibility System Administrator does not exist or is not active. Check that the correct application short name is specified for your responsibility.

adcmctl.sh: exiting with status 1



If you also got this error , do the following:
According the Document ID 466135.1 - Responsibilities Missing After They Have Been Assigned to a User


1. Run the following script to check if there is a discrepancy between the tables:

select ura.user_name, ura.role_name 
from wf_local_user_roles ur, wf_user_role_assignments ura 
where ur.user_name = ura.user_name 
and ur.role_name = ura.role_name 
and ura.relationship_id = -1 
and ((ur.effective_start_date is null or ur.effective_start_date <> 
ura.effective_start_date) 
or (ur.effective_end_date is null or ur.effective_end_date <> ura.effective_end_date));

If the above script returns any rows then:

2. You must take a backup of the two tables :

WF_LOCAL_USER_ROLES
and
WF_USER_ROLE_ASSIGNMENTS


3. Run the following update script to correct the discrepancy :


UPDATE WF_USER_ROLE_ASSIGNMENTS set effective_end_date = to_date(null) 
where rowid in (select ura.rowid 
                from wf_local_user_roles ur, wf_user_role_assignments ura 
                where ur.user_name = ura.user_name 
                  and ur.role_name = ura.role_name 
                  and ura.relationship_id = -1 
                  and ((ur.effective_start_date is null or ur.effective_start_date <>ura.effective_start_date) 
                  or (ur.effective_end_date is null or ur.effective_end_date <>ura.effective_end_date)));


4. Run the "Workflow Directory Services User/Role Validation" concurrent program to resolve the
     issue with following parameters : 10000,Yes,Yes,Yes

5. Re-test the issue.



Good luck...

No comments:

Post a Comment