Presence of tXSLT makes tFileOutputExcel raise an error

[RKowalski]

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

[Anonymous · Accepted solution]

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

[RKowalski]

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

[Anonymous]

Hello,

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

Best regards

Sabrina