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

This widget could not be displayed.

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.

This widget could not be displayed.

Try bulk-editing the security level...

This widget could not be displayed.

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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

232 views 3 0
Join discussion

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