Project has issues(as seen in admin mode) in it but normal user browsing shows the project as empty?

Issue security was set on the project with 1043 issues linked to it. Thereafter the issue security scheme was deleted but now unable to view any of the issues that were logged prior to it. Checked a dump from the database and it shows security="10300" but all schemes were deleted. Any ideas on how I can remove the security tag to allow view for all users to the 1043 issue?

3 answers

1 accepted

0 votes
Accepted answer

Jira shouldn't have let you delete the scheme if you still had issues associated with it, the option just ins't there. How did you delete the schemes? Maybe there has been some DB corruption?

You could create a new security issue scheme with the right level of access, find it's ID but looking athe schemeID parameter in the edit link of the scheme. Also you need to find the project ID, again by ID param in an edit URL

Then, Shutdown Jira

Backup the DB

then run SQL to update all issues to the new security level, something like

Update jiraissue set security ='XXXX' where project = 'PROJECTID' and security='10300'

XXXX is your new Security scheme ID

Restart Jira


You should now have access again

I'm still confused about how you managed to delete it in the first place, shouldn't have been possible

Thanks for the feedback Matthew. One of the dba's restarted JIRA just as I deleted the scheme which may have caused issues with the DB. Is it possible to run a jelly without needing to stop JIRA? Or will that cause crazy issues on the database? Also, not sure what happened as when deleting a scheme it usually stated that a number of issues are linked to it and the option to select a different scheme or "none" is made available. I didn't see that option at all. Now, I deleted the scheme 10300 and created 10301. I will try your method and see if it works. Thanks for the help mate.

if you are updating the Jira database, it's ALWAYS best to shut it down first. It's the only way to be sure the data is in a consistent state.

Try bulk-editing the security level...

PS. I tried the very same with another project with 10 issues, and no issues had disappeared from the normal search function after I did the same thing.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,239 views 5 10
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you