Error in Excel Exporter appstore module

0
Defining a simple Excel export template always leads to an error when running the report ('create report button') when defined as Excel export. Creating a similar template for export to CSV works fine. Tried this on several object, all with the same result. What am I doing wrong? Stacktrace: An error has occurred while handling the request. [User 'Anonymous_3434a3ea-0d35-4f74-9391-a5166e0b2ab8' with session id 'fc5c0a3a-24a4-4068-9dad-f89f602be3db' and roles 'Administrator'] com.mendix.modules.microflowengine.MicroflowException: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreException: Cannot create excel, because the inputobject isn't given. Expect: MIS.Gebruik at XLSReport.GenerateReport (JavaAction : 'Call 'GenerateExcelDoc'') Advanced stacktrace: at com.mendix.modules.microflowengine.MicroflowUtil.processException(SourceFile:158) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreException: Cannot create excel, because the inputobject isn't given. Expect: MIS.Gebruik at com.mendix.core.component.InternalCore.execute(SourceFile:271) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreException: Cannot create excel, because the inputobject isn't given. Expect: MIS.Gebruik at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:216) Caused by: com.mendix.core.CoreException: Cannot create excel, because the inputobject isn't given. Expect: MIS.Gebruik at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:73) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:37) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:205) at com.mendix.core.component.InternalCore.execute(SourceFile:259) at com.mendix.hs.execute(SourceFile:42) at com.mendix.ib.a(SourceFile:47) at com.mendix.ia.a(SourceFile:193) at com.mendix.ia.executeAction(SourceFile:148) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:205) at com.mendix.core.component.InternalCore.execute(SourceFile:259) at com.mendix.iO.a(SourceFile:135) at com.mendix.pa$g.apply$mcV$sp(SourceFile:292) at com.mendix.pa$g.apply(SourceFile:283) at com.mendix.pa$g.apply(SourceFile:283) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(SourceFile:148) at scala.util.Try$.apply(Try.scala:161) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:146) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:498) at akka.actor.ActorCell.invoke(ActorCell.scala:456) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:237) at akka.dispatch.Mailbox.run(Mailbox.scala:219) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:386) 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
4 answers
1

It looks like the dom4j-1.6.1.jar is missing which is part of the ExcelImporter module. Is this jar included in your project? You can redownload the ExcelImporter module to obtain this library.

answered
0

The error says "Cannot create excel, because the inputobject isn't given. Expect: MIS.Gebruik", did you pass a "MIS.Gebruik" Object to the export java action?

answered
0

No I didn't pass an Object. Wat is the meaning of this parameter (not documented in the java action)? When I pass a MIS.Gebruik object i get another error:

Uncaught fatal error from thread [MxRuntimeSystem-akka.actor.action-dispatcher-7] shutting down ActorSystem [MxRuntimeSystem]

java.lang.NoClassDefFoundError: org/dom4j/DocumentException at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:149) at org.apache.poi.openxml4j.opc.OPCPackage.<init>(OPCPackage.java:136) at org.apache.poi.openxml4j.opc.Package.<init>(Package.java:54) at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:66) at org.apache.poi.openxml4j.opc.OPCPackage.create(OPCPackage.java:276) at org.apache.poi.xssf.usermodel.XSSFWorkbook.newPackage(XSSFWorkbook.java:269) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:158) at xlsreport.report.export.ExportExcel.<init>(ExportExcel.java:52) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:89) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:37) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:205) at com.mendix.core.component.InternalCore.execute(SourceFile:259) at com.mendix.hs.execute(SourceFile:42) at com.mendix.ib.a(SourceFile:47) at com.mendix.ia.a(SourceFile:193) at com.mendix.ia.executeAction(SourceFile:148) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:205) at com.mendix.core.component.InternalCore.execute(SourceFile:259) at com.mendix.iO.a(SourceFile:135) at com.mendix.pa$g.apply$mcV$sp(SourceFile:292) at com.mendix.pa$g.apply(SourceFile:283) at com.mendix.pa$g.apply(SourceFile:283) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(SourceFile:148) at scala.util.Try$.apply(Try.scala:161) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:146) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:498) at akka.actor.ActorCell.invoke(ActorCell.scala:456) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:237) at akka.dispatch.Mailbox.run(Mailbox.scala:219) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:386) 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: java.lang.ClassNotFoundException: org.dom4j.DocumentException not found by project [87] at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1532) at org.apache.felix.framework.BundleWiringImpl.access$400(BundleWiringImpl.java:75) at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.loadClass(BundleWiringImpl.java:1955) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:149) at org.apache.poi.openxml4j.opc.OPCPackage.<init>(OPCPackage.java:136) at org.apache.poi.openxml4j.opc.Package.<init>(Package.java:54) at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:66) at org.apache.poi.openxml4j.opc.OPCPackage.create(OPCPackage.java:276) at org.apache.poi.xssf.usermodel.XSSFWorkbook.newPackage(XSSFWorkbook.java:269) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:158) at xlsreport.report.export.ExportExcel.<init>(ExportExcel.java:52) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:89) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:37) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:205) at com.mendix.core.component.InternalCore.execute(SourceFile:259) at com.mendix.hs.execute(SourceFile:42) at com.mendix.ib.a(SourceFile:47) at com.mendix.ia.a(SourceFile:193) at com.mendix.ia.executeAction(SourceFile:148) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:205) at com.mendix.core.component.InternalCore.execute(SourceFile:259) at com.mendix.iO.a(SourceFile:135) at com.mendix.pa$g.apply$mcV$sp(SourceFile:292) at com.mendix.pa$g.apply(SourceFile:283) at com.mendix.pa$g.apply(SourceFile:283) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(SourceFile:148) at scala.util.Try$.apply(Try.scala:161) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:146) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:498) at akka.actor.ActorCell.invoke(ActorCell.scala:456) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:237) at akka.dispatch.Mailbox.run(Mailbox.scala:219) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:386) 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)

answered
0

Imported the Excel Importer module as well and it works fine now, Thanks !!!

Didn't know the Excel Importer module is mandatory for using the Excel Exporter module ;)

answered