tFileInputExcel: NoClassDefFoundError - ArithmeticUtils

[RMotta2408]

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

[Anonymous · Accepted solution]

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

[RMotta2408]

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

[RMotta2408]

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

[Anonymous]

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?

[RMotta2408]

Hi @Aiming Chen​ ,

The option was checked, yes.

This erros occurs with that option checked.

Thank you,

Rui

[Anonymous]

@Rui Motta​ ,

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

[RMotta2408]

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

[Anonymous]

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

[RMotta2408]

Hi @Aiming Chen​ ,

That is probably the best solution.

I will do that.

Thank you for all your support.

Cheers,

Rui