Community resources
Community resources
Community resources
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.