Talend issue Exception in thread "main" java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlOptions.put -- jar FILE ISSUE

[Tasfiahm]

Hi,

I am trying to use the tFileExcelWorkbookOpen component. It looks like the Talend is missing some libraries. I am not sure which library it is missing.

It will be great if you can advice a little to over come this issue:

Starting job Workbook_Open at 11:51 04/01/2021.

[statistics] connecting to socket on port 1111

[statistics] connected

Exception in thread "main" java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlOptions.put(Ljava/lang/Object;)V

at org.apache.poi.xssf.model.SharedStringsTable.<clinit>(SharedStringsTable.java:94)

at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:61)

at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:684)

at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:180)

at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:288)

at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:309)

at de.jlo.talendcomp.excel.SpreadsheetFile.initializeWorkbook(SpreadsheetFile.java:437)

at talend_dev_repo_open_studio_migration.workbook_open_0_1.Workbook_Open.tFileExcelWorkbookOpen_1Process(Workbook_Open.java:543)

at talend_dev_repo_open_studio_migration.workbook_open_0_1.Workbook_Open.tLibraryLoad_1Process(Workbook_Open.java:460)

at talend_dev_repo_open_studio_migration.workbook_open_0_1.Workbook_Open.runJobInTOS(Workbook_Open.java:1620)

at talend_dev_repo_open_studio_migration.workbook_open_0_1.Workbook_Open.main(Workbook_Open.java:1420)

[statistics] disconnected

[statistics] disconnected

Job Workbook_Open ended at 11:51 04/01/2021. [exit code=1]

I am using Talend Studio 7.2.1 -- in another machine I have install Talend Bigdata 7.3.1 and the component is working fine.

So I am not sure which jar file it is missing.

[Anonymous]

Hello,

What's JDK version are you using in your machine where talend studio 7.2 is installed?

It seems to be a bug in V 7.2.1. We made a testing and it works from our end in Talend Studio 7.3.1.

Windows 10

Java 1.8

[Tasfiahm]

Hi,

I have created a hob similar as you. But it is not working.

Now I have a different error:

[statistics] connecting to socket on port 3988

[statistics] connected

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlObject

at de.jlo.talendcomp.excel.SpreadsheetFile.initializeWorkbook(SpreadsheetFile.java:441)

at talend_dev_repo_open_studio_migration.test2_0_1.Test2.tFileExcelWorkbookOpen_1Process(Test2.java:364)

at talend_dev_repo_open_studio_migration.test2_0_1.Test2.runJobInTOS(Test2.java:1537)

at talend_dev_repo_open_studio_migration.test2_0_1.Test2.main(Test2.java:1337)

Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlObject

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

... 4 more

[statistics] disconnected

Job Test2 ended at 15:39 12/01/2021. [exit code=1]

I have attached a sample job for your review.

Thanks,

Tasfi

[Tasfiahm]

see screenshot.