Crowd api not working in JIRA
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
問題
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
原因
Crowd User Directory in JIRA is not enabled.
ソリューション
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.