Error while creating Scrum Board sample data

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

The following appears in the atlassian-jira.log:

2014-10-30 21:36:53,637 http-bio-xxx-exec-14 ERROR xxx xxxx xxxx xx.xx.xx.xx /rest/greenhopper/1.0/welcome/createProject [imports.importer.impl.AbstractDataImporter$1Thread[http-bio-xx-exec-14,5,main]] Error importing issue ExternalIssue{externalId=null, summary=As an Agile team, I'd like to learn about Scrum >> Click the "SSPD-1" link at the left of this row to see detail in the Description tab on the right, issueType=167}
com.atlassian.jira.plugins.importer.external.ExternalException: Unable to create issue: As an Agile team, I'd like to learn about Scrum >> Click the "SSPD-1" link at the left of this row to see detail in the Description tab on the right
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ExternalUtils.createIssue(ExternalUtils.java:194)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:896)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:764)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:390)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26)
	at com.atlassian.jira.plugins.importer.sample.SampleDataImporterImpl.createSampleData(SampleDataImporterImpl.java:111)
	at com.atlassian.jira.plugins.importer.sample.SampleDataImporterImpl.createSampleData(SampleDataImporterImpl.java:98)
	at com.atlassian.greenhopper.optionalfeatures.sampledata.SampleDataGeneratorImpl.createSampleData(SampleDataGeneratorImpl.java:227)
	at com.atlassian.greenhopper.optionalfeatures.sampledata.SampleDataGeneratorImpl.importSampleDataFromUrl(SampleDataGeneratorImpl.java:152)
	at com.atlassian.greenhopper.optionalfeatures.sampledata.SampleDataGeneratorImpl.createSampleScrumData(SampleDataGeneratorImpl.java:136)
	at com.atlassian.greenhopper.web.rapid.welcome.WelcomeHelper.createProject(WelcomeHelper.java:355)
...
Caused by: com.atlassian.jira.plugins.importer.external.ExternalException: Status 'To do' does not have a linked step in the 'Agile Simplified Workflow for Project SSPD' workflow. Please map to a different status.
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ExternalUtils.checkStatus(ExternalUtils.java:209)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ExternalUtils.createIssue(ExternalUtils.java:183)
	... 206 more

Diagnosis

Check the 'Caused by' error which stated:

Status 'To do' does not have a linked step in the 'Agile Simplified Workflow for Project SSPD' workflow

So we need to inspect the 'To do' status in issuestatus table:

select * from issuestatus where pname ='To do';
 
or
 
select * from issuestatus where pname ='ToDo';

Cause

JIRA Agile is looking for To Do status when creating the sample board. The problem was related to the 'To Do' status name was not initial correctly or have been rename before such as 'to do', 'To do' or 'todo'.

Workaround

  1. Backup JIRA XML.

  2. Update the pname from To do to To Do:

    update issuestatus set pname = 'To Do' where id = '<issue_status_id>';


  3. After that, restart JIRA.
    (info) Might encounter this GHS-11122 - Getting issue details... STATUS bug issue.

 

Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.