1

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 2022-01-06

2 answers