Unable to access JIRA Administration section
Symptoms
All users are unable to access the administration section of JIRA. When they try to do so, they are met with a 500 error page.
The following appears in the atlassian-jira.log:
Caused by: com.atlassian.cache.CacheException: com.atlassian.jira.util.dbc.Assertions$NullArgumentException: value should not be null!
at com.atlassian.cache.memory.DelegatingCache$DelegatingLoadingCache.get(DelegatingCache.java:270)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.getChildrenOfGroupFromCache(OfBizInternalMembershipDao.java:354)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.searchCache(OfBizInternalMembershipDao.java:310)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.search(OfBizInternalMembershipDao.java:256)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizDelegatingMembershipDao.search(OfBizDelegatingMembershipDao.java:135)
at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.searchDirectGroupRelationships(DirectoryManagerGeneric.java:868)
at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.searchNestedGroupRelationships(DirectoryManagerGeneric.java:1048)
at com.atlassian.crowd.manager.application.ApplicationServiceGeneric.doNestedDirectoryMembershipQuery(ApplicationServiceGeneric.java:2116)
at com.atlassian.crowd.manager.application.ApplicationServiceGeneric.searchNestedGroupRelationships(ApplicationServiceGeneric.java:1577)
Diagnosis
To determine if the situation that you are facing is the same as the one described here, check the cwd_membership table for any NULL values.
Cause
There are some NULL values in the cwd_membership table (in my case, in the lower_child_name column of the table).
Resolution
Update the table, and fill in the NULL value accordingly.
Always create backup before updating the database.
Last modified on Nov 16, 2018
Powered by Confluence and Scroll Viewport.