Error 500 when opening the Permissions page

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

When going to Project > Administration > Permissions, a 500 error page appears (Passed List had more than one value)

The below may be found within the atlassian-jira.log:

2015-06-01 07:00:00,417 http-bio-443-exec-205 ERROR      [500ErrorPage.jsp] Exception caught in 500 page Passed List had more than one value.
java.lang.IllegalArgumentException: Passed List had more than one value.
	at org.ofbiz.core.entity.EntityUtil.getOnly(EntityUtil.java:62)
	at com.atlassian.jira.projectconfig.contextproviders.ProjectPermissionContextProvider.getProjectPermissionsScheme(ProjectPermissionContextProvider.java:158)
	at com.atlassian.jira.projectconfig.contextproviders.ProjectPermissionContextProvider.getContextMap(ProjectPermissionContextProvider.java:83)
	at com.atlassian.jira.plugin.webfragment.CacheableContextProviderDecorator.initContextMap(CacheableContextProviderDecorator.java:70)

Cause

There is more than one Permission Scheme associated to the project, which is causing this misbehavior.

Resolution


(warning) Keep in mind to backup your JIRA instance before proceed!

  1. Shutdown JIRA.
  2. Run the following SQL query in the JIRA database to find the duplicate Permission Scheme associated to the project:

    select p.pname, ps.name
    from project p , nodeassociation n , permissionscheme ps, n.source_node_id, n.sink_node_id
    where p.id = n.source_node_id 
    	and ps.id = n.sink_node_id 
    	and n.sink_node_entity='PermissionScheme';
    
  3. Delete one of the duplicated associations from your database, replacing SOURCE_NODE_ID and SINK_NODE_ID by the result from the query above (the duplicated entry):

    delete from nodeassociation where sink_node_entity='PermissionScheme' and source_node_id = SOURCE_NODE_ID and sink_node_id = SINK_NODE_ID;
    
  4. Restart JIRA instance.


Last modified on Mar 11, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.