Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-7428

Workflow Integrity Check needs an additional check

XMLWordPrintable

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      You need to account for the case where the jiraissue.issuestatus is null.

      We had quite a large number of these - and in all cases, the worflow status was ok - so it was just a matter of updating jiraissue with the value from OS_WFENTRY

      REPORT:

      SELECT     jiraissue.pkey, OS_WFENTRY.STATE, jiraissue.issuestatus
FROM         jiraissue INNER JOIN
                      OS_WFENTRY ON jiraissue.WORKFLOW_ID = OS_WFENTRY.ID
WHERE     (jiraissue.issuestatus IS NULL)
ORDER BY jiraissue.pkey;

      FIX:

      update jiraissue
set    issuestatus = ( select state 
                       from   os_wfentry
                       where  id = workflow_id )
where  issuestatus is null;

      And pls make it efficient (no N+1 database calls...) - the other integrity checks are quite slow because of inefficient database access...

            [JRASERVER-7428] Workflow Integrity Check needs an additional check

            Conny Postma made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 77367 ]
            Olga Springer made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 746726 ]
            Antoni Kowalski made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 746493 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3052041 ] New: JAC Suggestion Workflow 3 [ 3678440 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2614831 ] New: JAC Suggestion Workflow [ 3052041 ]
            Rachel Lin (Inactive) made changes -
            Workflow Original: JIRA PM Feature Request Workflow v2 - TEMP [ 2579431 ] New: Confluence Workflow - Public Facing v4 [ 2614831 ]
            Status Original: Closed [ 6 ] New: Resolved [ 5 ]
            Ignat (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - TEMP [ 2358304 ] New: JIRA PM Feature Request Workflow v2 - TEMP [ 2579431 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 2125700 ] New: JIRA Bug Workflow w Kanban v6 - TEMP [ 2358304 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - TEMP [ 2088185 ] New: JIRA Bug Workflow w Kanban v6 [ 2125700 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 889362 ] New: JIRA Bug Workflow w Kanban v6 - TEMP [ 2088185 ]

              dylan@atlassian.com Dylan Etkin [Atlassian]
              3b1ae0ec93c9 Nick Minutello
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: