CSV Import and Epic Link error

[Vincent Cottineau]

Hello,

I am trying to import a .csv file to Jira and set the Epic link. File content is the following:

Issues EE-384, EE-385, EE-386, EV-45, EV-46 and EV-43 are existing in their respected Jira projects.

The configuration file used for the mapping is the following:

{
"config.field.mappings" : {
"Project key" : {
"jira.field" : "project.key"
},
"Project name" : {
"jira.field" : "project.name"
},
"Project type" : {
"jira.field" : "project.type"
},
"Issue key" : {
"jira.field" : "issuekey"
},
"Issue Type" : {
"jira.field" : "issuetype"
},
"Summary" : {
"jira.field" : "summary"
},
"Custom field (Epic Link)" : {
"existing.custom.field" : "10000"
}
},
}

All fields are mapped correctly:

However, when I run "Begin import", I am getting the following screen:

I can't figure out how to make it work. I tried a lot of combinations but without success. Stack trace:

2022-03-09 20:36:48,825 WARN - Cannot add value [ [EV-45] ] to CustomField Epic Link in Issue with summary '###'. Exception Message: null
java.lang.NullPointerException
at com.atlassian.jira.issue.search.parameters.lucene.DefaultPermissionQueryFactory.collectProjectTerms(DefaultPermissionQueryFactory.java:141)
at com.atlassian.jira.issue.search.parameters.lucene.DefaultPermissionQueryFactory.createQuery(DefaultPermissionQueryFactory.java:79)
at com.atlassian.jira.issue.search.parameters.lucene.DefaultPermissionQueryFactory.getQuery(DefaultPermissionQueryFactory.java:62)
at com.atlassian.jira.issue.search.parameters.lucene.PermissionsFilterGeneratorImpl.getQuery(PermissionsFilterGeneratorImpl.java:37)
at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.lambda$getPermissionsQuery$3(LuceneSearchProvider.java:430)
at java.base/java.util.Optional.orElseGet(Unknown Source)
at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.getPermissionsQuery(LuceneSearchProvider.java:430)
at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.getHits(LuceneSearchProvider.java:228)
at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:375)
at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:138)
at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:143)
at com.atlassian.jira.bc.issue.search.DefaultSearchService.search(DefaultSearchService.java:118)
at jdk.internal.reflect.GeneratedMethodAccessor1371.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
at com.sun.proxy.$Proxy664.search(Unknown Source)
at jdk.internal.reflect.GeneratedMethodAccessor1371.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
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:186)
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:186)
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:186)
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
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:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy1369.search(Unknown Source)
at com.atlassian.jira.plugins.importer.imports.importer.impl.customfields.CFValueHandlerEpicLink.findSingleIssueOrNull(CFValueHandlerEpicLink.java:112)
at com.atlassian.jira.plugins.importer.imports.importer.impl.customfields.CFValueHandlerEpicLink.prepareCustomFieldValue(CFValueHandlerEpicLink.java:54)
at com.atlassian.jira.plugins.importer.imports.importer.impl.customfields.CustomFieldValueFactory.prepareRawValueForCustomField(CustomFieldValueFactory.java:69)
at com.atlassian.jira.plugins.importer.imports.importer.impl.customfields.CustomFieldValueFactory.prepareValueForCustomField(CustomFieldValueFactory.java:53)
at com.atlassian.jira.plugins.importer.imports.importer.impl.customfields.CustomFieldsUtil.setCustomFieldValueForIssue(CustomFieldsUtil.java:202)
at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importExternalCustomFields(DefaultJiraDataImporter.java:1296)
at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:911)
at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:798)
at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:414)
at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26)
at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15)
at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:533)
at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:491)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:216)
at java.base/java.lang.Thread.run(Unknown Source)

Kind regards,

Vincent

[Vincent Cottineau · Accepted solution]

Issue is solved.

[Suvarna Gaikwad]

Hi @Vincent Cottineau 

Please check Link Issues and Edit Issues permissions for the project. Check if user used for import has required permissions. PFB screenshot.

[Vincent Cottineau]

Hi @Suvarna Gaikwad,

Thanks for your reply. I checked Permissions setting and it is set correctly. I have the 'Aministrators' role.

By the way, I succeded to clear the field but I am not able to set a new value for this field:

I can also set the Epic link by hand editing the Jira issue.

Regards,

Vincent

[Vincent Cottineau]

Hi,

Issue is solved thanks to this link: [JRACLOUD-66902] External system import fails when there is a project without Permission Scheme - Create and track feature requests for Atlassian products.

It can be seen as a Jira issue as existing Jira Projects should not be impacted by some wrong other Project settings.

Regards,

Vincent