topic Re: tFileInputExcel: NoClassDefFoundError - ArithmeticUtils in Talend Studio

tFileInputExcel: NoClassDefFoundError - ArithmeticUtils

RMotta2408 — Fri, 15 Nov 2024 21:53:14 GMT

Hi there,

I'm using Talend Cloud Big Data and I'm trying to run a very, very simple Job: read from an Excel file and show the results on the console.

For that, I'm using the tFileInputExcel component to read the Excel file and the tLogRow to show the results on the console (basic stuff, really).

But I'm getting this annoying error:

"[statistics] connected

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/math3/util/ArithmeticUtils

at org.apache.poi.poifs.property.RootProperty.setSize(RootProperty.java:59)

at org.apache.poi.poifs.property.DirectoryProperty.<init>(DirectoryProperty.java:52)

at org.apache.poi.poifs.property.RootProperty.<init>(RootProperty.java:31)

at org.apache.poi.poifs.property.PropertyTable.<init>(PropertyTable.java:58)

at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:102)

at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:209)

at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:170)

at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:322)

at teste_samsung.tsts_ale05_0_1.tsts_ale05.tFileInputExcel_1Process(tsts_ale05.java:969)

at teste_samsung.tsts_ale05_0_1.tsts_ale05.runJobInTOS(tsts_ale05.java:1977)

at teste_samsung.tsts_ale05_0_1.tsts_ale05.main(tsts_ale05.java:1676)

Caused by: java.lang.ClassNotFoundException: org.apache.commons.math3.util.ArithmeticUtils

at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)

at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)

at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)"

What can I do to overcome this error? Can anyone please help me?

Thanks so much,

Rui

Re: tFileInputExcel: NoClassDefFoundError - ArithmeticUtils

Anonymous — Thu, 20 Apr 2023 01:00:37 GMT

Hello @Rui Motta ,

I can't reproduce the issue in my side. Regarding to the job error log, seems it doesn't use the correct version of jar commons-math3

please try to download the commons-math3-3.6.1.jar from

https://mvnrepository.com/artifact/org.apache.commons/commons-math3/3.6.1

then import it by Talend modules view (open it by Window->show view ->Talend ->Modules in studio)

then re-try the job

Re: tFileInputExcel: NoClassDefFoundError - ArithmeticUtils

RMotta2408 — Thu, 20 Apr 2023 10:00:18 GMT

Hi @Aiming Chen ,

Thanks for replying as always.

I can't replicate this problem either on another computer. That's why it's so puzzling to me.

I thank you for your help. I will try this and let you know how it went.

Thank you so much. I appreciate your help.

Rui

Re: tFileInputExcel: NoClassDefFoundError - ArithmeticUtils

RMotta2408 — Thu, 20 Apr 2023 16:51:45 GMT

Hi @Aiming Chen ,

That problem was solved. Thank you very much.

But now, a new one arose:

"[statistics] connected

Exception in component tFileInputExcel_1 (Piloto_Excel_fileout_v3)

org.apache.poi.poifs.filesystem.NotOLE2FileException: Invalid header signature; read 0x4353414E2023233C, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document

at org.apache.poi.poifs.storage.HeaderBlock.<init>(HeaderBlock.java:151)

at org.apache.poi.poifs.storage.HeaderBlock.<init>(HeaderBlock.java:117)

at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:229)

at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:170)

at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:322)

at teste_samsung.piloto_excel_fileout_v3_0_1.Piloto_Excel_fileout_v3.tFileInputExcel_1Process(Piloto_Excel_fileout_v3.java:666)

at teste_samsung.piloto_excel_fileout_v3_0_1.Piloto_Excel_fileout_v3.runJobInTOS(Piloto_Excel_fileout_v3.java:1613)

at teste_samsung.piloto_excel_fileout_v3_0_1.Piloto_Excel_fileout_v3.main(Piloto_Excel_fileout_v3.java:1312)

[FATAL] 11:50:05 teste_samsung.piloto_excel_fileout_v3_0_1.Piloto_Excel_fileout_v3- tFileInputExcel_1 Invalid header signature; read 0x4353414E2023233C, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document

org.apache.poi.poifs.filesystem.NotOLE2FileException: Invalid header signature; read 0x4353414E2023233C, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document

at org.apache.poi.poifs.storage.HeaderBlock.<init>(HeaderBlock.java:151) ~[poi-4.1.2-20200903124306_modified_talend.jar:4.1.2-20200903124306_modified_talend]

at org.apache.poi.poifs.storage.HeaderBlock.<init>(HeaderBlock.java:117) ~[poi-4.1.2-20200903124306_modified_talend.jar:4.1.2-20200903124306_modified_talend]

at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:229) ~[poi-4.1.2-20200903124306_modified_talend.jar:4.1.2-20200903124306_modified_talend]

at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:170) ~[poi-4.1.2-20200903124306_modified_talend.jar:4.1.2-20200903124306_modified_talend]

at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:322) ~[poi-4.1.2-20200903124306_modified_talend.jar:4.1.2-20200903124306_modified_talend]

at teste_samsung.piloto_excel_fileout_v3_0_1.Piloto_Excel_fileout_v3.tFileInputExcel_1Process(Piloto_Excel_fileout_v3.java:666) [classes/:?]

at teste_samsung.piloto_excel_fileout_v3_0_1.Piloto_Excel_fileout_v3.runJobInTOS(Piloto_Excel_fileout_v3.java:1613) [classes/:?]

at teste_samsung.piloto_excel_fileout_v3_0_1.Piloto_Excel_fileout_v3.main(Piloto_Excel_fileout_v3.java:1312) [classes/:?]

[statistics] disconnected

Job Piloto_Excel_fileout_v3 ended at 11:50 20/04/2023. [Exit code = 1]"

This new error occurs with any Excel file.

Rui

Re: tFileInputExcel: NoClassDefFoundError - ArithmeticUtils

Anonymous — Fri, 21 Apr 2023 00:50:06 GMT

Hello @Rui Motta ,

Could you please check if you have check the button 'Read excel2007 file format (xlsx)' for tFileInputExcel component as the below? if no, please check it to re-try?

Re: tFileInputExcel: NoClassDefFoundError - ArithmeticUtils

RMotta2408 — Fri, 21 Apr 2023 12:04:20 GMT

Hi @Aiming Chen ,

The option was checked, yes.

This erros occurs with that option checked.

Thank you,

Rui

Re: tFileInputExcel: NoClassDefFoundError - ArithmeticUtils

Anonymous — Sun, 23 Apr 2023 00:18:29 GMT

@Rui Motta ,

Seems the old job is corrupted, please re-create a new job with tFileInputExcel to re-try?

Re: tFileInputExcel: NoClassDefFoundError - ArithmeticUtils

RMotta2408 — Mon, 24 Apr 2023 10:12:02 GMT

Hi @Aiming Chen ,

I can try this but this Job runs in all others Talend Studio versions I have, including another Talend Cloud Big Data.

Can it maybe be a faulty Studio installation?

Thanks,

Rui

Re: tFileInputExcel: NoClassDefFoundError - ArithmeticUtils

Anonymous — Tue, 25 Apr 2023 00:57:19 GMT

Hello @Rui Motta ,

please try to re-start the studio using a new workspace to re-try, if it still doesn't help, then it maybe the faulty Studio installation, then re-install a studio

Thanks

Aiming

Re: tFileInputExcel: NoClassDefFoundError - ArithmeticUtils

RMotta2408 — Tue, 25 Apr 2023 12:14:55 GMT

Hi @Aiming Chen ,

That is probably the best solution.

I will do that.

Thank you for all your support.

Cheers,

Rui