Unable to do the CSV import for the issues.

[DevaKiran]

Hi,

When performing the CSV import from a Jira Server test instance it is showing as Failed Network Error. And i am attaching the log.

2019-05-15 07:02:13,904 http-nio-8080-exec-18 INFO sysadmin 422x106x1 dj62sa 182.75.230.206 /secure/admin/ViewLogging!markLogs.jspa [c.a.j.util.log.LogMarker] 
    
    ************
    EXPORT ERROR
    ************
    
2019-05-15 07:02:27,185 http-nio-8080-exec-6 ERROR      [o.a.c.c.C.[.[localhost].[/].[searchrequest-view]] Servlet.service() for servlet [searchrequest-view] in context with path [] threw exception
java.lang.RuntimeException: Could not find suitable distance for rank.
	at com.atlassian.greenhopper.model.lexorank.LexoRank.findSpacing(LexoRank.java:217)
	at com.atlassian.greenhopper.model.lexorank.LexoRank.between(LexoRank.java:185)
	at com.atlassian.greenhopper.model.lexorank.LexoRank.between(LexoRank.java:146)
	at com.atlassian.greenhopper.model.lexorank.LexoRank.genNext(LexoRank.java:108)
	at com.atlassian.greenhopper.service.lexorank.LexoRankOperation.rankInitially(LexoRankOperation.java:216)
	at com.atlassian.greenhopper.service.lexorank.LexoRankOperation.execute(LexoRankOperation.java:114)
	at com.atlassian.greenhopper.manager.lexorank.LexoRankManagerImpl.performRankOperation(LexoRankManagerImpl.java:300)
	at com.atlassian.greenhopper.manager.lexorank.LexoRankManagerImpl.getRankOrRankInitially(LexoRankManagerImpl.java:86)
	at com.atlassian.greenhopper.customfield.lexorank.LexoRankCFType.getValueFromIssue(LexoRankCFType.java:121)
	at com.atlassian.greenhopper.customfield.lexorank.LexoRankCFType.getValueFromIssue(LexoRankCFType.java:29)
	at com.atlassian.jira.issue.export.customfield.DefaultCsvIssueExporter.getFieldExportRepresentationForCustomField(DefaultCsvIssueExporter.java:149)
	at com.atlassian.jira.issue.export.customfield.DefaultCsvIssueExporter.getFieldExportRepresentation(DefaultCsvIssueExporter.java:124)
	at com.atlassian.jira.issue.export.customfield.DefaultCsvIssueExporter.access$100(DefaultCsvIssueExporter.java:47)
	at com.atlassian.jira.issue.export.customfield.DefaultCsvIssueExporter$1.collect(DefaultCsvIssueExporter.java:98)
	at com.atlassian.jira.issue.statistics.util.DocumentHitCollector.collect(DocumentHitCollector.java:30)
	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.searchAndSort(LuceneSearchProvider.java:393)
	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.searchAndSort(LuceneSearchProvider.java:155)
	at com.atlassian.jira.issue.views.util.DefaultSearchRequestViewBodyWriterUtil.searchAndSort(DefaultSearchRequestViewBodyWriterUtil.java:73)
	at com.atlassian.jira.issue.export.customfield.DefaultCsvIssueExporter.getLayout(DefaultCsvIssueExporter.java:106)
	at com.atlassian.jira.issue.export.customfield.DefaultCsvIssueExporter.export(DefaultCsvIssueExporter.java:70)
	at com.atlassian.jira.issue.views.csv.AbstractCsvSearchRequestView.writeSearchResults(AbstractCsvSearchRequestView.java:55)
	at com.atlassian.jira.plugin.searchrequestview.DefaultSearchRequestURLHandler.handleRequest(DefaultSearchRequestURLHandler.java:378)
	at com.atlassian.jira.web.servlet.SearchRequestViewServlet.doGet(SearchRequestViewServlet.java:25)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	... 44 filtered
	at com.atlassian.servicedesk.internal.web.ExternalCustomerLockoutFilter.doFilter(ExternalCustomerLockoutFilter.java:56)
	... 13 filtered
	at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
	... 53 filtered
	at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
	... 1 filtered
	at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
	... 36 filtered
	at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
	... 5 filtered
	at com.atlassian.jira.plugin.issuenav.LegacyTextQueryUrlRedirectFilter.doFilter(LegacyTextQueryUrlRedirectFilter.java:39)
	... 4 filtered
	at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.lambda$invokeFilterChain$0(CustomerContextSettingFilter.java:181)
	at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.rteInvoke(ReentrantThreadLocalBasedCodeContext.java:137)
	at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.runOutOfContext(ReentrantThreadLocalBasedCodeContext.java:90)
	at com.atlassian.servicedesk.internal.utils.context.CustomerContextServiceImpl.runOutOfCustomerContext(CustomerContextServiceImpl.java:47)
	at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.outOfCustomerContext(CustomerContextSettingFilter.java:174)
	at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilterImpl(CustomerContextSettingFilter.java:130)
	at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilter(CustomerContextSettingFilter.java:121)
	... 4 filtered
	at com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:32)
	... 8 filtered
	at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
	... 4 filtered
	at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
	... 26 filtered
	at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
	... 24 filtered
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
2019-05-15 07:02:41,129 http-nio-8080-exec-4 INFO sysadmin 422x126x1 dj62sa 182.75.230.206 /secure/admin/ViewLogging!markLogs.jspa [c.a.j.util.log.LogMarker] 
    
    ****************
    EXPORT ERROR END
    ****************

[Earl McCutcheon · Accepted solution]

Hi Deva,

The error you noted is primarily failing on the rank value with the focus on the portion "Could not find suitable distance for rank", and this is indicating that there could be duplication of the rank end marker rows or the end marker rows are missing and causing the import to fail because the system cannot find the appropriat range to add a rank to the issues.

As a firs step I would recommend going to the lexorank management page and run the ranking integrity checks as covered in:

• LexoRank Management

Let me know what you find.

Regards,
Earl