Getting org.apache.poi.ooxml.POIXMLTypeLoader Error

Product Forums Katalon Studio
,
1

Hi,

When I run a test using Katalon Studio, it runs fine and write data to excel files and no issues. But when I run the same test using console mode, I am getting following error and doesn’t write data to any excel files.

Can someone help me on this?

2020-08-11 16:22:19.174 ERROR c.k.k.core.context.internal.TestHooker - ? org.apache.poi.ooxml.POIXMLException: Could not initialize class org.apache.poi.ooxml.POIXMLTypeLoader
at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:66)
at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:657)
at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:180)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.(XSSFWorkbook.java:282)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.(XSSFWorkbook.java:303)
at common.Excel.RemoveValuesFromExcel(Excel.groovy:143)
at common.Excel$RemoveValuesFromExcel.call(Unknown Source)
at GWListener.gwBeforeTestSuite(GWListener.groovy:181)
at GWListener.invokeMethod(GWListener.groovy)
at com.kms.katalon.core.context.internal.TestHooker.invokeMethod(TestHooker.java:111)
at com.kms.katalon.core.context.internal.TestHooker.lambda$3(TestHooker.java:95)
at com.kms.katalon.core.context.internal.TestHooker.invokeContextMethods(TestHooker.java:94)
at com.kms.katalon.core.context.internal.TestListenerCollector.lambda$3(TestListenerCollector.java:88)
at com.kms.katalon.core.context.internal.TestListenerCollector.handleListenerEvent(TestListenerCollector.java:85)
at com.kms.katalon.core.context.internal.ExecutionEventManager.publicEvent(ExecutionEventManager.java:36)
at com.kms.katalon.core.main.TestSuiteExecutor.execute(TestSuiteExecutor.java:88)
at com.kms.katalon.core.main.TestCaseMain.startTestSuite(TestCaseMain.java:157)
at com.kms.katalon.core.main.TestCaseMain$startTestSuite$0.call(Unknown Source)
at TempTestSuite1597177333393.run(TempTestSuite1597177333393.groovy:39)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:56)
at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:63)
… 18 more
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.apache.poi.ooxml.POIXMLTypeLoader
at org.apache.poi.xssf.model.ThemesTable.(ThemesTable.java:86)
… 20 more

2

hello
maybe this is some kind of permission issue, try to run console with admin rights

3

Thanks Timo_Kuisuma1 for your reply. Issue was multiple poi.ooxml.jar versions in the project. I am good now.