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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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