JIRA: Check workflow entry states are correct

Symptom: You see no transition buttons on the ticket, but when you edit it, they come back.
Cause: The workflow entry associated with the issues in screwed up. Its state is "created"(zero) or null instead of "activated"(one).
How to check:

?

1 2 3 4 5

SELECT PROJECT.PKEY || '-' || JIRAISSUE.ISSUENUM AS PKEY, JIRAISSUE.WORKFLOW_ID, OS_WFENTRY.STATE FROM JIRAISSUE INNER JOIN OS_WFENTRY ON JIRAISSUE.WORKFLOW_ID = OS_WFENTRY.ID INNER JOIN PROJECT ON PROJECT.ID = JIRAISSUE.PROJECT WHERE OS_WFENTRY.STATE IS NULL OR OS_WFENTRY.STATE = 0;

These should return all the issues you have the problem with.

How to fix it in Oracle:

?

1 2 3 4

UPDATE OS_WFENTRY SET STATE = 1 WHERE ID IN ( SELECT OS_WFENTRY.ID FROM OS_WFENTRY INNER JOIN JIRAISSUE ON JIRAISSUE.WORKFLOW_ID = OS_WFENTRY.ID WHERE OS_WFENTRY.STATE IS NULL OR OS_WFENTRY.STATE = 0);

There are other workflow state codes, but the official correction in the integrity checker is to set it to 1 (activated).