Issue while uploading file to Excel Importer V8.1.1

0
We started getting this issue since last two weeks. When we are uploading the file in Excel Importer, the file is not being saved and is giving a timeout exception. After couple of trials the file gets saved with same data. Not sure why this issue  started suddenly. We also tried upgrading to new version of Excel Importer V 8.2.1, but still we are getting same issue. Can someone help in resolving the issue. Uploading file failed: java.util.concurrent.TimeoutException: Idle timeout expired: 30002/30000 ms [User 'TA' with session id '3990c841-XXXX-XXXX-XXXX-XXXXXXXXf61f' and roles 'XX'] -------- java.io.IOException: java.util.concurrent.TimeoutException: Idle timeout expired: 30002/30000 ms     at org.eclipse.jetty.server.HttpInput$ErrorState.noContent(HttpInput.java:1083)     at org.eclipse.jetty.server.HttpInput.read(HttpInput.java:321)     at org.apache.commons.fileupload.MultipartStream$ItemInputStream.makeAvailable(MultipartStream.java:1027)     at org.apache.commons.fileupload.MultipartStream$ItemInputStream.read(MultipartStream.java:931)     at java.base/java.io.InputStream.read(InputStream.java:205)     at org.apache.commons.fileupload.util.Streams.copy(Streams.java:98)     at org.apache.commons.fileupload.util.Streams.copy(Streams.java:68)     at org.apache.commons.fileupload.MultipartStream.readBodyData(MultipartStream.java:622)     at org.apache.commons.fileupload.MultipartStream.discardBodyData(MultipartStream.java:646)     at org.apache.commons.fileupload.MultipartStream.skipPreamble(MultipartStream.java:664)     at org.apache.commons.fileupload.FileUploadBase$FileItemIteratorImpl.findNextItem(FileUploadBase.java:1037)     at org.apache.commons.fileupload.FileUploadBase$FileItemIteratorImpl.<init>(FileUploadBase.java:1017)     at org.apache.commons.fileupload.FileUploadBase.getItemIterator(FileUploadBase.java:309)     at org.apache.commons.fileupload.servlet.ServletFileUpload.getItemIterator(ServletFileUpload.java:152)     at com.mendix.webui.requesthandling.FileRequestHandler.readFilePartsFromRequest(FileRequestHandler.scala:188)     at com.mendix.webui.requesthandling.FileRequestHandler.doUpload(FileRequestHandler.scala:128)     at com.mendix.webui.requesthandling.FileRequestHandler.handleUpload(FileRequestHandler.scala:83)     at com.mendix.webui.requesthandling.FileRequestHandler.handleRequest(FileRequestHandler.scala:68)     at com.mendix.webui.requesthandling.FileRequestHandler.processRequest(FileRequestHandler.scala:61)     at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:46)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:76)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:73)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:26)     at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.java:79)     at com.mendix.basis.impl.MxRuntimeImplBase.processRequest(MxRuntimeImplBase.java:894)     at com.mendix.m2ee.appcontainer.server.handler.RuntimeServlet.service(RuntimeServlet.java:42)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)     at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763)     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1631)     at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226)     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618)     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)     at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1610)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1369)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:489)     at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1580)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1284)     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)     at org.eclipse.jetty.server.Server.handle(Server.java:501)     at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)     at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)     at org.eclipse.jetty.server.HttpChannel.run(HttpChannel.java:335)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)     at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)     at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.util.concurrent.TimeoutException: Idle timeout expired: 30002/30000 ms     at org.eclipse.jetty.io.IdleTimeout.checkIdleTimeout(IdleTimeout.java:171)     at org.eclipse.jetty.io.IdleTimeout.idleCheck(IdleTimeout.java:113)     at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)     at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)     at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)     at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)     at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)     at java.base/java.lang.Thread.run(Thread.java:834)  
asked
1 answers
0

From the error, it looks like the file is at a size where it's just at or under the timeout limit. Since it's so close to the limit, it will sometimes work and sometimes fail depending on exactly how fast the file is processed. 30 seconds is quite long for an import though – are you kicking off any flows during your import? Otherwise it might be worth importing the file as “flat” data first and separating any processing of the info into a separate process.

answered