Excel Export Issue

0
Hi  I am having an issue exporting data to excel from data grid 2.  I am having both tables DG1 and DG2. Data grid 1 is allowing to export the data to excel using DataSource as X-path.   When I am using Excel export to export the data, i am geeting Error saying – Please Contact the administrator. I am selected Excel 2007 and above Date format – dd-mm-yyyy    Kindly suggest me if there is any better approach or what i am doing wrong.     error 1 java.nio.channels.ClosedChannelException -------- java.io.IOException: java.nio.channels.ClosedChannelException     at org.eclipse.jetty.util.FutureCallback.block(FutureCallback.java:163)     at org.eclipse.jetty.util.FutureCallback.block(FutureCallback.java:139)     at org.eclipse.jetty.websocket.javax.common.JavaxWebSocketBasicRemote.sendText(JavaxWebSocketBasicRemote.java:120)     at com.mendix.webui.requesthandling.DevtoolsEndpoint.$anonfun$send$5(DevtoolsEndpoint.scala:61)     at com.mendix.webui.requesthandling.DevtoolsEndpoint.$anonfun$send$5$adapted(DevtoolsEndpoint.scala:60)     at scala.collection.IterableOnceOps.foreach(IterableOnce.scala:575)     at scala.collection.IterableOnceOps.foreach$(IterableOnce.scala:573)     at scala.collection.AbstractIterable.foreach(Iterable.scala:933)     at com.mendix.webui.requesthandling.DevtoolsEndpoint.send(DevtoolsEndpoint.scala:60)     at com.mendix.webui.requesthandling.DevtoolsEndpoint.broadcastInstruction(DevtoolsEndpoint.scala:37)     at com.mendix.webui.internal.WebUIImpl.$anonfun$handleRuntimeBeforeRunningEvent$2(WebUIImpl.scala:255)     at com.mendix.webui.internal.WebUIImpl.$anonfun$handleRuntimeBeforeRunningEvent$2$adapted(WebUIImpl.scala:255)     at com.mendix.webui.debugger.NanoflowDebuggerImpl.broadcastBreakpoints(NanoflowDebuggerImpl.scala:182)     at com.mendix.webui.debugger.NanoflowDebuggerImpl.startSession(NanoflowDebuggerImpl.scala:40)     at com.mendix.modules.debugger.DebuggerImpl.$anonfun$startSession$1(DebuggerImpl.scala:26)     at scala.collection.immutable.List.foreach(List.scala:333)     at com.mendix.modules.debugger.DebuggerImpl.startSession(DebuggerImpl.scala:26)     at com.mendix.modules.debugger.internal.DebuggerHandler.processJsonRequest(DebuggerHandler.scala:105)     at com.mendix.modules.debugger.internal.DebuggerHandler.doProcessRequest(DebuggerHandler.scala:50)     at com.mendix.external.connector.MxRuntimeConnector.$anonfun$processRequest$1(MxRuntimeConnector.scala:54)     at com.mendix.external.connector.MxRuntimeConnector.$anonfun$processRequest$1$adapted(MxRuntimeConnector.scala:54)     at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)     at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.scala:54)     at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.scala:221)     at com.mendix.m2ee.appcontainer.server.handler.RuntimeServlet.service(RuntimeServlet.scala:40)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)     at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)     at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1665)     at org.eclipse.jetty.websocket.servlet.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:170)     at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:202)     at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1635)     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:527)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)     at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1570)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1385)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)     at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1543)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1307)     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)     at org.eclipse.jetty.server.Server.handle(Server.java:563)     at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505)     at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)     at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:416)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:385)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:272)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.produce(AdaptiveExecutionStrategy.java:194)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:936)     at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1080)     at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.nio.channels.ClosedChannelException: null     at org.eclipse.jetty.websocket.core.internal.WebSocketSessionState.onOutgoingFrame(WebSocketSessionState.java:184)     at org.eclipse.jetty.websocket.core.internal.WebSocketCoreSession.sendFrame(WebSocketCoreSession.java:514)     at org.eclipse.jetty.websocket.javax.common.JavaxWebSocketRemoteEndpoint.sendFrame(JavaxWebSocketRemoteEndpoint.java:141)     at org.eclipse.jetty.websocket.javax.common.JavaxWebSocketBasicRemote.sendText(JavaxWebSocketBasicRemote.java:119)     at com.mendix.webui.requesthandling.DevtoolsEndpoint.$anonfun$send$5(DevtoolsEndpoint.scala:61)     at com.mendix.webui.requesthandling.DevtoolsEndpoint.$anonfun$send$5$adapted(DevtoolsEndpoint.scala:60)     at scala.collection.IterableOnceOps.foreach(IterableOnce.scala:575)     at scala.collection.IterableOnceOps.foreach$(IterableOnce.scala:573)     at scala.collection.AbstractIterable.foreach(Iterable.scala:933)     at com.mendix.webui.requesthandling.DevtoolsEndpoint.send(DevtoolsEndpoint.scala:60)     at com.mendix.webui.requesthandling.DevtoolsEndpoint.broadcastInstruction(DevtoolsEndpoint.scala:37)     at com.mendix.webui.internal.WebUIImpl.$anonfun$handleRuntimeBeforeRunningEvent$2(WebUIImpl.scala:255)     at com.mendix.webui.internal.WebUIImpl.$anonfun$handleRuntimeBeforeRunningEvent$2$adapted(WebUIImpl.scala:255)     at com.mendix.webui.debugger.NanoflowDebuggerImpl.broadcastBreakpoints(NanoflowDebuggerImpl.scala:182)     at com.mendix.webui.debugger.NanoflowDebuggerImpl.startSession(NanoflowDebuggerImpl.scala:40)     at com.mendix.modules.debugger.DebuggerImpl.$anonfun$startSession$1(DebuggerImpl.scala:26)     at scala.collection.immutable.List.foreach(List.scala:333)     at com.mendix.modules.debugger.DebuggerImpl.startSession(DebuggerImpl.scala:26)     at com.mendix.modules.debugger.internal.DebuggerHandler.processJsonRequest(DebuggerHandler.scala:105)     at com.mendix.modules.debugger.internal.DebuggerHandler.doProcessRequest(DebuggerHandler.scala:50)     at com.mendix.external.connector.MxRuntimeConnector.$anonfun$processRequest$1(MxRuntimeConnector.scala:54)     at com.mendix.external.connector.MxRuntimeConnector.$anonfun$processRequest$1$adapted(MxRuntimeConnector.scala:54)     at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)     at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.scala:54)     at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.scala:221)     at com.mendix.m2ee.appcontainer.server.handler.RuntimeServlet.service(RuntimeServlet.scala:40)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)     at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)     at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1665)     at org.eclipse.jetty.websocket.servlet.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:170)     at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:202)     at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1635)     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:527)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)     at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1570)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1385)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)     at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1543)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1307)     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)     at org.eclipse.jetty.server.Server.handle(Server.java:563)     at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505)     at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)     at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:416)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:385)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:272)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.produce(AdaptiveExecutionStrategy.java:194)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:936)     at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1080)     at java.base/java.lang.Thread.run(Thread.java:829)   Error -2 Internal server error Error: Internal server error         at m (http://localhost:8081/mxclientsystem/mxui/mxui.js?638225277137022090:66:22652)     at async http://localhost:8081/mxclientsystem/mxui/mxui.js?638225277137022090:66:5606     at async a (http://localhost:8081/mxclientsystem/mxui/mxui.js?638225277137022090:66:20766)     at async g (http://localhost:8081/mxclientsystem/mxui/mxui.js?638225277137022090:66:22126)     at async http://localhost:8081/mxclientsystem/mxui/mxui.js?638225277137022090:66:55096     at async g.executeMicroflow (http://localhost:8081/mxclientsystem/mxui/mxui.js?638225277137022090:64:28834)     at async http://localhost:8081/mxclientsystem/mxui/mxui.js?638225277137022090:64:5870    
asked
0 answers