Crowd api not working in JIRA

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

 

 

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 :

<?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.

 

Last modified on Jan 13, 2017

Was this helpful?

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