Excel importer now gives an error

0
Hi All, the importer has been working fine for about 9 months and now we get this error. does anyone know how to help? Error in execution of monitored action '{"name":"ExcelImporter.IVK_ImportTemplateDocument","type":"Microflow"}' (execution id: fe91f116-01d7-469d-b03e-8e9daa465334, execution type: CLIENT_ASYNC_MONITORED).  NoClassDefFoundError occurred for class 'org/apache/commons/lang/StringUtils'. Please make sure the userlib folder of  your project includes the correct library which contains this class.   java.lang.NoClassDefFoundError: org/apache/commons/lang/StringUtils     at replication.ValueParser.getDoubleValue(ValueParser.java:657)     at replication.ValueParser.getIntegerValue(ValueParser.java:478)     at replication.ValueParser.getValueByType(ValueParser.java:363)     at replication.ValueParser.getValue(ValueParser.java:347)     at excelimporter.reader.readers.replication.ExcelValueParser.getValue(ExcelValueParser.java:150)     at excelimporter.reader.readers.replication.ExcelValueParser.getValueFromDataSet(ExcelValueParser.java:71)     at excelimporter.reader.readers.ExcelRowProcessor.processValues(ExcelRowProcessor.java:61)     at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:280)     at excelimporter.reader.readers.ExcelXLSReaderDataSecondPassListener.processRecord(ExcelXLSReaderDataSecondPassListener.java:83)     at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord(HSSFRequest.java:109)     at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:178)     at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:135)     at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:424)     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:46)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)     at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:150)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:155)     at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:414)     at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:56)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:201)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)     at com.mendix.basis.actionmanagement.DefaultActionMonitor$.$anonfun$run$1(CustomMonitoredAction.scala:18)     at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.basis.actionmanagement.IMonitoredAction.monitor(IMonitoredAction.scala:49)     at com.mendix.basis.actionmanagement.IMonitoredAction.monitor$(IMonitoredAction.scala:25)     at com.mendix.basis.actionmanagement.CustomMonitoredAction.monitor(CustomMonitoredAction.scala:22)     at com.mendix.basis.actionmanagement.DefaultActionMonitor$.run(CustomMonitoredAction.scala:18)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:68)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:55)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)     at com.mendix.basis.actionmanagement.AsyncExecution.$anonfun$call$1(AsyncExecution.scala:21)     at scala.util.Try$.apply(Try.scala:213)     at com.mendix.basis.actionmanagement.AsyncExecution.call(AsyncExecution.scala:21)     at com.mendix.basis.actionmanagement.AsyncExecution.$anonfun$execute$1(AsyncExecution.scala:17)     at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:658)     at scala.util.Success.$anonfun$map$1(Try.scala:255)     at scala.util.Success.map(Try.scala:213)     at scala.concurrent.Future.$anonfun$map$1(Future.scala:292)     at scala.concurrent.impl.Promise.liftedTree1$1(Promise.scala:33)     at scala.concurrent.impl.Promise.$anonfun$transform$1(Promise.scala:33)     at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:64)     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)     at java.lang.Thread.run(Thread.java:748)           
asked
1 answers
0

Hi Ben,

Check your userlib folder for duplicate jars and remove the oldest (lowest) version(s), that should probably solve the issue.

 

answered