When I try to import excel by using Excel Importer, It cannot import data and displayed an error. What is the root cause and solution for the error? Here’s the error log as below. “The following error occurred when importing document: Employee Data for Smart PPE Management Project_Touchchai_2.xlsx -------- 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.IllegalArgumentException: requirement failed: Reference 'Employee.EmpProfile_EmpImportDoc' only accepts ids of type 'Employee.EmpImportDoc' (Id '[MendixIdentifier:: id=33214047251857809 objectType=ExcelImporter.Template entityID=118]' is not allowed). | VERSION: Mx5_20161013 at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:84) 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.IllegalArgumentException: requirement failed: Reference 'Employee.EmpProfile_EmpImportDoc' only accepts ids of type 'Employee.EmpImportDoc' (Id '[MendixIdentifier:: id=33214047251857809 objectType=ExcelImporter.Template entityID=118]' is not allowed). | VERSION: Mx5_20161013 at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: replication.ReplicationSettings$MendixReplicationException: java.lang.IllegalArgumentException: requirement failed: Reference 'Employee.EmpProfile_EmpImportDoc' only accepts ids of type 'Employee.EmpImportDoc' (Id '[MendixIdentifier:: id=33214047251857809 objectType=ExcelImporter.Template entityID=118]' is not allowed). | VERSION: Mx5_20161013 at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:129) Caused by: com.mendix.core.CoreException: Document could not be imported, because: replication.ReplicationSettings$MendixReplicationException: java.lang.IllegalArgumentException: requirement failed: Reference 'Employee.EmpProfile_EmpImportDoc' only accepts ids of type 'Employee.EmpImportDoc' (Id '[MendixIdentifier:: id=33214047251857809 objectType=ExcelImporter.Template entityID=118]' is not allowed). | VERSION: Mx5_20161013 at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:397) Caused by: excelimporter.reader.readers.ExcelRuntimeException: replication.ReplicationSettings$MendixReplicationException: java.lang.IllegalArgumentException: requirement failed: Reference 'Employee.EmpProfile_EmpImportDoc' only accepts ids of type 'Employee.EmpImportDoc' (Id '[MendixIdentifier:: id=33214047251857809 objectType=ExcelImporter.Template entityID=118]' is not allowed). | VERSION: Mx5_20161013 at excelimporter.reader.readers.ExcelXLSXDataReader.readData(ExcelXLSXDataReader.java:59) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:370) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:120) 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:58) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:56) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:80) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:79) at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:57) at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:35) at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:11) at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:38) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.$anonfun$execute$1(MicroflowObject.scala:32) at scala.Option.flatMap(Option.scala:283) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.scala:29) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.$anonfun$executeAfterBreakingIfNecessary$2(MicroflowImpl.scala:167) at scala.Option.flatMap(Option.scala:283) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.scala:167) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:114) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:56) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:59) at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:49) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:49) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:59) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:46) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:56) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeAsync$3(ActionManager.scala:64) at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:678) at scala.concurrent.impl.Promise$Transformation.run(Promise.scala:467) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: replication.ReplicationSettings$MendixReplicationException: java.lang.IllegalArgumentException: requirement failed: Reference 'Employee.EmpProfile_EmpImportDoc' only accepts ids of type 'Employee.EmpImportDoc' (Id '[MendixIdentifier:: id=33214047251857809 objectType=ExcelImporter.Template entityID=118]' is not allowed). | VERSION: Mx5_20161013 at replication.MetaInfo.finished(MetaInfo.java:775) Caused by: replication.ReplicationSettings$MendixReplicationException: java.lang.IllegalArgumentException: requirement failed: Reference 'Employee.EmpProfile_EmpImportDoc' only accepts ids of type 'Employee.EmpImportDoc' (Id '[MendixIdentifier:: id=33214047251857809 objectType=ExcelImporter.Template entityID=118]' is not allowed). at replication.MetaInfoProcessor.startProcessing(MetaInfoProcessor.java:81) Caused by: java.lang.IllegalArgumentException: requirement failed: Reference 'Employee.EmpProfile_EmpImportDoc' only accepts ids of type 'Employee.EmpImportDoc' (Id '[MendixIdentifier:: id=33214047251857809 objectType=ExcelImporter.Template entityID=118]' is not allowed). at scala.Predef$.require(Predef.scala:337) at com.mendix.basis.objectmanagement.member.MendixObjectReferenceImpl.setValue(MendixObjectReferenceImpl.scala:31) at com.mendix.basis.objectmanagement.member.MendixObjectReferenceImpl.setValue(MendixObjectReferenceImpl.scala:66) at com.mendix.basis.objectmanagement.member.MendixObjectReferenceImpl.setValue(MendixObjectReferenceImpl.scala:12) at com.mendix.basis.objectmanagement.MendixObjectImpl.setValue(MendixObjectImpl.java:241) at com.mendix.basis.objectmanagement.MendixObjectImpl.setValue(MendixObjectImpl.java:230) at replication.MetaInfoProcessor.storeChangedObjects(MetaInfoProcessor.java:224) at replication.MetaInfoProcessor.startProcessing(MetaInfoProcessor.java:66) at replication.MetaInfo.startProcessingObjects(MetaInfo.java:743) at replication.MetaInfo.finished(MetaInfo.java:768) at excelimporter.reader.readers.ExcelRowProcessorImpl.finish(ExcelRowProcessorImpl.java:127) at excelimporter.reader.readers.ExcelXLSXDataReader.readData(ExcelXLSXDataReader.java:50) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:370) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:120) 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:58) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:56) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:80) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:79) at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:57) at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:35) at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:11) at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:38) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.$anonfun$execute$1(MicroflowObject.scala:32) at scala.Option.flatMap(Option.scala:283) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.scala:29) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.$anonfun$executeAfterBreakingIfNecessary$2(MicroflowImpl.scala:167) at scala.Option.flatMap(Option.scala:283) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.scala:167) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:114) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:56) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:59) at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:49) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:49) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:59) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:46) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:56) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeAsync$3(ActionManager.scala:64) at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:678) at scala.concurrent.impl.Promise$Transformation.run(Promise.scala:467) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834)”
asked
Touchchai Ponnumpa
2 answers
3
import you data using XLS format not with XLSX
answered
Javith Baig
0
Hi Touchchai,
Looks like you are trying to import the wrong ID’s for the reference EmpProfile_EmpImportDoc in your configuration. You could double check if the reference you try to import really exists in the EmpProfile entity.