Sprint with id does not exist or you do not have permission to view it.

Question

As a project administrator when we run the following query "project = PHRECORD AND status != Closed AND status != Verified AND Sprint != EMPTY AND Verifier = EMPTY AND sprint not in (733, 1263) and sprint not in (futureSprints()) order by key" we get error Sprint with id 1281 does not exist or you do not have permission to view it. When the same query is ran by a Jira Administrator it returns 3 values.  We get the same error if we search for sprint = 1281 with the project administrator but the jira administrator returns 0 results.  How can we find the offending sprint or is there something we can do to resolve the issue?

Hazel Elgart · Answer

We are having the same problem when we do a query using "futureSprints()". User gets an error on a sprint she shouldn't be able to see anyway. As an admin, I've checked all permissions I can find associated with that sprint/project/filter/board and can find no problems. To explain why she is getting this error.

Christian Czaia [Decadis AG] · Answer

You could look at the DB to identify the sprint:

select * from AO_60DB71_SPRINT WHERE ID = 1281

After that you should find out which project / board is using that sprint. Probably a project where you don't have any viewing permission.