Talend issue Exception in thread "main" java.lang.... - Qlik Community

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

俊逸的竹笋 · 过年给男朋友送什么礼物好适合送哪些礼物-订花快· 1 月前 ·

慷慨的白开水 · Wacom ...· 5 月前 ·

重感情的手术刀 · 解放军新闻传播中心2021年中国新闻奖推荐作 ...· 6 月前 ·

活泼的抽屉 · 三博医疗-三博脑科集团-三博脑科集团官网· 11 月前 ·

傲视众生的玉米 · 神户Live直播破解版免卡密不需要卡密就能看 ...· 1 年前 ·

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

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.

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