Projects don't have Permission Scheme error

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: 8.20.7
    • Component/s: Data Center
    • None
    • 8.2
    • 1
    • Severity 3 - Minor
    • 0

      Issue Summary

      On Jira Software 8.20.7 DC version:
      When deleting an inactive project with an associated permission scheme, the permission scheme is detached from the project and the project is not deleted. And the Project Permission Scheme became None

      This is reproducible on Data Center: (yes)

      Steps to Reproduce

      1. Step 1
        In Admin panel, go to Projects, and filter for those whose last issue update happened, for example, 2 years ago. If issues in those projects haven't been touched for so long, they are likely to remain inactive in the future. Try to delete this project
      2. Step 2
        Check the permission scheme of the project from database
      select * from nodeassociation where source_node_entity = 'Project' and source_node_id = <ID>
           
      select * from permissionscheme where id in (select sink_node_id from nodeassociation where  source_node_id = <ID>)
      

      And check the permission scheme is changing to None

      Expected Results

      The project is deleted successfully.

      Actual Results

      Project database information is corrupt. NODEASSOCIATION table for the “PermissionScheme” entity does not exist for this project. Could have happened by the incorrect removal of a project caused by an error or broken transaction while calling the method 
      com.atlassian.jira.project.DefaultProjectManager.removeProject

      Workaround

      For workaround suggested steps in this Knowledge Base article: https://confluence.atlassian.com/jirakb/blank-page-displayed-when-loading-permission-scheme-configuration-in-jira-server-297670208.html can be followed.

        1. image-2022-09-29-11-46-26-933.png
          151 kB
          Baris Ilhan
        2. image-2022-09-29-11-46-31-861.png
          151 kB
          Baris Ilhan

            Assignee:
            Unassigned
            Reporter:
            Baris Ilhan (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: