Mendix 10.10 Excel Importer 에러

import 했더니 에러 발생했다. 

문제 : jar파일이 안맞아서 발생했고 vendorlib는 완전 삭제했다.

online인 경우는 vendorlib 삭제해도 다시 실행하면 생성된다. 

이러나 저러나 결론은 dependency가 안맞아서 난 에러고 userlib에서 불필요한 dependancy를 전부 제거했다. 이후 vendorlib를 지우고 재실행하면 정상 동작한다. 

C:\Users\user\Mendix\{본인APP명}\userlib 파일을 하나하나 매치시키면서 정리하거나 되는 app의 userlib로 엎어친다.

그리고 App > Synchronize dependency를 눌러서 맞춰준다. 

 

 

결론을 찾아가기 전 삽질은 아래와 같다. 

Error in execution of monitored action '{"name":"ExcelImporter.IVK_ImportTemplateDocument","type":"Microflow"}' (execution id: ac606621-a2c1-43bb-b9f1-714d7601819f, execution type: CLIENT_ASYNC_MONITORED)

--------

java.lang.NoSuchMethodError: 'org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream$Builder org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.builder()'
	at org.apache.poi.util.IOUtils.peekFirstNBytes(IOUtils.java:144)
	at org.apache.poi.poifs.filesystem.FileMagic.valueOf(FileMagic.java:209)
	at org.apache.poi.openxml4j.opc.internal.ZipHelper.verifyZipHeader(ZipHelper.java:143)
	at org.apache.poi.openxml4j.opc.internal.ZipHelper.openZipFile(ZipHelper.java:201)
	at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:166)
	at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:282)
	at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:191)
	at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:310)
	at excelimporter.reader.readers.ExcelXLSXDataReader$1.<init>(ExcelXLSXDataReader.java:51)
	at excelimporter.reader.readers.ExcelXLSXDataReader.parseExcelFile(ExcelXLSXDataReader.java:51)
	at excelimporter.reader.readers.ExcelXLSXDataReader.readDataRows(ExcelXLSXDataReader.java:45)
	at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:364)
	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:105)
	at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)
	at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:104)
	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:88)
	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)

 

https://community.mendix.com/link/space/community/questions/136047

포럼을 보니 POI문제라 그래서 5.2.5로 업그레이드 했으나 동일한 에러가 발생한다. 

5.2.2로도 변경해봤으나 동일한 에러가 발생한다. 

 

NoSuchMethod 

https://stackoverflow.com/questions/77256330/java-lang-nosuchmethoderror-org-apache-commons-io-output-unsynchronizedbytearr

이 글을 보아 Common-io 버전 변경을 해야하는 거 같다. 

 

commons-io-2.12.0.jar로 파일을 변경해봤지만, 에러는 여전히 발생한다. 

 

commons-io-2.14.0으로 변경해봤다. 

 

gradle 8.6으로 변경 => not working

 

https://community.mendix.com/link/space/java-actions/questions/132971

Excel Importer generating Errors since upgrading the Module | Mendix Forum

 

중복 파일 제거 commons-io-2.11을 제거