JIRA: Check JIRA issues with null status

So you see errors like: "java.lang.RuntimeException: Could not find workflow status for issue SOMEPRJ-123456.".
It suggests, the jiraissue.issuestatus column on that issue is null.
How to check:

?

1	SELECT ID FROM JIRAISSUE WHERE ISSUESTATUS IS NULL;

How to fix it in Oracle:
Prerequisites: For the TEMP_JIRAWORKFLOWS, see here: http://kozelljozsef.blogspot.hu/2014/11/jira-check-workflow-current-step-entries.html

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

MERGE INTO jiraissue USING (   WITH W_JIRAISSUE AS   ( SELECT       I.ID AS ISSUEID,       I.WORKFLOW_ID,       I.ISSUESTATUS,       W.NAME AS WFNAME,       C.STEP_ID AS CURRENT_STEP_ID     FROM JIRAISSUE I     INNER JOIN OS_WFENTRY W     ON I.WORKFLOW_ID = W.ID     INNER JOIN OS_CURRENTSTEP C     ON I.WORKFLOW_ID = C.ENTRY_ID     WHERE I.ISSUESTATUS IS NULL   ) SELECT   I.ISSUEID,   I.ISSUESTATUS,   WF.LINKEDSTATUSID AS LINKED_STATUS_ID FROM W_JIRAISSUE I INNER JOIN TEMP_JIRAWORKFLOWS WF ON WF.WORKFLOWNAME = I.WFNAME AND WF.STEPID = I.CURRENT_STEP_ID ) GOODSTATUS ON (GOODSTATUS.issueid = JIRAISSUE.ID) WHEN MATCHED THEN UPDATE     SET JIRAISSUE.ISSUESTATUS = GOODSTATUS.LINKED_STATUS_ID;

This essentially looks up the workflow step associated with the failing issue, reads out the linked status id that should be written back to the issuestatus column.