3483912 - java.lang.NoClassDefFoundError: org/apache/commons/io/build/AbstractStreamBuilder is raised after upgrading to Commerce Cloud 2211.24

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.

Environment

Product version: SAP Commerce Cloud 2211.24

Product

SAP Commerce Cloud 2211

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.