Export to excel not working?

0
The Export to excel functionality isnt working for one of the data grids, however its working fine for all the other data grids within the application. mendix version 5.15.1. Can anyone let me know what the issue could be? java.util.concurrent.ExecutionException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{}', all database changes executed by this action were rolled back at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:188) at com.mendix.webui.actions.client.PollBackgroundJobAction.handleJobCompletion(PollBackgroundJobAction.scala:56) at com.mendix.webui.actions.client.PollBackgroundJobAction.execute(PollBackgroundJobAction.scala:30) at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:300) at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293) at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:151) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(ActionDispatching.scala:153) at scala.util.Try$.apply(Try.scala:191) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(ActionDispatching.scala:147) at akka.actor.Actor$class.aroundReceive(Actor.scala:465) at com.mendix.core.session.Worker.aroundReceive(ActionDispatching.scala:140) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516) at akka.actor.ActorCell.invoke(ActorCell.scala:487) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238) at akka.dispatch.Mailbox.run(Mailbox.scala:220) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{}', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.CoreAction.processErrorState(CoreAction.java:343) Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.rangeCheck(ArrayList.java:635) at java.util.ArrayList.get(ArrayList.java:411) at com.mendix.webui.actions.client.ExportDataFormatter.getReferenceValue(ExportDataFormatter.java:115) at com.mendix.webui.actions.client.ExportDataFormatter.getReferenceValue(ExportDataFormatter.java:159) at com.mendix.webui.actions.client.ExportDataFormatter.getRowValues(ExportDataFormatter.java:73) at com.mendix.webui.actions.client.ExportAction.generateExcelData(ExportAction.java:303) at com.mendix.webui.actions.client.ExportAction.exportToExcel(ExportAction.java:254) at com.mendix.webui.actions.client.ExportAction.exportGrid(ExportAction.java:112) at com.mendix.webui.actions.client.ExportAction.access$100(ExportAction.java:60) at com.mendix.webui.actions.client.ExportAction$ExportCoreAction.execute(ExportAction.java:405) at com.mendix.webui.actions.client.ExportAction$ExportCoreAction.execute(ExportAction.java:382) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:291) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:276) at com.mendix.core.actionmanagement.CustomActionMonitorImpl$$anonfun$run$1.apply(CustomMonitoredAction.scala:17) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:151) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(ActionDispatching.scala:153) at scala.util.Try$.apply(Try.scala:191) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(ActionDispatching.scala:147) at akka.actor.Actor$class.aroundReceive(Actor.scala:465) at com.mendix.core.session.Worker.aroundReceive(ActionDispatching.scala:140) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516) at akka.actor.ActorCell.invoke(ActorCell.scala:487) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238) at akka.dispatch.Mailbox.run(Mailbox.scala:220) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
asked
2 answers
1

This should not be happening. There must be something strange in the data itself. I would file a support ticket with your model and the database with steps on how to reproduce this error. If that is a problem you should remove a column at the time to see which part is causing the problems. From the stacktrace it looks like a referenced object, so I would start with those. Any change a calculated object in there?

Regards,

Ronald

answered
0

Make sure the data source type of the datagrid is XPATH

answered