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?
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
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.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG