CSV import is failing and the log is not clear about what needs fixing

I'm trying to run a csv import from Testtrack. Only importing one issue and its failing. The log error is not clear.

2012-12-06 13:25:27,536 INFO - Import started by dgoldshteyn using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean

2012-12-06 13:25:27,579 INFO - ------------------------------

2012-12-06 13:25:27,579 INFO - Importing: Users

2012-12-06 13:25:27,580 INFO - ------------------------------

2012-12-06 13:25:27,580 INFO - Only new items will be imported

2012-12-06 13:25:27,580 INFO - 1 users associated with import.

2012-12-06 13:25:27,580 INFO - ------------------------------

2012-12-06 13:25:27,581 INFO - Finished Importing : Users

2012-12-06 13:25:27,581 INFO - ------------------------------

2012-12-06 13:25:27,581 INFO - 0 users successfully created.

2012-12-06 13:25:27,581 INFO - Retrieving projects...

2012-12-06 13:25:27,582 INFO - Project ExternalProject jiraId=<null>,id=<null>,externalName=<null>,name=<null>,key=PLAT,url=<null>,lead=<null>,description=<null>,projectCategoryName=<null>,avatarUrl=<null>,assigneeType=<null>,versions=<null>,components=<null>,issues=<null>,workflowSchemeName=<null> already exists. Not imported

2012-12-06 13:25:27,582 INFO - ------------------------------

2012-12-06 13:25:27,582 INFO - Importing: Versions

2012-12-06 13:25:27,582 INFO - ------------------------------

2012-12-06 13:25:27,582 INFO - Only new items will be imported

2012-12-06 13:25:27,582 INFO - ------------------------------

2012-12-06 13:25:27,582 INFO - Finished Importing : Versions

2012-12-06 13:25:27,582 INFO - ------------------------------

2012-12-06 13:25:27,582 INFO - ------------------------------

2012-12-06 13:25:27,582 INFO - Importing: Components

2012-12-06 13:25:27,583 INFO - ------------------------------

2012-12-06 13:25:27,583 INFO - Only new items will be imported

2012-12-06 13:25:27,583 INFO - ------------------------------

2012-12-06 13:25:27,583 INFO - Finished Importing : Components

2012-12-06 13:25:27,583 INFO - ------------------------------

2012-12-06 13:25:27,583 INFO - Retrieving custom fields...

2012-12-06 13:25:27,584 INFO - ------------------------------

2012-12-06 13:25:27,584 INFO - Importing: Issues

2012-12-06 13:25:27,584 INFO - ------------------------------

2012-12-06 13:25:27,584 INFO - Only new items will be imported

2012-12-06 13:25:27,585 INFO - Importing issue: ExternalIssue{externalId=autoid-4433502181760972327, summary=Failover Servers section in Virtual System Settings allow to save up to 5 identical URLs., issueType=Bug}

2012-12-06 13:25:27,611 ERROR - Error importing issue ExternalIssue{externalId=autoid-4433502181760972327, summary=Failover Servers section in Virtual System Settings allow to save up to 5 identical URLs., issueType=1}

com.atlassian.jira.plugins.importer.external.ExternalException: Unable to create issue: Failover Servers section in Virtual System Settings allow to save up to 5 identical URLs.

at com.atlassian.jira.plugins.importer.imports.importer.impl.ExternalUtils.createIssue(ExternalUtils.java:172)

at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:848)

at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:762)

at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:354)

at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:27)

at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:16)

at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:366)

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

at java.util.concurrent.FutureTask.run(FutureTask.java:138)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

at java.util.concurrent.FutureTask.run(FutureTask.java:138)

at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61)

at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160)

at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249)

at java.lang.Thread.run(Thread.java:662)

Caused by: com.atlassian.jira.exception.CreateException: Error occurred while creating issue through workflow:

at com.atlassian.jira.issue.managers.DefaultIssueManager.createIssue(DefaultIssueManager.java:449)

at sun.reflect.GeneratedMethodAccessor5063.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$AbstractMultiTenantAwareInvocationHandler.invokeInternal(MultiTenantComponentFactoryImpl.java:181)

at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$MultiTenantAwareInvocationHandler.invoke(MultiTenantComponentFactoryImpl.java:211)

at $Proxy78.createIssue(Unknown Source)

at sun.reflect.GeneratedMethodAccessor5063.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)

at $Proxy78.createIssue(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154)

at $Proxy78.createIssue(Unknown Source)

at com.atlassian.jira.plugins.importer.imports.importer.impl.ExternalUtils.createIssue(ExternalUtils.java:164)

... 15 more

Caused by: InvalidInputException: Error map: {} Error list: Build is required., Target Release Version/s is required.

at com.googlecode.jsu.util.ValidatorErrorsBuilder.process(ValidatorErrorsBuilder.java:50)

at com.googlecode.jsu.workflow.validator.GenericValidator.validate(GenericValidator.java:75)

at com.opensymphony.workflow.AbstractWorkflow.verifyInputs(AbstractWorkflow.java:1512)

at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(AbstractWorkflow.java:1203)

at com.opensymphony.workflow.AbstractWorkflow.initialize(AbstractWorkflow.java:615)

at com.atlassian.jira.workflow.OSWorkflowManager.createIssue(OSWorkflowManager.java:803)

at com.atlassian.jira.issue.managers.DefaultIssueManager.createIssue(DefaultIssueManager.java:440)

... 33 more

2012-12-06 13:25:27,613 INFO - 1 issues successfully created

2012-12-06 13:25:27,613 INFO - ------------------------------

2012-12-06 13:25:27,613 INFO - Finished Importing : Issues

2012-12-06 13:25:27,613 INFO - ------------------------------

2012-12-06 13:25:27,613 INFO - ------------------------------

2012-12-06 13:25:27,613 INFO - Importing: Issue Links & Subtasks

2012-12-06 13:25:27,614 INFO - ------------------------------

2012-12-06 13:25:27,614 INFO - Only new items will be imported

2012-12-06 13:25:27,614 INFO - ------------------------------

2012-12-06 13:25:27,614 INFO - Finished Importing : Issue Links & Subtasks

2012-12-06 13:25:27,614 INFO - ------------------------------

2012-12-06 13:25:27,618 INFO - No issues need to be reindexed.

1 answer

Hi, looking at your logs I've at least found:

Caused by: InvalidInputException: Error map: {} Error list: Build is required., Target Release Version/s is required.

The above means you have required fields that aren't mapped in the csv and is causing it to fail. I'd check all the required fields and see if they are mapped.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Thursday in Off-topic

Friday Fun: Magic Eyes

...staring into the background. Once the image pops out in 3D, you can look around the picture and enjoy. If you will see if you are a true illusion master! :) You did it? :) Wow! Awesome! As a bonus...

423 views 79 11
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you