Clicking "Configure" on Rapid board will throw NullPointerException
Symptoms
The following appears in the atlassian-jira.log
:
2014-10-01 16:07:58,464 ajp-bio-11016-exec-13 ERROR D441139 967x38859x1 11pgs2u 172.29.218.119 /rest/greenhopper/1.0/rapidviewconfig/editmodel.json [web.rapid.view.RapidViewEditResource] Unable to complete GreenHopper REST method
java.lang.NullPointerException
at com.atlassian.greenhopper.service.workflow.SimplifiedWorkflowServiceImpl.getGreenHopperSimplifiedWorkflow(SimplifiedWorkflowServiceImpl.java:185)
at com.atlassian.greenhopper.web.rapid.workflow.WorkflowHelper.getGreenHopperSimplifiedWorkflow(WorkflowHelper.java:93)
at com.atlassian.greenhopper.web.rapid.workflow.WorkflowHelper.isRapidViewUsingGreenHopperSimplifiedWorkflow(WorkflowHelper.java:61) ....
Cause
There are workflow schemes pointing to projects which doesn't exist, as the null pointer is thrown because of this part of the code:
if (!projects.isEmpty())
{
Project p = projects.iterator().next();
if (!project.getId().equals(p.getId()))
{
return error(VALIDATION_FAILED, "gh.workflow.simple.workflow.error.exactly.one.project");
}
}
Resolution
Backup your database before running this Delete, as if anything goes wrong we can rollback your data to a previous working state.
- Shutdown JIRA
Run the query below:
DELETE FROM nodeassociation WHERE sink_node_entity = 'WorkflowScheme' AND source_node_id NOT IN (SELECT id FROM project);
- Start JIRA
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.