com.atlassian.jira.imports.csv.CsvImportException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank

Atlassian JIRA | Konstantin Goldin | 1 decade ago
  1. 0

    issue is tracked in JSP-8045. Attachments that repro the problem, and attachments with workaround are availiable in that support case. Details of support case are below. -------------------------------------------------------- I am trying to import attached file using import wizard. Get this stack: System Error A system error has occurred. If this problem persists - please notify your JIRA administrator of this problem. If you are an administrator, please try submitting this problem via the Support Request Page. Else, please create a support issue on our support system at http://support.atlassian.com with the following information: a description of your problem cut & paste the error and system information found below attach the application server log file (file:/opt/jira/atlassian-jira.log ) Cause: com.atlassian.jira.imports.csv.CsvImportException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank Stack Trace: [hide] com.atlassian.jira.imports.csv.CsvImportException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank at com.atlassian.jira.imports.csv.CsvConfigBean.(CsvConfigBean.java:171) at com.atlassian.jira.imports.csv.CsvConfigBean.createNewConfigBean(CsvConfigBean.java:907) at com.atlassian.jira.web.action.util.csv.ConfigureCsvMapping.doStart(ConfigureCsvMapping.java:113) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61) at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52) at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417) at webwork.action.ActionSupport.execute(ActionSupport.java:146) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:185) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) Referer URL: http://jira.reactivity.com/secure/admin/views/ConfigureCsvMapping!start.jspa Build Information: Uptime: N/A Edition: Enterprise Version: 3.6.4 Build Number: 160 Atlassian Partner: null Server Information: Application Server: Apache Tomcat/5.5.9 Servlet Version: 2.4 File Paths: Location of entityengine.xml: file:/opt/jira/atlassian-jira-enterprise-3.6.4-standalone/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log: file:/opt/jira/atlassian-jira.log Memory Information: Total Memory: 508 MB Free Memory: 90 MB Used Memory: 418 MB System Information: System Date: Monday, 20 Nov 2006 System Time: 14:33:06 Current Working Directory: /opt/jira Java Version: 1.4.2_04 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_04-b05 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: jira User Timezone: America/Los_Angeles User Locale: English (United States) System Encoding: UTF-8 Operating System: Linux 2.4.21-15.ELsmp OS Architecture: i386 Application Server Container: Database type: mysql Database JNDI address: java:comp/env/jdbc/JiraDS Database version: 3.23.58 Database driver: MySQL-AB JDBC Driver mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ ) Request Information: Request URL: http://jira.reactivity.com/500page.jsp * Scheme: http * Server: jira.reactivity.com * Port: 80 * URI: /500page.jsp * - Context Path: * - Servlet Path: /500page.jsp * - Path Info: null * - Query String: Request Attributes: * javax.servlet.forward.request_uri : /secure/admin/views/ConfigureCsvMapping!start.jspa * javax.servlet.forward.context_path : * javax.servlet.forward.servlet_path : /secure/admin/views/ConfigureCsvMapping!start.jspa * javax.servlet.forward.path_info : /500page.jsp * javax.servlet.error.message : * javax.servlet.error.exception : javax.servlet.ServletException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank * os_securityfilter_already_filtered : true * com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true * com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true * javax.servlet.error.request_uri : /secure/admin/views/ConfigureCsvMapping!start.jspa * jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@1c710a9 * javax.servlet.error.status_code : 500 * _sitemesh_filterapplied : true * jira.webwork.cleanup : false * javax.servlet.error.servlet_name : action * com.atlassian.jira.web.filters.gzip.GzipFilter_already_filtered : true * atlassian.core.seraph.original.url : /secure/admin/views/ConfigureCsvMapping!start.jspa * loginfilter.already.filtered : true * webwork.result : Value stack =========== =========== Request Logging: 0 log statements generated by this request: Description I am trying to import attached file using import wizard. Get this stack: System Error A system error has occurred. If this problem persists - please notify your JIRA administrator of this problem. If you are an administrator, please try submitting this problem via the Support Request Page. Else, please create a support issue on our support system at http://support.atlassian.com with the following information: a description of your problem cut & paste the error and system information found below attach the application server log file (file:/opt/jira/atlassian-jira.log ) Cause: com.atlassian.jira.imports.csv.CsvImportException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank Stack Trace: [hide] com.atlassian.jira.imports.csv.CsvImportException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank at com.atlassian.jira.imports.csv.CsvConfigBean.(CsvConfigBean.java:171) at com.atlassian.jira.imports.csv.CsvConfigBean.createNewConfigBean(CsvConfigBean.java:907) at com.atlassian.jira.web.action.util.csv.ConfigureCsvMapping.doStart(ConfigureCsvMapping.java:113) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61) at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52) at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417) at webwork.action.ActionSupport.execute(ActionSupport.java:146) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:185) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) Referer URL: http://jira.reactivity.com/secure/admin/views/ConfigureCsvMapping!start.jspa Build Information: Uptime: N/A Edition: Enterprise Version: 3.6.4 Build Number: 160 Atlassian Partner: null Server Information: Application Server: Apache Tomcat/5.5.9 Servlet Version: 2.4 File Paths: Location of entityengine.xml: file:/opt/jira/atlassian-jira-enterprise-3.6.4-standalone/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log: file:/opt/jira/atlassian-jira.log Memory Information: Total Memory: 508 MB Free Memory: 90 MB Used Memory: 418 MB System Information: System Date: Monday, 20 Nov 2006 System Time: 14:33:06 Current Working Directory: /opt/jira Java Version: 1.4.2_04 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_04-b05 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: jira User Timezone: America/Los_Angeles User Locale: English (United States) System Encoding: UTF-8 Operating System: Linux 2.4.21-15.ELsmp OS Architecture: i386 Application Server Container: Database type: mysql Database JNDI address: java:comp/env/jdbc/JiraDS Database version: 3.23.58 Database driver: MySQL-AB JDBC Driver mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ ) Request Information: Request URL: http://jira.reactivity.com/500page.jsp * Scheme: http * Server: jira.reactivity.com * Port: 80 * URI: /500page.jsp * - Context Path: * - Servlet Path: /500page.jsp * - Path Info: null * - Query String: Request Attributes: * javax.servlet.forward.request_uri : /secure/admin/views/ConfigureCsvMapping!start.jspa * javax.servlet.forward.context_path : * javax.servlet.forward.servlet_path : /secure/admin/views/ConfigureCsvMapping!start.jspa * javax.servlet.forward.path_info : /500page.jsp * javax.servlet.error.message : * javax.servlet.error.exception : javax.servlet.ServletException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank * os_securityfilter_already_filtered : true * com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true * com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true * javax.servlet.error.request_uri : /secure/admin/views/ConfigureCsvMapping!start.jspa * jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@1c710a9 * javax.servlet.error.status_code : 500 * _sitemesh_filterapplied : true * jira.webwork.cleanup : false * javax.servlet.error.servlet_name : action * com.atlassian.jira.web.filters.gzip.GzipFilter_already_filtered : true * atlassian.core.seraph.original.url : /secure/admin/views/ConfigureCsvMapping!start.jspa * loginfilter.already.filtered : true * webwork.result : Value stack =========== =========== Request Logging: 0 log statements generated by this request: Show » All Comments Work Log Change History Sort Order: [Ascending order - Click to sort in descending order] Change by Konstantin Goldin [20/Nov/06 04:37 PM] Field Original Value New Value Attachment import.csv [ 24313 ] Change by Konstantin Goldin [20/Nov/06 04:52 PM] Attachment import_comma.csv [ 24314 ] [ Permlink | Delete | « Hide ] Konstantin Goldin [20/Nov/06 04:52 PM] changing file from tab delimitered to comma delimetered does not help - still get a crach [ Show » ] Konstantin Goldin [20/Nov/06 04:52 PM] changing file from tab delimitered to comma delimetered does not help - still get a crach Change by Michelle de Guzman [28/Nov/06 07:34 PM] Assignee Michelle de Guzman [ michelle@atlassian.com ] Status Open [ 1 ] Waiting For Customer [ 10000 ] [ Permlink | Delete | « Hide ] Michelle de Guzman [28/Nov/06 07:34 PM] Hi Konstantin, The attached csv file works for me. - Cheers, Michelle [ Show » ] Michelle de Guzman [28/Nov/06 07:34 PM] Hi Konstantin, The attached csv file works for me. - Cheers, Michelle Change by Michelle de Guzman [28/Nov/06 07:34 PM] Attachment test.csv [ 24518 ] [ Permlink | Delete | « Hide ] Konstantin Goldin [29/Nov/06 07:38 PM] Michelle, I am glad that you have found a workaround. However, I will be receiving a lot more files of this format, and I will not be able to send all of them to support for clensing. What was wrong with this file? I have imported many other csv files, and they worked perfectly. So, I need to know exactly what was so special, what to avoid, etc. Appreciate your help. Konstantin [ Show » ] Konstantin Goldin [29/Nov/06 07:38 PM] Michelle, I am glad that you have found a workaround. However, I will be receiving a lot more files of this format, and I will not be able to send all of them to support for clensing. What was wrong with this file? I have imported many other csv files, and they worked perfectly. So, I need to know exactly what was so special, what to avoid, etc. Appreciate your help. Konstantin Change by Konstantin Goldin [29/Nov/06 07:38 PM] Status Waiting For Customer [ 10000 ] Waiting For Atlassian [ 10004 ] Change by Michelle de Guzman [03/Dec/06 09:22 PM] Attachment test.csv [ 24518 ] Change by Michelle de Guzman [03/Dec/06 09:22 PM] Attachment import_comma-fixed.csv [ 24635 ] Change by Michelle de Guzman [03/Dec/06 09:27 PM] Status Waiting For Atlassian [ 10004 ] Waiting For Customer [ 10000 ] [ Permlink | Delete | « Hide ] Michelle de Guzman [03/Dec/06 09:27 PM] Hi Konstantin, The problems were these entries below: When it is turned on; large HTTP requests ("large" means that WS-Engine gets them not as a single chunk; but as many consequent ... This was then changed to: "When it is turned on; large HTTP requests ('large' means that WS-Engine gets them not as a single chunk; but as many consequent ...". It was having issues with double quotes and single quotes. This line in your CSV also needed to be changed due to the same reason: Enable to specify wheter a specific pattern defense should be enabled upon the Request or Response: filterDirection="in" or "out... It then needed to be changed to: "Enable to specify wheter a specific pattern defense should be enabled upon the Request or Response: filterDirection='in' or 'out'..." I deleted the other csv file as it was incomplete and re-attached the fixed one that should work for you called import_comma-fixed.csv. Please let us know how that works for you. - Cheers, Michelle [ Show » ] Michelle de Guzman [03/Dec/06 09:27 PM] Hi Konstantin, The problems were these entries below: When it is turned on; large HTTP requests ("large" means that WS-Engine gets them not as a single chunk; but as many consequent ... This was then changed to: "When it is turned on; large HTTP requests ('large' means that WS-Engine gets them not as a single chunk; but as many consequent ...". It was having issues with double quotes and single quotes. This line in your CSV also needed to be changed due to the same reason: Enable to specify wheter a specific pattern defense should be enabled upon the Request or Response: filterDirection="in" or "out... It then needed to be changed to: "Enable to specify wheter a specific pattern defense should be enabled upon the Request or Response: filterDirection='in' or 'out'..." I deleted the other csv file as it was incomplete and re-attached the fixed one that should work for you called import_comma-fixed.csv. Please let us know how that works for you. - Cheers, Michelle [ Permlink | Delete | « Hide ] Konstantin Goldin [04/Dec/06 12:22 PM] Michelle, Thank you for this analysis, I will cleanse future bug dumps, and replace ' with ". However, this is a bug, so, while hotfix is not necessary at this time, I expect this to be fixed in the next patch or maintenance release. Please let me know what is a bug # tracking this case, and what release is it targeted for. Konstantin [ Show » ] Konstantin Goldin [04/Dec/06 12:22 PM] Michelle, Thank you for this analysis, I will cleanse future bug dumps, and replace ' with ". However, this is a bug, so, while hotfix is not necessary at this time, I expect this to be fixed in the next patch or maintenance release. Please let me know what is a bug # tracking this case, and what release is it targeted for. Konstantin Change by Konstantin Goldin [04/Dec/06 12:22 PM] Status Waiting For Customer [ 10000 ] Waiting For Atlassian [ 10004 ] Change by Michelle de Guzman [05/Dec/06 04:39 PM] Status Waiting For Atlassian [ 10004 ] Waiting For Customer [ 10000 ] [ Permlink | Delete | « Hide ] Michelle de Guzman [05/Dec/06 04:39 PM] Hi Konstantin, There are currently no bugs raised for this at present so would it be possible for you to raise this as one on http://jira.atlassian.com so that our developers are aware of it? You might want to reference this support issue number to them as well. Thanks, Michelle [ Show » ] Michelle de Guzman [05/Dec/06 04:39 PM] Hi Konstantin, There are currently no bugs raised for this at present so would it be possible for you to raise this as one on http://jira.atlassian.com so that our developers are aware of it? You might want to reference this support issue number to them as well. Thanks, Michelle

    Atlassian JIRA | 1 decade ago | Konstantin Goldin
    com.atlassian.jira.imports.csv.CsvImportException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank
  2. 0

    issue is tracked in JSP-8045. Attachments that repro the problem, and attachments with workaround are availiable in that support case. Details of support case are below. -------------------------------------------------------- I am trying to import attached file using import wizard. Get this stack: System Error A system error has occurred. If this problem persists - please notify your JIRA administrator of this problem. If you are an administrator, please try submitting this problem via the Support Request Page. Else, please create a support issue on our support system at http://support.atlassian.com with the following information: a description of your problem cut & paste the error and system information found below attach the application server log file (file:/opt/jira/atlassian-jira.log ) Cause: com.atlassian.jira.imports.csv.CsvImportException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank Stack Trace: [hide] com.atlassian.jira.imports.csv.CsvImportException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank at com.atlassian.jira.imports.csv.CsvConfigBean.(CsvConfigBean.java:171) at com.atlassian.jira.imports.csv.CsvConfigBean.createNewConfigBean(CsvConfigBean.java:907) at com.atlassian.jira.web.action.util.csv.ConfigureCsvMapping.doStart(ConfigureCsvMapping.java:113) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61) at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52) at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417) at webwork.action.ActionSupport.execute(ActionSupport.java:146) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:185) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) Referer URL: http://jira.reactivity.com/secure/admin/views/ConfigureCsvMapping!start.jspa Build Information: Uptime: N/A Edition: Enterprise Version: 3.6.4 Build Number: 160 Atlassian Partner: null Server Information: Application Server: Apache Tomcat/5.5.9 Servlet Version: 2.4 File Paths: Location of entityengine.xml: file:/opt/jira/atlassian-jira-enterprise-3.6.4-standalone/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log: file:/opt/jira/atlassian-jira.log Memory Information: Total Memory: 508 MB Free Memory: 90 MB Used Memory: 418 MB System Information: System Date: Monday, 20 Nov 2006 System Time: 14:33:06 Current Working Directory: /opt/jira Java Version: 1.4.2_04 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_04-b05 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: jira User Timezone: America/Los_Angeles User Locale: English (United States) System Encoding: UTF-8 Operating System: Linux 2.4.21-15.ELsmp OS Architecture: i386 Application Server Container: Database type: mysql Database JNDI address: java:comp/env/jdbc/JiraDS Database version: 3.23.58 Database driver: MySQL-AB JDBC Driver mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ ) Request Information: Request URL: http://jira.reactivity.com/500page.jsp * Scheme: http * Server: jira.reactivity.com * Port: 80 * URI: /500page.jsp * - Context Path: * - Servlet Path: /500page.jsp * - Path Info: null * - Query String: Request Attributes: * javax.servlet.forward.request_uri : /secure/admin/views/ConfigureCsvMapping!start.jspa * javax.servlet.forward.context_path : * javax.servlet.forward.servlet_path : /secure/admin/views/ConfigureCsvMapping!start.jspa * javax.servlet.forward.path_info : /500page.jsp * javax.servlet.error.message : * javax.servlet.error.exception : javax.servlet.ServletException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank * os_securityfilter_already_filtered : true * com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true * com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true * javax.servlet.error.request_uri : /secure/admin/views/ConfigureCsvMapping!start.jspa * jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@1c710a9 * javax.servlet.error.status_code : 500 * _sitemesh_filterapplied : true * jira.webwork.cleanup : false * javax.servlet.error.servlet_name : action * com.atlassian.jira.web.filters.gzip.GzipFilter_already_filtered : true * atlassian.core.seraph.original.url : /secure/admin/views/ConfigureCsvMapping!start.jspa * loginfilter.already.filtered : true * webwork.result : Value stack =========== =========== Request Logging: 0 log statements generated by this request: Description I am trying to import attached file using import wizard. Get this stack: System Error A system error has occurred. If this problem persists - please notify your JIRA administrator of this problem. If you are an administrator, please try submitting this problem via the Support Request Page. Else, please create a support issue on our support system at http://support.atlassian.com with the following information: a description of your problem cut & paste the error and system information found below attach the application server log file (file:/opt/jira/atlassian-jira.log ) Cause: com.atlassian.jira.imports.csv.CsvImportException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank Stack Trace: [hide] com.atlassian.jira.imports.csv.CsvImportException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank at com.atlassian.jira.imports.csv.CsvConfigBean.(CsvConfigBean.java:171) at com.atlassian.jira.imports.csv.CsvConfigBean.createNewConfigBean(CsvConfigBean.java:907) at com.atlassian.jira.web.action.util.csv.ConfigureCsvMapping.doStart(ConfigureCsvMapping.java:113) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61) at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52) at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417) at webwork.action.ActionSupport.execute(ActionSupport.java:146) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:185) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) Referer URL: http://jira.reactivity.com/secure/admin/views/ConfigureCsvMapping!start.jspa Build Information: Uptime: N/A Edition: Enterprise Version: 3.6.4 Build Number: 160 Atlassian Partner: null Server Information: Application Server: Apache Tomcat/5.5.9 Servlet Version: 2.4 File Paths: Location of entityengine.xml: file:/opt/jira/atlassian-jira-enterprise-3.6.4-standalone/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log: file:/opt/jira/atlassian-jira.log Memory Information: Total Memory: 508 MB Free Memory: 90 MB Used Memory: 418 MB System Information: System Date: Monday, 20 Nov 2006 System Time: 14:33:06 Current Working Directory: /opt/jira Java Version: 1.4.2_04 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_04-b05 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: jira User Timezone: America/Los_Angeles User Locale: English (United States) System Encoding: UTF-8 Operating System: Linux 2.4.21-15.ELsmp OS Architecture: i386 Application Server Container: Database type: mysql Database JNDI address: java:comp/env/jdbc/JiraDS Database version: 3.23.58 Database driver: MySQL-AB JDBC Driver mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ ) Request Information: Request URL: http://jira.reactivity.com/500page.jsp * Scheme: http * Server: jira.reactivity.com * Port: 80 * URI: /500page.jsp * - Context Path: * - Servlet Path: /500page.jsp * - Path Info: null * - Query String: Request Attributes: * javax.servlet.forward.request_uri : /secure/admin/views/ConfigureCsvMapping!start.jspa * javax.servlet.forward.context_path : * javax.servlet.forward.servlet_path : /secure/admin/views/ConfigureCsvMapping!start.jspa * javax.servlet.forward.path_info : /500page.jsp * javax.servlet.error.message : * javax.servlet.error.exception : javax.servlet.ServletException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank * os_securityfilter_already_filtered : true * com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true * com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true * javax.servlet.error.request_uri : /secure/admin/views/ConfigureCsvMapping!start.jspa * jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@1c710a9 * javax.servlet.error.status_code : 500 * _sitemesh_filterapplied : true * jira.webwork.cleanup : false * javax.servlet.error.servlet_name : action * com.atlassian.jira.web.filters.gzip.GzipFilter_already_filtered : true * atlassian.core.seraph.original.url : /secure/admin/views/ConfigureCsvMapping!start.jspa * loginfilter.already.filtered : true * webwork.result : Value stack =========== =========== Request Logging: 0 log statements generated by this request: Show » All Comments Work Log Change History Sort Order: [Ascending order - Click to sort in descending order] Change by Konstantin Goldin [20/Nov/06 04:37 PM] Field Original Value New Value Attachment import.csv [ 24313 ] Change by Konstantin Goldin [20/Nov/06 04:52 PM] Attachment import_comma.csv [ 24314 ] [ Permlink | Delete | « Hide ] Konstantin Goldin [20/Nov/06 04:52 PM] changing file from tab delimitered to comma delimetered does not help - still get a crach [ Show » ] Konstantin Goldin [20/Nov/06 04:52 PM] changing file from tab delimitered to comma delimetered does not help - still get a crach Change by Michelle de Guzman [28/Nov/06 07:34 PM] Assignee Michelle de Guzman [ michelle@atlassian.com ] Status Open [ 1 ] Waiting For Customer [ 10000 ] [ Permlink | Delete | « Hide ] Michelle de Guzman [28/Nov/06 07:34 PM] Hi Konstantin, The attached csv file works for me. - Cheers, Michelle [ Show » ] Michelle de Guzman [28/Nov/06 07:34 PM] Hi Konstantin, The attached csv file works for me. - Cheers, Michelle Change by Michelle de Guzman [28/Nov/06 07:34 PM] Attachment test.csv [ 24518 ] [ Permlink | Delete | « Hide ] Konstantin Goldin [29/Nov/06 07:38 PM] Michelle, I am glad that you have found a workaround. However, I will be receiving a lot more files of this format, and I will not be able to send all of them to support for clensing. What was wrong with this file? I have imported many other csv files, and they worked perfectly. So, I need to know exactly what was so special, what to avoid, etc. Appreciate your help. Konstantin [ Show » ] Konstantin Goldin [29/Nov/06 07:38 PM] Michelle, I am glad that you have found a workaround. However, I will be receiving a lot more files of this format, and I will not be able to send all of them to support for clensing. What was wrong with this file? I have imported many other csv files, and they worked perfectly. So, I need to know exactly what was so special, what to avoid, etc. Appreciate your help. Konstantin Change by Konstantin Goldin [29/Nov/06 07:38 PM] Status Waiting For Customer [ 10000 ] Waiting For Atlassian [ 10004 ] Change by Michelle de Guzman [03/Dec/06 09:22 PM] Attachment test.csv [ 24518 ] Change by Michelle de Guzman [03/Dec/06 09:22 PM] Attachment import_comma-fixed.csv [ 24635 ] Change by Michelle de Guzman [03/Dec/06 09:27 PM] Status Waiting For Atlassian [ 10004 ] Waiting For Customer [ 10000 ] [ Permlink | Delete | « Hide ] Michelle de Guzman [03/Dec/06 09:27 PM] Hi Konstantin, The problems were these entries below: When it is turned on; large HTTP requests ("large" means that WS-Engine gets them not as a single chunk; but as many consequent ... This was then changed to: "When it is turned on; large HTTP requests ('large' means that WS-Engine gets them not as a single chunk; but as many consequent ...". It was having issues with double quotes and single quotes. This line in your CSV also needed to be changed due to the same reason: Enable to specify wheter a specific pattern defense should be enabled upon the Request or Response: filterDirection="in" or "out... It then needed to be changed to: "Enable to specify wheter a specific pattern defense should be enabled upon the Request or Response: filterDirection='in' or 'out'..." I deleted the other csv file as it was incomplete and re-attached the fixed one that should work for you called import_comma-fixed.csv. Please let us know how that works for you. - Cheers, Michelle [ Show » ] Michelle de Guzman [03/Dec/06 09:27 PM] Hi Konstantin, The problems were these entries below: When it is turned on; large HTTP requests ("large" means that WS-Engine gets them not as a single chunk; but as many consequent ... This was then changed to: "When it is turned on; large HTTP requests ('large' means that WS-Engine gets them not as a single chunk; but as many consequent ...". It was having issues with double quotes and single quotes. This line in your CSV also needed to be changed due to the same reason: Enable to specify wheter a specific pattern defense should be enabled upon the Request or Response: filterDirection="in" or "out... It then needed to be changed to: "Enable to specify wheter a specific pattern defense should be enabled upon the Request or Response: filterDirection='in' or 'out'..." I deleted the other csv file as it was incomplete and re-attached the fixed one that should work for you called import_comma-fixed.csv. Please let us know how that works for you. - Cheers, Michelle [ Permlink | Delete | « Hide ] Konstantin Goldin [04/Dec/06 12:22 PM] Michelle, Thank you for this analysis, I will cleanse future bug dumps, and replace ' with ". However, this is a bug, so, while hotfix is not necessary at this time, I expect this to be fixed in the next patch or maintenance release. Please let me know what is a bug # tracking this case, and what release is it targeted for. Konstantin [ Show » ] Konstantin Goldin [04/Dec/06 12:22 PM] Michelle, Thank you for this analysis, I will cleanse future bug dumps, and replace ' with ". However, this is a bug, so, while hotfix is not necessary at this time, I expect this to be fixed in the next patch or maintenance release. Please let me know what is a bug # tracking this case, and what release is it targeted for. Konstantin Change by Konstantin Goldin [04/Dec/06 12:22 PM] Status Waiting For Customer [ 10000 ] Waiting For Atlassian [ 10004 ] Change by Michelle de Guzman [05/Dec/06 04:39 PM] Status Waiting For Atlassian [ 10004 ] Waiting For Customer [ 10000 ] [ Permlink | Delete | « Hide ] Michelle de Guzman [05/Dec/06 04:39 PM] Hi Konstantin, There are currently no bugs raised for this at present so would it be possible for you to raise this as one on http://jira.atlassian.com so that our developers are aware of it? You might want to reference this support issue number to them as well. Thanks, Michelle [ Show » ] Michelle de Guzman [05/Dec/06 04:39 PM] Hi Konstantin, There are currently no bugs raised for this at present so would it be possible for you to raise this as one on http://jira.atlassian.com so that our developers are aware of it? You might want to reference this support issue number to them as well. Thanks, Michelle

    Atlassian JIRA | 1 decade ago | Konstantin Goldin
    com.atlassian.jira.imports.csv.CsvImportException: Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank

    Root Cause Analysis

    1. com.atlassian.jira.imports.csv.CsvImportException

      Second line (after header row) in CSV file '/home/kgoldin/import.csv' is blank

      at com.atlassian.jira.imports.csv.CsvConfigBean.<init>()
    2. com.atlassian.jira
      ConfigureCsvMapping.doStart
      1. com.atlassian.jira.imports.csv.CsvConfigBean.<init>(CsvConfigBean.java:171)
      2. com.atlassian.jira.imports.csv.CsvConfigBean.createNewConfigBean(CsvConfigBean.java:907)
      3. com.atlassian.jira.web.action.util.csv.ConfigureCsvMapping.doStart(ConfigureCsvMapping.java:113)
      3 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    4. webwork.util
      InjectionUtils.invoke
      1. webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61)
      2. webwork.util.InjectionUtils.invoke(InjectionUtils.java:52)
      2 frames
    5. webwork.action
      ActionSupport.execute
      1. webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417)
      2. webwork.action.ActionSupport.execute(ActionSupport.java:146)
      2 frames
    6. com.atlassian.jira
      JiraActionSupport.execute
      1. com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57)
      1 frame
    7. webwork.dispatcher
      GenericDispatcher.executeAction
      1. webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
      1 frame
    8. com.atlassian.jira
      JiraServletDispatcher.service
      1. com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:185)
      1 frame
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      1 frame
    10. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    11. com.atlassian.jira
      AccessLogFilter.doFilter
      1. com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51)
      1 frame
    12. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    13. Sitemesh
      PageFilter.doFilter
      1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
      2. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
      2 frames
    14. com.atlassian.jira
      SitemeshExcludePathFilter.doFilter
      1. com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38)
      1 frame
    15. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    16. com.atlassian.seraph
      SecurityFilter.doFilter
      1. com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182)
      1 frame
    17. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    18. com.atlassian.seraph
      LoginFilter.doFilter
      1. com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181)
      1 frame
    19. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    20. com.atlassian.util
      ProfilingFilter.doFilter
      1. com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      1 frame
    21. com.atlassian.jira
      ProfilingAndErrorFilter.doFilter
      1. com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:35)
      1 frame
    22. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    23. com.atlassian.jira
      ActionCleanupDelayFilter.doFilter
      1. com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:39)
      1 frame
    24. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    25. com.atlassian.johnson
      JohnsonFilter.doFilter
      1. com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91)
      1 frame
    26. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    27. com.atlassian.jira
      GzipFilter.doFilter
      1. com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72)
      1 frame
    28. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    29. com.atlassian.core
      AbstractEncodingFilter.doFilter
      1. com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
      1 frame
    30. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      8 frames
    31. Embedded GlassFish Web
      SocketConnection.runIt
      1. org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
      2. org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
      3. org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
      4. org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
      5. org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
      5 frames
    32. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      1 frame
    33. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame