Presence of tXSLT makes tFileOutputExcel raise an error

RKowalski — Fri, 15 Nov 2024 23:10:14 GMT

Hi !

Here is the minimal exemple to reproduce :

Running this leads to the following trace :

Error

DOMSource cannot be processed: check that saxon9-dom.jar is on the classpath

Error

DOMSource cannot be processed: check that saxon9-dom.jar is on the classpath

Error

DOMSource cannot be processed: check that saxon9-dom.jar is on the classpath

Error

DOMSource cannot be processed: check that saxon9-dom.jar is on the classpath

Error

DOMSource cannot be processed: check that saxon9-dom.jar is on the classpath

Error

DOMSource cannot be processed: check that saxon9-dom.jar is on the classpath

Exception in component tFileOutputExcel_1 (test)

org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : The part /docProps/core.xml failed to be saved in the stream with marshaller org.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller@5fb759d6

at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:558)

at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1488)

at org.apache.poi.openxml4j.opc.OPCPackage.close(OPCPackage.java:454)

at org.apache.poi.ooxml.POIXMLDocument.close(POIXMLDocument.java:204)

at org.apache.poi.xssf.usermodel.XSSFWorkbook.close(XSSFWorkbook.java:586)

at org.apache.poi.xssf.streaming.SXSSFWorkbook.close(SXSSFWorkbook.java:925)

at org.talend.ExcelTool.writeExcel(ExcelTool.java:377)

at tests.test_0_1.test.tRowGenerator_1Process(test.java:621)

at tests.test_0_1.test.runJobInTOS(test.java:1033)

at tests.test_0_1.test.main(test.java:882)

Caused by: org.apache.poi.openxml4j.exceptions.OpenXML4JException: The part /docProps/core.xml failed to be saved in the stream with marshaller org.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller@5fb759d6

at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:547)

... 9 more

The job works fine when "Write to Excel2007" is unchecked or when one of "tXSLT" or "tFileOutputExcel" is removed.

I'm using Talend Open Studio 7.3.1.20200219_1130

Can you help me ?

Kind regards,

Robin Kowalski

Re: Presence of tXSLT makes tFileOutputExcel raise an error

Anonymous — Tue, 01 Mar 2022 09:20:58 GMT

Hello,

The saxon9-dom.jar is required but when each jobs are run alone, it works. It looks like tXSLT and tFileExcelOutput are not compatible.

In the master job, please try to add a tLibrairyLoad with saxon9-dom.jar to solve the issue.

Could you please try this workaround to see if it helps?

Best regards

Sabrina

Re: Presence of tXSLT makes tFileOutputExcel raise an error

RKowalski — Tue, 01 Mar 2022 10:07:33 GMT

Hello,

Ok, it seems to have worked ! I figured the version of saxon was 9.1.0.5, so I download that version of saxon9-dom : https://mvnrepository.com/artifact/net.sf.saxon/saxon9-dom/9.1.0.5 then I loaded it with a tLibrairyLoad as you suggested and the job run just fine.

Thanks a lot and have a great day !

Kind regards,

Robin Kowalski

Re: Presence of tXSLT makes tFileOutputExcel raise an error

Anonymous — Wed, 02 Mar 2022 04:00:42 GMT

Hello,

Great it works. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina

topic Re: Presence of tXSLT makes tFileOutputExcel raise an error in Talend Studio

Presence of tXSLT makes tFileOutputExcel raise an error

Re: Presence of tXSLT makes tFileOutputExcel raise an error

Re: Presence of tXSLT makes tFileOutputExcel raise an error

Re: Presence of tXSLT makes tFileOutputExcel raise an error