Strange Excel import error

0
I try to import an Excel file and I get the following error: An error has occurred while handling the request. [User 'mxadmin' with roles 'Administrator'] -------- lh: com.mendix.core.CoreException: Document could not be imported, because: com.mendix.core.CoreRuntimeException: A virtual primitive cannot be assigned a value, as it represents an action at ExcelImporter.IVK_ImportTemplateDocument (JavaAction : 'Call 'StartImportByTemplate'') Advanced stacktrace: at mA.a(SourceFile:188) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: com.mendix.core.CoreRuntimeException: A virtual primitive cannot be assigned a value, as it represents an action at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:135) Caused by: com.mendix.core.CoreException: Document could not be imported, because: com.mendix.core.CoreRuntimeException: A virtual primitive cannot be assigned a value, as it represents an action at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:387) Caused by: excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener$ExcelRuntimeException: com.mendix.core.CoreRuntimeException: A virtual primitive cannot be assigned a value, as it represents an action at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:126) at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord(HSSFRequest.java:113) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:126) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:85) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:358) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:125) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:53) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:1) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at lo.a(SourceFile:70) at mA.a(SourceFile:73) at mz.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at gd.execute(SourceFile:184) at iI.a(SourceFile:311) at iI.a(SourceFile:240) at iI.processRequest(SourceFile:179) at iL.a(SourceFile:71) at com.mendix.core.MxRuntime.processRequest(SourceFile:856) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:43) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:209) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662) Caused by: com.mendix.core.CoreRuntimeException: A virtual primitive cannot be assigned a value, as it represents an action at hL.setValue(SourceFile:232) at com.mendix.core.objectmanagement.member.MendixString.setValue(SourceFile:72) at com.mendix.core.objectmanagement.member.MendixString.parseValueFromString(SourceFile:55) at hK.setValue(SourceFile:273) at hR.setMemberValue(SourceFile:183) at replication.MetaInfo.changeMembersForBatch(MetaInfo.java:1109) at replication.MetaInfo.storeChangedObjects(MetaInfo.java:823) at replication.MetaInfo.finished(MetaInfo.java:1212) at excelimporter.reader.readers.ExcelRowProcessor.finish(ExcelRowProcessor.java:89) at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:116) at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord(HSSFRequest.java:113) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:126) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:85) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:358) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:125) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:53) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:1) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at lo.a(SourceFile:70) at mA.a(SourceFile:73) at mz.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at gd.execute(SourceFile:184) at iI.a(SourceFile:311) at iI.a(SourceFile:240) at iI.processRequest(SourceFile:179) at iL.a(SourceFile:71) at com.mendix.core.MxRuntime.processRequest(SourceFile:856) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:43) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:209) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662) Can anybody give a clue what is wrong with this Excel file? I checked it and could not find anything strange.
asked
1 answers
0

The stacktrace says:

lh: com.mendix.core.CoreException: Document could not be imported, because: com.mendix.core.CoreRuntimeException: A virtual primitive cannot be assigned a value, as it represents an action
    at ExcelImporter.IVK_ImportTemplateDocument (JavaAction : 'Call 'StartImportByTemplate'')

Are you mapping a value from the excel file to a Virtual Attribute (ie: an attribute that's generated using a Microflow)?

answered