Failed to import from CSV file

Issue #53 closed
Yuval Zaltz created an issue

I’ve updated to latest version that include import from CSV -
I’ve created a Tree CustomField multiselect field called OS Flavor and included entry Windows then 10 19H1

I’ve tried to import a CSV where SO Flavor eq. Windows/10 19H1

I got this in the log

attaching CSV

2020-08-18 13:53:13,606 INFO - Importer started!
2020-08-18 13:53:13,609 INFO - Engine is running in Validation-only mode
2020-08-18 13:53:13,610 INFO - All issues will be imported to project: WCS WIFI (WIFI)
2020-08-18 13:53:13,612 INFO - Creating issue: [externalId='autoid-1728253893985510862', summary='test OS Flavor']
2020-08-18 13:53:13,621 INFO - Issue does not have issue type selected, the affected issues will be created with default issue type [Bug]
2020-08-18 13:53:13,634 ERROR - Fatal error during import
java.lang.NumberFormatException: For input string: "Windows/10 19H1"
    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.lang.Integer.parseInt(Integer.java:580)
    at java.lang.Integer.parseInt(Integer.java:615)
    at ru.slie.jira.tree.customfield.TreeMultiCustomField.validateFromParams(TreeMultiCustomField.java:188)
    at com.atlassian.jira.issue.fields.ImmutableCustomField.validateParams(ImmutableCustomField.java:705)
    at com.atlassian.jira.web.action.issue.IssueCreationHelperBeanImpl.validateCreateIssueFields(IssueCreationHelperBeanImpl.java:83)
    at com.atlassian.jira.web.action.issue.IssueCreationHelperBeanImpl.validateCreateIssueFields(IssueCreationHelperBeanImpl.java:57)
    at com.atlassian.jira.bc.issue.DefaultIssueService.validateAndCreateIssueFromFields(DefaultIssueService.java:784)
    at com.atlassian.jira.bc.issue.DefaultIssueService.validateCreate(DefaultIssueService.java:744)
    at com.atlassian.jira.bc.issue.DefaultIssueService.validateCreate(DefaultIssueService.java:206)
    at sun.reflect.GeneratedMethodAccessor4073.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
    at com.sun.proxy.$Proxy239.validateCreate(Unknown Source)
    at sun.reflect.GeneratedMethodAccessor4073.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
    at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
    at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
    at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
    at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
    at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
    at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
    at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
    at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
    at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
    at com.sun.proxy.$Proxy1210.validateCreate(Unknown Source)
    at com.atlassian.jira.plugins.importer.compatibility.CompatibilityUtil71.validateCreate(CompatibilityUtil71.java:226)
    at com.atlassian.jira.plugins.importer.compatibility.CompatibilityBridgeUtils.validateCreate(CompatibilityBridgeUtils.java:109)
    at com.atlassian.jira.plugins.importer.imports.bulkcreate.engine.BulkCreateDataImporter.doImportIssues(BulkCreateDataImporter.java:226)
    at com.atlassian.jira.plugins.importer.imports.bulkcreate.engine.BulkCreateDataImporter.runImporterEngine(BulkCreateDataImporter.java:172)
    at com.atlassian.jira.plugins.importer.imports.bulkcreate.engine.BulkCreateDataImporter.doValidate(BulkCreateDataImporter.java:141)
    at com.atlassian.jira.plugins.importer.imports.bulkcreate.ValidationCallable.call(ValidationCallable.java:27)
    at com.atlassian.jira.plugins.importer.imports.bulkcreate.ValidationCallable.call(ValidationCallable.java:12)
    at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:533)
    at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:491)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:216)
    at java.lang.Thread.run(Thread.java:748)

Comments (8)

  1. Yury Oboz repo owner

    I can’t reproduce this error.

    What is your jira version?

    You can use Jira impor wizard?

    Can you descript import step by step?

  2. Yuval Zaltz reporter

    Jira DC - 8.5.4 -

    I didn’t use the Admin but the Issues → Import issues from CSV.

    And followed the wizard - selecting the csv, (comma as delimiter), mapping the fields - it failed during the validation

  3. Log in to comment