ConcourseSuite Support - Discussion - Concursive Corporation

Back to topics

Discuss Data Import and Export

Error Importing

You need to be logged in to post messages

This question is unanswered

Error Importing

3/25/2008 12:07 PM EDT

By Mike Ippolito

I received the following error when importing a CSV file

Please report the following error to Concursive Corporation.
You may be able to hit the back button on your browser, review your selection, and try your request again.

The actual error is:

java.sql.SQLException: An I/O error occured while sending to the backend.
at org.aspcfs.modules.base.Import.insert(Unknown Source)
at org.aspcfs.modules.contacts.actions.SalesImports.executeCommandSave(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.darkhorseventures.framework.servlets.ControllerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)

the import was very large, 140mb csv file

Mike

1. 3/26/2008 1:17 PM EDT

By Lorraine Bittner

Hi Mike,

It looks like the Connection was closed while the data was being imported. This seems like the likely cause since you are importing such a large file. You can try either cutting up the file into 12 pieces and importing one at a time, or changing the max idle time on the connection pool.

If you look in the build.properties file in the fileLibrary you should find a line similar to the following:

CONNECTION_POOL.MAX_IDLE_TIME.SECONDS=60

You can bump this up to a high value (such as 20 minutes) for importing and then lower it back to normal when it's complete. The drawback is that tomcat (or whichever servlet container you use) will need to be restarted for the changes to take effect.

1 result found