Crowd api not working in JIRA
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
Running an api against the JIRA server like this is not working :
<BASE URL>/rest/usermanagement/1/user/group/nested?username=<USERNAME>
Following error message is displayed :
1
2
3
4
5
6
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<status>
<status-code>500</status-code>
<message>offset not supported</message>
<stack-trace>java.lang.IllegalStateException: offset not supported at com.querydsl.sql.SQLServerTemplates.serialize(SQLServerTemplates.java:232) at com.querydsl.sql.SQLSerializer.serialize(SQLSerializer.java:212) at com.querydsl.sql.ProjectableSQLQuery.serialize(ProjectableSQLQuery.java:465) at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:429) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.lambda$findMemberships$6(OfBizInternalMembershipDao.java:438) at com.atlassian.jira.database.DefaultQueryDslAccessor.lambda$executeQuery$0(DefaultQueryDslAccessor.java:66) at com.atlassian.jira.database.DatabaseAccessorImpl.lambda$runInTransaction$0(DatabaseAccessorImpl.java:98) at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:67) at com.atlassian.jira.database.DatabaseAccessorImpl.runInTransaction(DatabaseAccessorImpl.java:93) at com.atlassian.jira.database.DefaultQueryDslAccessor.executeQuery(DefaultQueryDslAccessor.java:65) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.findMemberships(OfBizInternalMembershipDao.java:427) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.search(OfBizInternalMembershipDao.java:353) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizDelegatingMembershipDao.search(OfBizDelegatingMembershipDao.java:116) at com.atlassian.crowd.directory.AbstractInternalDirectory.searchGroupRelationships(AbstractInternalDirectory.java:992) at com.atlassian.crowd.manager.directory.RemoteDirectorySearcher.searchDirectGroupRelationships(RemoteDirectorySearcher.java:78) at com.atlassian.crowd.manager.directory.RemoteDirectorySearcher.findNestedGroupMembershipsOfUser(RemoteDirectorySearcher.java:341) at com.atlassian.crowd.manager.directory.RemoteDirectorySearcher.getParentDirectoryEntities(RemoteDirectorySearcher.java:235) at com.atlassian.crowd.manager.directory.RemoteDirectorySearcher.getRelatedDirectoryEntities(RemoteDirectorySearcher.java:220) at
Cause
Crowd User Directory in JIRA is not enabled.
Resolution
Make sure the Crowd User directory in JIRA is configured correctly. The Crowd REST api requires Crowd to be configured correctly and enabled on the JIRA server.
Was this helpful?