Unable to manage Jira sprint

[Ron Jacob]

I am having trouble managing my team's sprints in Jira. I have double checked that I have admin permissions/manage sprint permissions for every Project involved in our board and I still get the error "You must have Manage Sprint permissions for all projects on the origin board". 

The board is based on complex query. with more than 5 projects.

[somethingblue]

Hi Shivi,

The easiest way to find out what project could be causing the issue will be to make simple queries for each project in relation to the sprint and find out which one you're unable to view, etc.  Using Manage Sprints permission for advanced cases knowledge base article has a table with a very good explanation of how to simplify your queries and test to make sure you do have the correct permissions on each project, issue, etc.

Another common problem is that SprintA doesn't really belong to BoardA. The fact that SprintA displays on BoardA doesn't mean that BoardA owns it, SprintA could be owned by BoardB. Steps to check this:

1. Find ID of SprintA, let's say it's 7, see JIRA Software: How to search for a Sprint using JQL
2. Find ID of BoardA, let's say it's 1, you can get it from URL: secure/RapidBoard.jspa?rapidView=1

3. Check mapping from AO_60DB71_SPRINT table by running SQL:

   select "ID","NAME","RAPID_VIEW_ID" from "AO_60DB71_SPRINT" where "ID"= <ID of SprintA>;

   Example:

    select "ID","NAME","RAPID_VIEW_ID" from "AO_60DB71_SPRINT" where "ID"=7;
    ID |   NAME   | RAPID_VIEW_ID
   ----+----------+---------------
     7 | Sprint 4 |             1

4. Check if RAPID_VIEW_ID matches ID_BoardA, if it doesn't then SprintA is owned by BoardB. Now you have id of BoardB. 

5. If SprintA is owned by BoardB, then repeat Steps 1 and 2 taking into account BoardB. 

Please simplify your queries and verify the Board is actually showing correctly and we'll go from there.

Cheers,

Branden

[JIra Admin]

Hi Branden

How /where to run these SQL queries. Is there any addon required ?

[somethingblue]

Hi Al,

You would need to run this against your SQL database, .e.g MSSQL, Postgres, etc and there is no add-on required.  If you're unsure of the database you're using you can find out like this:

• Log in as a user with the 'JIRA Administrators' global permission.

•  Choose >   System . Select Troubleshooting and Support > System Info to open the System Info page.

• Look for the Database type field and the Database JNDI address to connect to your database.

Cheers,

Branden