'Passed List Had More Than One Value' when click on project's permission / missing project permission
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
A Project Permission is missing from Project Overview page. Clicking on the 'Permissions' link in the Project Administration sidebar results in the following error:
java.lang.IllegalArgumentException: Passed List had more than one value.
Hide stack trace
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)
at com.atlassian.jira.plugin.webfragment.CacheableContextProviderDecorator.getContextMap(CacheableContextProviderDecorator.java:46)
at com.atlassian.plugin.web.descriptors.DefaultWebPanelModuleDescriptor$ContextAwareWebPanel.getHtml(DefaultWebPanelModuleDescriptor.java:144)
at com.atlassian.jira.projectconfig.tab.WebPanelTab.getTab(WebPanelTab.java:75)
at com.atlassian.jira.projectconfig.servlet.PanelServlet.outputTab(PanelServlet.java:163)
at com.atlassian.jira.projectconfig.servlet.PanelServlet.doGet(PanelServlet.java:136)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at com.atlassian.plugin.servlet.DelegatingPluginServlet.service(DelegatingPluginServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at com.atlassian.plugin.servlet.ServletModuleContainerServlet.service(ServletModuleContainerServlet.java:52)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:84)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.atlassian.jira.web.filters.XContentTypeOptionsNoSniffFilter.doFilter(XContentTypeOptionsNoSniffFilter.java:22)
.
.
.
.Cause
This can be caused by a duplicated permission scheme within the project configurations.
Diagnosis
Diagnostic Steps
Run the following SQL query against your database to identify duplicated permission schemes that may exist in the nodeassociation table. If the query returns any results, you have a duplicate permission scheme.
select n.sink_node_entity, p.* FROM (SELECT source_node_id, COUNT(source_node_id) FROM nodeassociation WHERE sink_node_entity='PermissionScheme' GROUP BY source_node_id HAVING (COUNT(source_node_id) > 1) ORDER by source_node_id) as A inner join nodeassociation n on n.source_node_id = A.source_node_id and n.sink_node_entity ='PermissionScheme' left outer join permissionscheme p on p.ID = n.SINK_NODE_ID;
Resolution
Delete from nodeassociation table for the duplicated entry:
If the ID's in the rows are the same, this DELETE statement will remove BOTH the original and the duplicate value. If you are in this situation, you will need to re-write the original value back into the database with an appropriate INSERT statement. Each situation is unique, so it is difficult to write an example INSERT here that makes global sense. If you need assistance addressing your particular situation, please raise a ticket at http://support.atlassian.com or ask the Atlassian community at http://answers.atlassian.com.
delete from nodeassociation where sink_node_entity='PermissionScheme' and sink_node_id = xxxx ;Replace xxx with the appropriate value from the 'ID' column of the duplicated Permission Scheme in the query in the Diagnosis section above.