Create Sign up Log in
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Community resources
Community resources
- Community
- Products
- Jira Software
- Questions
- Jira CSV Import Problem
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
CEDRIC ZABEL
Rising Star 
May 3, 2012 edited Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jo-Anne MacLeod
Rising Star
May 2, 2012 edited Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Was this helpful?
Thanks!
TAGS
Community showcase
Atlassian Community Events
- FAQ
- Community Guidelines
- About
- Privacy policy
- Notice at Collection
- Terms of use
- © 2024 Atlassian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.