Symptom
1. In OOTB Commerce Cloud 2211.24, if using the api org.apache.poi.ss.usermodel.WorkbookFactory.create(new File('<path to some excel file>')) of jar poi-ooxml-5.2.2.jar or using the api com.alibaba.excel.read.builder.ExcelReaderBuilder.sheet of easyExcel, the following errors could be seen in logs
SEVERE: Servlet.service() for servlet [springmvc] in context with path [] threw exception [Handler dispatch failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/io/build/AbstractStreamBuilder] with root cause java.lang.ClassNotFoundException: org.apache.commons.io.build.AbstractStreamBuilder at org.apache.commons.compress.archivers.zip.ZipFile.<init>(ZipFile.java:858) at org.apache.commons.compress.archivers.zip.ZipFile.<init>(ZipFile.java:930) at org.apache.commons.compress.archivers.zip.ZipFile.<init>(ZipFile.java:818) at org.apache.commons.compress.archivers.zip.ZipFile.<init>(ZipFile.java:794) at org.apache.commons.compress.archivers.zip.ZipFile.<init>(ZipFile.java:714) at org.apache.commons.compress.archivers.zip.ZipFile.<init>(ZipFile.java:701) at org.apache.poi.openxml4j.util.ZipSecureFile.<init>(ZipSecureFile.java:132) at org.apache.poi.openxml4j.opc.internal.ZipHelper.openZipFile(ZipHelper.java:205) 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.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:155) at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:36) at org.apache.poi.ss.usermodel.WorkbookFactory.lambda$create$4(WorkbookFactory.java:311) at org.apache.poi.ss.usermodel.WorkbookFactory.wp(WorkbookFactory.java:329) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:311) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:277) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:255) at org.apache.poi.ss.usermodel.WorkbookFactory$create.call(Unknown Source) |
Exception: com.alibaba.excel.exception.ExcelAnalysisException Message: java.lang.NoClassDefFoundError: org/apache/commons/io/build/AbstractStreamBuilder Stacktrace: com.alibaba.excel.analysis.ExcelAnalyserImpl.<init>(ExcelAnalyserImpl.java:43) com.alibaba.excel.ExcelReader.<init>(ExcelReader.java:145) com.alibaba.excel.read.builder.ExcelReaderBuilder.build(ExcelReaderBuilder.java:226) com.alibaba.excel.read.builder.ExcelReaderBuilder.sheet(ExcelReaderBuilder.java:242) com.alibaba.excel.read.builder.ExcelReaderBuilder.sheet(ExcelReaderBuilder.java:234) |
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
- Product version: SAP Commerce Cloud 2211.24
Product
Keywords
AbstractStreamBuilder,NoClassDefFoundError,easyExcel,poi-ooxml , KBA , CEC-SCC-PLA-PL , Platform , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.