Error while creating Scrum Board sample data
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Symptoms
The following appears in the atlassian-jira.log:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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:
1
2
3
4
5
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'.
Solution
Workaround
Backup JIRA XML.
Update the pname from To do to To Do:
1update issuestatus set pname = 'To Do' where id = '<issue_status_id>';After that, restart JIRA.
ℹ️ Might encounter this JSWSERVER-11122/GHS-11122 bug issue.
Was this helpful?