Question

Excel importer - Error, need help debugging.

1

Is there anyone that can help me figure out how to fix this? Mendix version used 5.15.1 ( Version wasn't selectable on forums sorry ) Tried importing an .xls and .xlsx file both return a different error. XLS input error: Invalid byte 2 of 2-byte UTF-8 sequence. at org.apache.xerces.impl.io.UTF8Reader.invalidByte(Unknown Source) at org.apache.xerces.impl.io.UTF8Reader.read(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.skipString(Unknown Source) at org.apache.xerces.impl.XMLVersionDetector.determineDocVersion(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at com.mendix.integration.xmlimporter.XmlImporter.importXmlStream(XmlImporter.java:87) at com.mendix.integration.xmlimporter.XmlImporter.importXmlStream(XmlImporter.java:54) at com.mendix.integration.internal.InternalIntegrationImpl.importXmlStream(InternalIntegrationImpl.scala:235) at com.mendix.integration.actions.microflow.ImportXMLAction.execute(ImportXMLAction.scala:33) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:49) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:196) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:151) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:53) 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.ActionManager$1.execute(ActionManager.java:204) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:199) at com.mendix.core.component.InternalCore.execute(InternalCore.java:228) at com.mendix.webui.actions.client.ExecuteAction.execute(ExecuteAction.java:135) 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) XLSX error: The mapping from XML to Domain throwed an error. Be sure the MxModelReflection and selected DB is synchronized. LastErrorMessage: Content is not allowed in prolog.. LastErrorStackTraceorg.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog. at com.mendix.integration.xmlimporter.XmlImporter.processSAXException(XmlImporter.java:173) Caused by: Content is not allowed in prolog. at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at com.mendix.integration.xmlimporter.XmlImporter.importXmlStream(XmlImporter.java:87) at com.mendix.integration.xmlimporter.XmlImporter.importXmlStream(XmlImporter.java:54) at com.mendix.integration.internal.InternalIntegrationImpl.importXmlStream(InternalIntegrationImpl.scala:235) at com.mendix.integration.actions.microflow.ImportXMLAction.execute(ImportXMLAction.scala:33) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:49) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:196) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:151) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:53) 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.ActionManager$1.execute(ActionManager.java:204) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:199) at com.mendix.core.component.InternalCore.execute(InternalCore.java:228) at com.mendix.webui.actions.client.ExecuteAction.execute(ExecuteAction.java:135) 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)

asked 2015-05-08

Marnix Puijker

7 answers

Ronald Catersels · Answer 1 · 2015-05-08

Could this stackoverflow question be your answer? http://stackoverflow.com/questions/2421272/invalid-byte-2-of-2-byte-utf-8-sequence

Regards,

Ronald

Marnix Puijker · Answer 2 · 2015-05-11

At least i got the import running now. But im getting the following error and do not understand what it means or what causes this.

com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: XLS_DATA-2ndPass: an exception occured near row: 1002, the exception is: replication.ReplicationSettings$MendixReplicationRuntimeException: null | VERSION: Mx5_20150416
    at com.mendix.core.component.InternalCore.execute(InternalCore.java:236)

Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: XLS_DATA-2ndPass: an exception occured near row: 1002, the exception is: replication.ReplicationSettings$MendixReplicationRuntimeException: null | VERSION: Mx5_20150416
    at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:217)

Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: XLS_DATA-2ndPass: an exception occured near row: 1002, the exception is: replication.ReplicationSettings$MendixReplicationRuntimeException: null | VERSION: Mx5_20150416
    at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:43)

Caused by: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: XLS_DATA-2ndPass: an exception occured near row: 1002, the exception is: replication.ReplicationSettings$MendixReplicationRuntimeException: null | VERSION: Mx5_20150416
    at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:133)

Caused by: com.mendix.core.CoreException: Document could not be imported, because: XLS_DATA-2ndPass: an exception occured near row: 1002, the exception is: replication.ReplicationSettings$MendixReplicationRuntimeException: null | VERSION: Mx5_20150416
    at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:454)

Caused by: excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener$ExcelRuntimeException: XLS_DATA-2ndPass: an exception occured near row: 1002, the exception is: replication.ReplicationSettings$MendixReplicationRuntimeException: null | VERSION: Mx5_20150416
    at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:284)
    at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:105)
    at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord(HSSFRequest.java:110)
    at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:144)
    at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:103)
    at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:423)
    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(UserAction.java:53)
    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.ActionManager$1.execute(ActionManager.java:204)
    at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37)
    at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:199)
    at com.mendix.core.component.InternalCore.execute(InternalCore.java:228)
    at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:46)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:49)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:196)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:151)
    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:53)
    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)

Caused by: replication.ReplicationSettings$MendixReplicationException: replication.ReplicationSettings$MendixReplicationRuntimeException: null | VERSION: Mx5_20150416
    at replication.MetaInfoProcessor.startProcessing(MetaInfoProcessor.java:81)

Caused by: replication.ReplicationSettings$MendixReplicationRuntimeException: null | VERSION: Mx5_20150416
    at replication.MetaInfoProcessor.retrieveMxObjectsByMetaInfoObject(MetaInfoProcessor.java:780)

Caused by: java.lang.NullPointerException: null
    at java.util.TreeMap.put(TreeMap.java:556)
    at java.util.TreeSet.add(TreeSet.java:255)
    at java.util.AbstractCollection.addAll(AbstractCollection.java:342)
    at java.util.TreeSet.addAll(TreeSet.java:312)
    at java.util.TreeSet.<init>(TreeSet.java:160)
    at replication.helpers.OQLBuilder.buildOQLQuery(OQLBuilder.java:60)
    at replication.MetaInfoProcessor.retrieveMxObjectsByMetaInfoObject(MetaInfoProcessor.java:679)
    at replication.MetaInfoProcessor.populateAssociatedObjects(MetaInfoProcessor.java:843)
    at replication.MetaInfoProcessor.storeChangedObjects(MetaInfoProcessor.java:123)
    at replication.MetaInfoProcessor.startProcessing(MetaInfoProcessor.java:66)
    at replication.MetaInfo.startProcessingObjects(MetaInfo.java:742)
    at replication.MetaInfo.prepareObject(MetaInfo.java:626)
    at replication.MetaInfo.setAssociationValue(MetaInfo.java:583)
    at excelimporter.reader.readers.ExcelRowProcessor.processValues(ExcelRowProcessor.java:64)
    at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:280)
    at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:105)
    at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord(HSSFRequest.java:110)
    at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:144)
    at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:103)
    at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:423)
    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(UserAction.java:53)
    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.ActionManager$1.execute(ActionManager.java:204)
    at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37)
    at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:199)
    at com.mendix.core.component.InternalCore.execute(InternalCore.java:228)
    at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:46)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:49)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:196)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:151)
    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:53)
    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)

The module throws back a no template error instead though.

Marnix Puijker · Answer 3 · 2015-05-11

The error above is the final error, there is another thrown error by Replication_MetaInfo

replication.ReplicationSettings$MendixReplicationRuntimeException: null | VERSION: Mx5_20150416
    at replication.MetaInfoProcessor.retrieveMxObjectsByMetaInfoObject(MetaInfoProcessor.java:780)

Caused by: java.lang.NullPointerException: null
    at java.util.TreeMap.put(TreeMap.java:556)
    at java.util.TreeSet.add(TreeSet.java:255)
    at java.util.AbstractCollection.addAll(AbstractCollection.java:342)
    at java.util.TreeSet.addAll(TreeSet.java:312)
    at java.util.TreeSet.<init>(TreeSet.java:160)
    at replication.helpers.OQLBuilder.buildOQLQuery(OQLBuilder.java:60)
    at replication.MetaInfoProcessor.retrieveMxObjectsByMetaInfoObject(MetaInfoProcessor.java:679)
    at replication.MetaInfoProcessor.populateAssociatedObjects(MetaInfoProcessor.java:843)
    at replication.MetaInfoProcessor.storeChangedObjects(MetaInfoProcessor.java:123)
    at replication.MetaInfoProcessor.startProcessing(MetaInfoProcessor.java:66)
    at replication.MetaInfo.startProcessingObjects(MetaInfo.java:742)
    at replication.MetaInfo.prepareObject(MetaInfo.java:626)
    at replication.MetaInfo.setAssociationValue(MetaInfo.java:583)
    at excelimporter.reader.readers.ExcelRowProcessor.processValues(ExcelRowProcessor.java:64)
    at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:280)
    at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:105)
    at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord(HSSFRequest.java:110)
    at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:144)
    at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:103)
    at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:423)
    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(UserAction.java:53)
    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.ActionManager$1.execute(ActionManager.java:204)
    at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37)
    at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:199)
    at com.mendix.core.component.InternalCore.execute(InternalCore.java:228)
    at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:46)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:49)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:196)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:151)
    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:53)
    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)

Ronald Catersels · Answer 4 · 2015-05-11

Could it be that the model reflection is not up to date?

Regards,

Ronald

Jasper van der Hoek · Answer 5 · 2015-05-12

Marnix, the nullpointer seems to be a bug in the excel importer. Could you file a ticket and include your test project and the template configuration that you are using?
This specific combination of your data or your template fell through the test cases. Once we have more detail about the exact template you are using we might be able to suggest a workaround until this has been fixed.

Jan de.Lange · Answer 6 · 2015-05-21

Marnix,

You've wrote "At least i got the import running now". What was the solution. I have the same problem. My Excel ( XLS ) has only two columns and 10 rows without any strange character. I use ModelReflection 5.2 and excelimporter 5.4

Mekyush Jariwala · Answer 7 · 2016-04-20

i am also getting same error. can you please provide work around for this error

com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: replication.ReplicationSettings$MendixReplicationException: java.lang.NullPointerException | VERSION: Mx5_20150416 at com.mendix.core.component.InternalCore.execute(InternalCore.java:385)

Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: replication.ReplicationSettings$MendixReplicationException: java.lang.NullPointerException | VERSION: Mx5_20150416 at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:178)

Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: replication.ReplicationSettings$MendixReplicationException: java.lang.NullPointerException | VERSION: Mx5_20150416 at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)

Caused by: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: replication.ReplicationSettings$MendixReplicationException: java.lang.NullPointerException | VERSION: Mx5_20150416 at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:133)

Caused by: com.mendix.core.CoreException: Document could not be imported, because: replication.ReplicationSettings$MendixReplicationException: java.lang.NullPointerException | VERSION: Mx5_20150416 at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:459)

Caused by: excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener$ExcelRuntimeException: replication.ReplicationSettings$MendixReplicationException: java.lang.NullPointerException | VERSION: Mx5_20150416 at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:183) at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord(HSSFRequest.java:110) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:144) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:103) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:428) 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(UserAction.java:49) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248) at com.mendix.core.actionmanagement.ActionManager$1.execute(ActionManager.java:168) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:174) at com.mendix.core.component.InternalCore.execute(InternalCore.java:377) at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:52) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:192) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:149) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248) at com.mendix.core.actionmanagement.CustomActionMonitorImpl$$anonfun$run$1.apply(CustomMonitoredAction.scala:14) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:144) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(ActionDispatching.scala:146) at scala.util.Try$.apply(Try.scala:192) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(ActionDispatching.scala:140) at akka.actor.Actor$class.aroundReceive(Actor.scala:465) at com.mendix.core.session.Worker.aroundReceive(ActionDispatching.scala:136) 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: replication.ReplicationSettings$MendixReplicationException: java.lang.NullPointerException | VERSION: Mx5_20150416 at replication.MetaInfo.finished(MetaInfo.java:774)

Caused by: replication.ReplicationSettings$MendixReplicationException: java.lang.NullPointerException at replication.MetaInfoProcessor.startProcessing(MetaInfoProcessor.java:81)

Caused by: java.lang.NullPointerException: null at scala.collection.convert.Wrappers$JListWrapper.iterator(Wrappers.scala:88) at scala.collection.IterableLike$class.foreach(IterableLike.scala:72) at scala.collection.AbstractIterable.foreach(Iterable.scala:54) at scala.collection.generic.Growable$class.$plus$plus$eq(Growable.scala:59) at scala.collection.mutable.SetBuilder.$plus$plus$eq(SetBuilder.scala:20) at scala.collection.TraversableLike$class.to(TraversableLike.scala:635) at scala.collection.AbstractTraversable.to(Traversable.scala:104) at scala.collection.TraversableOnce$class.toSet(TraversableOnce.scala:302) at scala.collection.AbstractTraversable.toSet(Traversable.scala:104) at com.mendix.core.objectmanagement.member.MendixObjectReferenceSet.setValue(MendixObjectReferenceSet.scala:48) at com.mendix.core.objectmanagement.member.MendixObjectReferenceSet.setValue(MendixObjectReferenceSet.scala:16) at com.mendix.core.objectmanagement.MendixObjectImpl.setValue(MendixObjectImpl.java:195) at com.mendix.core.objectmanagement.MendixObjectImpl.setValue(MendixObjectImpl.java:183) at replication.MetaInfoProcessor.storeChangedObjects(MetaInfoProcessor.java:220) at replication.MetaInfoProcessor.startProcessing(MetaInfoProcessor.java:66) at replication.MetaInfo.startProcessingObjects(MetaInfo.java:742) at replication.MetaInfo.finished(MetaInfo.java:767) at excelimporter.reader.readers.ExcelRowProcessor.finish(ExcelRowProcessor.java:169) at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:173) at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord(HSSFRequest.java:110) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:144) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:103) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:428) 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(UserAction.java:49) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248) at com.mendix.core.actionmanagement.ActionManager$1.execute(ActionManager.java:168) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:174) at com.mendix.core.component.InternalCore.execute(InternalCore.java:377) at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:52) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:192) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:149) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248) at com.mendix.core.actionmanagement.CustomActionMonitorImpl$$anonfun$run$1.apply(CustomMonitoredAction.scala:14) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:144) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(ActionDispatching.scala:146) at scala.util.Try$.apply(Try.scala:192) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(ActionDispatching.scala:140) at akka.actor.Actor$class.aroundReceive(Actor.scala:465) at com.mendix.core.session.Worker.aroundReceive(ActionDispatching.scala:136) 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)