Jira Import CSV fails

[tobania-eps]

Hi,

Jira Import CSV fails with the following stack trace, does anyone have any idea where I should start looking?

java.lang.IndexOutOfBoundsException: Index: 3, Size: 1

java.lang.IndexOutOfBoundsException: Index: 3, Size: 1
	at java.util.ArrayList.rangeCheck(ArrayList.java:653) [?:1.8.0_102]
	at java.util.ArrayList.get(ArrayList.java:429) [?:1.8.0_102]
	at com.atlassian.jira.plugins.importer.imports.csv.CsvFile$3.handleReader(CsvFile.java:104) [?:?]
	at com.atlassian.jira.plugins.importer.imports.csv.CsvFile.accessCsvFile(CsvFile.java:196) [?:?]
	at com.atlassian.jira.plugins.importer.imports.csv.CsvFile.getUniqueValues(CsvFile.java:97) [?:?]
	at com.atlassian.jira.plugins.importer.web.csv.GoodCsvConfigBean.getUniqueValues(GoodCsvConfigBean.java:215) [?:?]
	at com.atlassian.jira.plugins.importer.web.csv.AbstractCsvFieldMappingPage.doValidation(AbstractCsvFieldMappingPage.java:114) [?:?]
	at com.atlassian.jira.plugins.importer.imports.csv.web.CsvFieldMappingsPage.doValidation(CsvFieldMappingsPage.java:96) [?:?]
	at webwork.action.ActionSupport.validate(ActionSupport.java:391) [webwork-1.4-atlassian-30.jar:?]
	at webwork.action.ActionSupport.execute(ActionSupport.java:162) [webwork-1.4-atlassian-30.jar:?]
	at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63) [jira-api-7.7.0.jar:?]
	at com.atlassian.jira.plugins.importer.web.ImporterProcessSupport.execute(ImporterProcessSupport.java:152) [?:?]
	at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39) [webwork-1.4-atlassian-30.jar:?]
	at webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31) [webwork-1.4-atlassian-30.jar:?]
	at webwork.interceptor.ChainedInterceptor.intercept(ChainedInterceptor.java:16) [webwork-1.4-atlassian-30.jar:?]
	at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:35) [webwork-1.4-atlassian-30.jar:?]
	at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:225) [webwork-1.4-atlassian-30.jar:?]
	at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:154) [webwork-1.4-atlassian-30.jar:?]
	at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:138) [classes/:?]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) [servlet-api.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.jira.web.filters.JiraLastFilter.lambda$doFilter$0(JiraLastFilter.java:39) [classes/:?]
	at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) [classes/:?]
	(etc)

[Rambabu Patina _Appfire_ · Accepted solution]

Probably the issue is with the CSV file format. Please try the resolution at https://confluence.atlassian.com/jirakb/csv-import-causes-indexoutofboundsexception-133693858.html

[tobania-eps]

All rows have a summary, but the error is still happening.

[Rambabu Patina _Appfire_]

If possible can you attach your CSV files here by mocking sensitive data in your file.

[tobania-eps]

It did turn out to be the CSV file format. I made sure the Summary and Comments didn't have any double quotes in them (yeah, I know!) and then all went well. :-)

[Eric Lemay]

This is an odd error indeed.  Does this happen while loading the column to field mapping page?  Or after the mapping when doing the actual import?  According to what I can see it seems to be causing an error when loading the mappings.

[tobania-eps]

This happens after defining the mappings, before doing the actual mapping.