Jira CSV Import Problem

I'm getting an error whenever I try to import my data from a CSV. The data there looks good, and it was working earlier, but now it's not pulling in the data. Here's the logs. Any thoughts?

2012-05-02 17:17:00,329 INFO - Importing issue: ExternalIssue{externalId=autoid-4516734068725201672, summary="C18 ? Voice Grid Picking dialogue changes.", issueType=7}
2012-05-02 17:17:00,360 ERROR - Error importing issue ExternalIssue{externalId=autoid-4516734068725201672, summary="C18 ? Voice Grid Picking dialogue changes.", issueType=7}
com.atlassian.jira.plugins.importer.external.ExternalException: Unable to create issue: WAIBRA-143
	at com.atlassian.jira.plugins.importer.external.ExternalUtils.createIssue(ExternalUtils.java:245)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:778)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:704)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:302)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:25)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:14)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:359)
	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: com.atlassian.jira.workflow.WorkflowException: Error occurred while storing issue.
	at com.atlassian.jira.issue.managers.DefaultIssueManager.createIssue(DefaultIssueManager.java:414)
	at sun.reflect.GeneratedMethodAccessor1961.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 $Proxy77.createIssue(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor1961.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 $Proxy77.createIssue(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor1961.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.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154)
	at $Proxy77.createIssue(Unknown Source)
	at com.atlassian.jira.plugins.importer.external.ExternalUtils.createIssue(ExternalUtils.java:237)
	... 15 more
Caused by: com.atlassian.jira.workflow.WorkflowException: Error occurred while storing issue.
	at com.atlassian.jira.workflow.OSWorkflowManager.createIssue(OSWorkflowManager.java:846)
	at com.atlassian.jira.issue.managers.DefaultIssueManager.createIssue(DefaultIssueManager.java:402)
	... 32 more
Caused by: com.atlassian.jira.exception.DataAccessException: Error occurred while storing issue.
	at com.atlassian.jira.issue.IssueImpl.store(IssueImpl.java:1182)
	at com.atlassian.jira.workflow.function.issue.IssueCreateFunction.execute(IssueCreateFunction.java:76)
	at com.opensymphony.workflow.AbstractWorkflow.executeFunction(AbstractWorkflow.java:869)
	at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(AbstractWorkflow.java:1265)
	at com.opensymphony.workflow.AbstractWorkflow.initialize(AbstractWorkflow.java:618)
	at com.atlassian.jira.workflow.OSWorkflowManager.createIssue(OSWorkflowManager.java:805)
	... 33 more
Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Issue][summary,"C18 ? Voice Grid Picking dialogue changes."][status,1][votes,0][assignee,mtaylor][security,null][resolutiondate,0011-04-14 00:00:00.0][type,7][timespent,null][id,10570][reporter,mtaylor][project,10146][environment,null][created,0011-04-14 00:00:00.0][updated,0011-04-14 00:00:00.0][workflowId,10570][description,"MTaylor 2011-Apr-14:  For Voice Grid Picking, the following changes are required:  ? Two new logical flows in voice dialogue (see flow charts in following section):   o Single SKU Grid Picking:      System Prompt    User Response      Location 501    345 (Check-string)    PICK 2     2     o Multi SKU Grid Picking (multi tag or mixed pallet):      System Prompt    User Response      Location 501     345 (Check-string)    2345(TAG ? last four digits)Pick 2 2    ? Tag id confirmation (last 3-4 characters ? set in system profile).  ? All functionality to be wrapped in a new function access    This change is being engineered ahead of the rest of the customisations to allow the user to trial voice picking to allow them to evaluate the technology."][priority,null][timeestimate,null][duedate,0011-05-03 00:00:00.0][timeoriginalestimate,null][watches,0][key,WAIBRA-143] (SQL Exception while setting value:  (Only dates between January 1, 1753 and December 31, 9999 are accepted.))
	at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:133)
	at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:98)
	at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:64)
	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:489)
	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:469)
	at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:80)
	at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:71)
	at com.atlassian.jira.issue.IssueImpl.store(IssueImpl.java:1165)
	... 38 more
2012-05-02 17:17:00,360 INFO - 1 issues successfully created
2012-05-02 17:17:00,360 INFO - ------------------------------
2012-05-02 17:17:00,360 INFO - Finished Importing : Issues
2012-05-02 17:17:00,360 INFO - ------------------------------
2012-05-02 17:17:00,360 INFO - ------------------------------
2012-05-02 17:17:00,360 INFO - Importing: Issue Links & Subtasks
2012-05-02 17:17:00,360 INFO - ------------------------------
2012-05-02 17:17:00,360 INFO - Only new items will be imported
2012-05-02 17:17:00,360 INFO - ------------------------------
2012-05-02 17:17:00,360 INFO - Finished Importing : Issue Links & Subtasks
2012-05-02 17:17:00,360 INFO - ------------------------------
2012-05-02 17:17:00,407 INFO - No issues need to be reindexed.

3 answers

Judging from the date errors that are in the log file, it appears that something has gone with with the settings, probably on your sqlserver. Have you verified that the system time is still correct?

The problem was occurring yesterday as I left, and again this morning.

Here are the logs from this morning:

2012-05-03 08:18:39,328 INFO - Import started by prichert using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2012-05-03 08:18:39,328 INFO - ------------------------------
2012-05-03 08:18:39,328 INFO - Importing: Users
2012-05-03 08:18:39,328 INFO - ------------------------------
2012-05-03 08:18:39,328 INFO - Only new items will be imported
2012-05-03 08:18:39,328 INFO - 1 users associated with import.
2012-05-03 08:18:39,328 INFO - ------------------------------
2012-05-03 08:18:39,328 INFO - Finished Importing : Users
2012-05-03 08:18:39,328 INFO - ------------------------------
2012-05-03 08:18:39,328 INFO - 0 users successfully created.
2012-05-03 08:18:39,328 INFO - Retrieving custom fields...
2012-05-03 08:18:39,328 INFO - Retrieving projects...
2012-05-03 08:18:39,343 INFO - Project ExternalProject[jiraId=<null>,id=<null>,externalName=<null>,name=Waitrose (WAIBRA),key=WAIBRA,url=<null>,lead=<null>,description=<null>,projectCategoryName=<null>,assigneeType=<null>,workflowSchemeName=<null>] already exists. Not imported
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Importing: Versions
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Only new items will be imported
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Finished Importing : Versions
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Importing: Components
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Only new items will be imported
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Finished Importing : Components
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Importing: Issues
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Only new items will be imported
2012-05-03 08:18:39,343 INFO - Importing issue: ExternalIssue{externalId=autoid-7951839915623534765, summary=Various 2011.1.0 Voice Issues, issueType=Bug}
2012-05-03 08:18:39,343 ERROR - Error importing issue ExternalIssue{externalId=autoid-7951839915623534765, summary=Various 2011.1.0 Voice Issues, issueType=1}
com.atlassian.jira.plugins.importer.external.ExternalException: Unable to create issue: WAIBRA-144
	at com.atlassian.jira.plugins.importer.external.ExternalUtils.createIssue(ExternalUtils.java:245)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:778)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:704)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:302)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:25)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:14)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:359)
	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: com.atlassian.jira.workflow.WorkflowException: Error occurred while storing issue.
	at com.atlassian.jira.issue.managers.DefaultIssueManager.createIssue(DefaultIssueManager.java:414)
	at sun.reflect.GeneratedMethodAccessor1961.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 $Proxy77.createIssue(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor1961.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 $Proxy77.createIssue(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor1961.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.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154)
	at $Proxy77.createIssue(Unknown Source)
	at com.atlassian.jira.plugins.importer.external.ExternalUtils.createIssue(ExternalUtils.java:237)
	... 15 more
Caused by: com.atlassian.jira.workflow.WorkflowException: Error occurred while storing issue.
	at com.atlassian.jira.workflow.OSWorkflowManager.createIssue(OSWorkflowManager.java:846)
	at com.atlassian.jira.issue.managers.DefaultIssueManager.createIssue(DefaultIssueManager.java:402)
	... 32 more
Caused by: com.atlassian.jira.exception.DataAccessException: Error occurred while storing issue.
	at com.atlassian.jira.issue.IssueImpl.store(IssueImpl.java:1182)
	at com.atlassian.jira.workflow.function.issue.IssueCreateFunction.execute(IssueCreateFunction.java:76)
	at com.opensymphony.workflow.AbstractWorkflow.executeFunction(AbstractWorkflow.java:869)
	at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(AbstractWorkflow.java:1265)
	at com.opensymphony.workflow.AbstractWorkflow.initialize(AbstractWorkflow.java:618)
	at com.atlassian.jira.workflow.OSWorkflowManager.createIssue(OSWorkflowManager.java:805)
	... 33 more
Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Issue][summary,Various 2011.1.0 Voice Issues][status,1][votes,0][assignee,mtaylor][security,null][resolutiondate,0011-03-23 00:00:00.0][type,1][timespent,null][id,10572][reporter,mtaylor][project,10146][environment,null][created,0011-03-23 00:00:00.0][updated,0011-03-23 00:00:00.0][workflowId,10572][description,"MTaylor 2011-Mar-23:  Some standard issues have been found in 2011.1.0 voice."][priority,null][timeestimate,null][duedate,0011-07-28 00:00:00.0][timeoriginalestimate,null][watches,0][key,WAIBRA-144] (SQL Exception while setting value:  (Only dates between January 1, 1753 and December 31, 9999 are accepted.))
	at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:133)
	at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:98)
	at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:64)
	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:489)
	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:469)
	at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:80)
	at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:71)
	at com.atlassian.jira.issue.IssueImpl.store(IssueImpl.java:1165)
	... 38 more
2012-05-03 08:18:39,343 INFO - 1 issues successfully created
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Finished Importing : Issues
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Importing: Issue Links & Subtasks
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Only new items will be imported
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,343 INFO - Finished Importing : Issue Links & Subtasks
2012-05-03 08:18:39,343 INFO - ------------------------------
2012-05-03 08:18:39,390 INFO - No issues need to be reindexed.

Look at the dates you’re trying to import. The logs say that you’re trying to set “resolutiondate” to 0011-04-14 00:00:00.0, for example. That’s over 2,000 years ago. Your old bug tracking system isn’t that old. That’s why the importer is complaining that “Only dates between January 1, 1753 and December 31, 9999 are accepted.”

It looks like your CSV file is exporting 2-digit years, while the importer expects 4-digit years. You should be able to tell the importer what format your dates are in on the “Setup project mappings” screen. Make sure that you tell it to expect 2-digit years, and it will properly fill in the century (according to the rules listed in http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html .) Alternatively, make sure your CSV file is exporting the full 4-digit year.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,203 views 13 19
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot