Troubleshooting Invalid enumeration value Error when Importing Excel in Mendix

0
I'm encountering errors while attempting to import data using the Excel Importer module. Attached are some images for reference. Could you please assist in resolving this issue? Thank you. I tried to upload the blank file with headers only, it's working fine. But whenever I am trying to upload the data, it generates the errors.     The following error occurred when importing document: Supplier Risk Management FY24 - Copy.xlsxcom.mendix.basis.objectmanagement.member.InvalidEnumerationValueException - Invalid enumeration value   com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: com.mendix.replication.MendixReplicationException: com.mendix.basis.objectmanagement.member.InvalidEnumerationValueException: Invalid enumeration value | VERSION: Mx5_20161013    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:108) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: com.mendix.replication.MendixReplicationException: com.mendix.basis.objectmanagement.member.InvalidEnumerationValueException: Invalid enumeration value | 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: com.mendix.replication.MendixReplicationException: com.mendix.basis.objectmanagement.member.InvalidEnumerationValueException: Invalid enumeration value | VERSION: Mx5_20161013    at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:127) Caused by: com.mendix.core.CoreException: Document could not be imported, because: com.mendix.replication.MendixReplicationException: com.mendix.basis.objectmanagement.member.InvalidEnumerationValueException: Invalid enumeration value | VERSION: Mx5_20161013    at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:374) Caused by: excelimporter.reader.readers.ExcelRuntimeException: com.mendix.replication.MendixReplicationException: com.mendix.basis.objectmanagement.member.InvalidEnumerationValueException: Invalid enumeration value | VERSION: Mx5_20161013    at excelimporter.reader.readers.ExcelDataReader.readData(ExcelDataReader.java:45)    at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:353)    at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:118)    at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:61)    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:57)    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:104)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:103)    at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:59)    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:29)    at scala.Option.flatMap(Option.scala:283)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.scala:26)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.scala:176)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:116)    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:57)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:59)    at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:52)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:52)    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:57)    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeAsync$3(ActionManager.scala:87)    at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:687)    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:829) Caused by: com.mendix.replication.MendixReplicationException: com.mendix.basis.objectmanagement.member.InvalidEnumerationValueException: Invalid enumeration value | VERSION: Mx5_20161013    at com.mendix.replication.MendixReplicationException.addVersion(MendixReplicationException.java:51) Caused by: com.mendix.replication.MendixReplicationException: com.mendix.basis.objectmanagement.member.InvalidEnumerationValueException: Invalid enumeration value    at com.mendix.replication.MetaInfoProcessor.startProcessing(MetaInfoProcessor.java:69) Caused by: com.mendix.basis.objectmanagement.member.InvalidEnumerationValueException: Invalid enumeration value    at com.mendix.basis.objectmanagement.member.MendixEnumImpl.checkStrictness(MendixEnumImpl.scala:39)    at com.mendix.basis.objectmanagement.member.MendixEnumImpl.setValue(MendixEnumImpl.scala:29)    at com.mendix.basis.objectmanagement.member.MendixEnumImpl.setValue(MendixEnumImpl.scala:11)    at com.mendix.basis.objectmanagement.MendixObjectMember.setValue(MendixObjectMember.java:31)    at com.mendix.basis.objectmanagement.MendixObjectMemberImpl.parseValueFromString(MendixObjectMemberImpl.java:289)    at com.mendix.basis.objectmanagement.MendixObjectImpl.setValue(MendixObjectImpl.java:245)    at com.mendix.basis.objectmanagement.MendixObjectImpl.setValue(MendixObjectImpl.java:237)    at com.mendix.replication.MetaInfoProcessor.updateMemberAndSetState(MetaInfoProcessor.java:117)    at com.mendix.replication.MetaInfoProcessor.changeMembersForBatch(MetaInfoProcessor.java:469)    at com.mendix.replication.MetaInfoProcessor.storeChangedObjects(MetaInfoProcessor.java:260)    at com.mendix.replication.MetaInfoProcessor.startProcessing(MetaInfoProcessor.java:57)    at com.mendix.replication.MetaInfo.startProcessingObjects(MetaInfo.java:443)    at com.mendix.replication.MetaInfo.finish(MetaInfo.java:202)    at excelimporter.reader.readers.ExcelRowProcessorImpl.finish(ExcelRowProcessorImpl.java:116)    at excelimporter.reader.readers.ExcelDataReader.readData(ExcelDataReader.java:39)    at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:353)    at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:118)    at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:61)    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:57)    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:104)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:103)    at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:59)    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:29)    at scala.Option.flatMap(Option.scala:283)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.scala:26)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.scala:176)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:116)    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:57)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:59)    at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:52)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:52)    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:57)    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeAsync$3(ActionManager.scala:87)    at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:687)    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:829)       Replication_MetaInfo     com.mendix.basis.objectmanagement.member.InvalidEnumerationValueException: Invalid enumeration value    at com.mendix.basis.objectmanagement.member.MendixEnumImpl.checkStrictness(MendixEnumImpl.scala:39)    at com.mendix.basis.objectmanagement.member.MendixEnumImpl.setValue(MendixEnumImpl.scala:29)    at com.mendix.basis.objectmanagement.member.MendixEnumImpl.setValue(MendixEnumImpl.scala:11)    at com.mendix.basis.objectmanagement.MendixObjectMember.setValue(MendixObjectMember.java:31)    at com.mendix.basis.objectmanagement.MendixObjectMemberImpl.parseValueFromString(MendixObjectMemberImpl.java:289)    at com.mendix.basis.objectmanagement.MendixObjectImpl.setValue(MendixObjectImpl.java:245)    at com.mendix.basis.objectmanagement.MendixObjectImpl.setValue(MendixObjectImpl.java:237)    at com.mendix.replication.MetaInfoProcessor.updateMemberAndSetState(MetaInfoProcessor.java:117)    at com.mendix.replication.MetaInfoProcessor.changeMembersForBatch(MetaInfoProcessor.java:469)    at com.mendix.replication.MetaInfoProcessor.storeChangedObjects(MetaInfoProcessor.java:260)    at com.mendix.replication.MetaInfoProcessor.startProcessing(MetaInfoProcessor.java:57)    at com.mendix.replication.MetaInfo.startProcessingObjects(MetaInfo.java:443)    at com.mendix.replication.MetaInfo.finish(MetaInfo.java:202)    at excelimporter.reader.readers.ExcelRowProcessorImpl.finish(ExcelRowProcessorImpl.java:116)    at excelimporter.reader.readers.ExcelDataReader.readData(ExcelDataReader.java:39)    at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:353)    at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:118)    at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:61)    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:57)    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:104)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:103)    at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:59)    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:29)    at scala.Option.flatMap(Option.scala:283)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.scala:26)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.scala:176)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:116)    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:57)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:59)    at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:52)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:52)    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:57)    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeAsync$3(ActionManager.scala:87)    at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:687)    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:829)      
asked
1 answers
1

One or more of the mapped attributes is of type enumeration and the data in the excel file is different from the defined options. Let's say we have an enumeration with 2 values A and B. When you have a different value in the sheet you want to import, lat's say C the error from your post would occur.

Also keep in mind that the value that you are importing is the key value and not the display value of the enumeration, this can cause similar issues.

answered