Access denied error on excel exporter module

0
Hi Komrads, When using the excel exporter module, the access denied error appears in the console. See stacktrace bewlow. The module is working fine, when emulate cloud security is turned off. Any suggestions? java.lang.ExceptionInInitializerError: null at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:815) at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:85) at xlsreport.report.export.ExportExcel.buildExportFile(ExportExcel.java:76) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:166) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:36) 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:199) at com.mendix.core.component.InternalCore.execute(SourceFile:262) at com.mendix.hB.execute(SourceFile:42) at com.mendix.ik.a(SourceFile:47) at com.mendix.ij.a(SourceFile:193) at com.mendix.ij.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:199) at com.mendix.core.component.InternalCore.execute(SourceFile:262) at com.mendix.iW.a(SourceFile:135) at com.mendix.pj$g.apply$mcV$sp(SourceFile:294) at com.mendix.pj$g.apply(SourceFile:285) at com.mendix.pj$g.apply(SourceFile:285) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(SourceFile:158) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(SourceFile:36) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(SourceFile:160) at scala.util.Try$.apply(Try.scala:191) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:154) at akka.actor.Actor$class.aroundReceive(Actor.scala:465) at com.mendix.core.session.Worker.aroundReceive(SourceFile:147) 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: java.security.AccessControlException: access denied ("java.util.PropertyPermission" "HSSFSheet.RowInitialCapacity" "read") at java.security.AccessControlContext.checkPermission(AccessControlContext.java:372) at java.security.AccessController.checkPermission(AccessController.java:559) at java.lang.SecurityManager.checkPermission(SecurityManager.java:549) at java.lang.SecurityManager.checkPropertyAccess(SecurityManager.java:1298) at java.lang.System.getProperty(System.java:708) at org.apache.poi.util.Configurator.getIntValue(Configurator.java:28) at org.apache.poi.hssf.usermodel.HSSFSheet.<clinit>(HSSFSheet.java:69) at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:815) at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:85) at xlsreport.report.export.ExportExcel.buildExportFile(ExportExcel.java:76) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:166) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:36) 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:199) at com.mendix.core.component.InternalCore.execute(SourceFile:262) at com.mendix.hB.execute(SourceFile:42) at com.mendix.ik.a(SourceFile:47) at com.mendix.ij.a(SourceFile:193) at com.mendix.ij.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:199) at com.mendix.core.component.InternalCore.execute(SourceFile:262) at com.mendix.iW.a(SourceFile:135) at com.mendix.pj$g.apply$mcV$sp(SourceFile:294) at com.mendix.pj$g.apply(SourceFile:285) at com.mendix.pj$g.apply(SourceFile:285) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(SourceFile:158) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(SourceFile:36) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(SourceFile:160) at scala.util.Try$.apply(Try.scala:191) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:154) at akka.actor.Actor$class.aroundReceive(Actor.scala:465) at com.mendix.core.session.Worker.aroundReceive(SourceFile:147) 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

That particular permission is actually already available in the Mendix Cloud and you'll be able to run this module there. We're able to change the permissions there, but not for the modeler (obviously). Therefor, the modeler will always lag a big :(

I'd expect 5.10 to not throw this exception.

answered
1

In addition to achiel's message, if you disable the cloud security emulation you can continue developing. This will only affect your local changes.
All appstore modules developed by Mendix will work in the cloud, but as achiel mentioned the modeler might be behind in its configuration.

See this page from the reference guide for disabling cloud security

answered