Excel Importer Error - Mx5

4
I am trying to use the Excel Importer in Mendix 5. When I try to import a file, I get the following error: Uncaught fatal error from thread [MxRuntimeSystem-akka.actor.action-dispatcher-39] shutting down ActorSystem [MxRuntimeSystem] -------- java.lang.NoClassDefFoundError: javax/xml/namespace/QName at java.lang.Class.getDeclaredMethods0(Native Method) at java.lang.Class.privateGetDeclaredMethods(Class.java:2442) at java.lang.Class.getMethod0(Class.java:2685) at java.lang.Class.getMethod(Class.java:1620) at org.apache.xmlbeans.XmlBeans.buildMethod(XmlBeans.java:174) at org.apache.xmlbeans.XmlBeans.buildNoArgMethod(XmlBeans.java:190) at org.apache.xmlbeans.XmlBeans.buildGetContextTypeLoaderMethod(XmlBeans.java:200) at org.apache.xmlbeans.XmlBeans.<clinit>(XmlBeans.java:126) at org.openxmlformats.schemas.spreadsheetml.x2006.main.StyleSheetDocument$Factory.parse(Unknown Source) at org.apache.poi.xssf.model.StylesTable.readFrom(StylesTable.java:102) at org.apache.poi.xssf.model.StylesTable.<init>(StylesTable.java:91) at org.apache.poi.xssf.eventusermodel.XSSFReader.getStylesTable(XSSFReader.java:85) at excelimporter.reader.readers.ExcelXLSXDataReader.readData(ExcelXLSXDataReader.java:41) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:409) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:123) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:54) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:25) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:271) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:206) at com.mendix.core.component.InternalCore.execute(SourceFile:262) at com.mendix.hq.execute(SourceFile:42) at com.mendix.if.a(SourceFile:44) at com.mendix.ie.a(SourceFile:190) at com.mendix.ie.executeAction(SourceFile:151) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:271) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:206) at com.mendix.core.component.InternalCore.execute(SourceFile:262) at com.mendix.jt.a(SourceFile:135) at com.mendix.pC.a(SourceFile:296) at com.mendix.pC$a.apply$mcI$sp(SourceFile:195) at com.mendix.pC$i.a(SourceFile:211) at com.mendix.pC$i.execute(SourceFile:208) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:132) 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 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) Caused by: java.lang.ClassNotFoundException: javax.xml.namespace.QName not found by project [85] 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:356) at java.lang.Class.getDeclaredMethods0(Native Method) at java.lang.Class.privateGetDeclaredMethods(Class.java:2442) at java.lang.Class.getMethod0(Class.java:2685) at java.lang.Class.getMethod(Class.java:1620) at org.apache.xmlbeans.XmlBeans.buildMethod(XmlBeans.java:174) at org.apache.xmlbeans.XmlBeans.buildNoArgMethod(XmlBeans.java:190) at org.apache.xmlbeans.XmlBeans.buildGetContextTypeLoaderMethod(XmlBeans.java:200) at org.apache.xmlbeans.XmlBeans.<clinit>(XmlBeans.java:126) at org.openxmlformats.schemas.spreadsheetml.x2006.main.StyleSheetDocument$Factory.parse(Unknown Source) at org.apache.poi.xssf.model.StylesTable.readFrom(StylesTable.java:102) at org.apache.poi.xssf.model.StylesTable.<init>(StylesTable.java:91) at org.apache.poi.xssf.eventusermodel.XSSFReader.getStylesTable(XSSFReader.java:85) at excelimporter.reader.readers.ExcelXLSXDataReader.readData(ExcelXLSXDataReader.java:41) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:409) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:123) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:54) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:25) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:271) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:206) at com.mendix.core.component.InternalCore.execute(SourceFile:262) at com.mendix.hq.execute(SourceFile:42) at com.mendix.if.a(SourceFile:44) at com.mendix.ie.a(SourceFile:190) at com.mendix.ie.executeAction(SourceFile:151) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:271) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:206) at com.mendix.core.component.InternalCore.execute(SourceFile:262) at com.mendix.jt.a(SourceFile:135) at com.mendix.pC.a(SourceFile:296) at com.mendix.pC$a.apply$mcI$sp(SourceFile:195) at com.mendix.pC$i.a(SourceFile:211) at com.mendix.pC$i.execute(SourceFile:208) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:132) 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 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) Any pointers for me about what the error may be and how to resolve this?
asked
5 answers
4

A further update:

I received notice yesterday that this problem had been corrected for all of my public cloud deployed applications. Upon restarting my apps, I can now successfully import xlsx files. Mx Support indicated that the fix has not yet been included in the Modeler, so to eliminate this error for locally deployed applications, cloud security still needs to be disabled. The fix will be included in future Modeler versions, so read those release notes carefully!

Thanks to Bart Luitjen and everyone else at Mx support for resolving this issue!

Mike

answered
2

Alistair,

Still in the midst of working through this with Mendix support. I did make some forward progress with a lot of assistance from Marc Lehane at Mendix. Marc walked me through removing Model Reflection and Excel Importer from the project, deleting all of the files in the userlib directory of my project, and then reimporting both Model Reflection and Excel Importer. This resolved the hard crash I was experiencing. Where things stand currently is that Excel Importer still gives an error, but it is a classloader error and doesn't require a reboot of the Mendix server, as the previous error did. Mx Support is looking into the classloader error currently. In the Modeler, if I turn off emulate cloud security, Excel Importer works fine.

I will update you as we make progress.

Sorry for a new answer, just didn't have room for all of that in a comment.

Mike

answered
1

Just wanted to add in that we are now also experiencing trouble because of this issue. In fact, the errors occur even when trying to create a template based on an excel file already.

Hard errors. Require a complete restart of the modeler. Quite nasty.

java.lang.NoClassDefFoundError: javax/xml/namespace/QName
answered
1

The issue seems to be caused by .XLSX, I've been successful in making everything work when dealing with only .XLS files.

answered
0

Querijn

Have you tried removing Excel Importer and Model Reflection modules, deleting all contents of the Userlib directory in your project and then re-loading the Model Reflection and Excel Importer modules? This resolved the hard crash I experienced that produced identical error messages to the ones you have shown above.

Mike

answered