topic XSLT component Issue in Talend Studio

XSLT component Issue

gtaware — Sat, 16 Nov 2024 02:15:12 GMT

Hi Team ,

I am using tXSLT component to perform some operation using XSL file into my existing XML .

XML File :

<message>
<to>Karim</to>
<from>Tom</from>
<heading>Reminder</heading>
<body>Please check your email !</body>
</message>

XSL File :

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
<xsl:copy-of select="*" />
</xsl:template>

</xsl:stylesheet>

After Applying this XSL I am getting some output . This XSL is perfectly right which I have validated using

While using tXSLT component I have used saxon9 jar files .

But After giving XML,XSL and output file path , I got below errors :

[FATAL]: pymts_batch.xml_validation_0_1.xml_validation - tXSLT_1 Failed to compile stylesheet. 1 error detected.
javax.xml.transform.TransformerConfigurationException: Failed to compile stylesheet. 1 error detected.
at net.sf.saxon.PreparedStylesheet.prepare(PreparedStylesheet.java:176)
at net.sf.saxon.TransformerFactoryImpl.newTemplates(TransformerFactoryImpl.java:139)
at net.sf.saxon.TransformerFactoryImpl.newTransformer(TransformerFactoryImpl.java:91)
at pymts_batch.xml_validation_0_1.xml_validation.tFixedFlowInput_1Process(xml_validation.java:1029)
at pymts_batch.xml_validation_0_1.xml_validation.runJobInTOS(xml_validation.java:6118)
at pymts_batch.xml_validation_0_1.xml_validation.main(xml_validation.java:5855)
Error
java.io.FileNotFoundException: /Client/Z$/file_processing_path/test_xsl.xsl (No such file
or directory)
Exception in component tXSLT_1 (xml_validation)
javax.xml.transform.TransformerConfigurationException: Failed to compile stylesheet. 1 error detected.
at net.sf.saxon.PreparedStylesheet.prepare(PreparedStylesheet.java:176)
at net.sf.saxon.TransformerFactoryImpl.newTemplates(TransformerFactoryImpl.java:139)
at net.sf.saxon.TransformerFactoryImpl.newTransformer(TransformerFactoryImpl.java:91)
at pymts_batch.xml_validation_0_1.xml_validation.tFixedFlowInput_1Process(xml_validation.java:1029)
at pymts_batch.xml_validation_0_1.xml_validation.runJobInTOS(xml_validation.java:6118)
at pymts_batch.xml_validation_0_1.xml_validation.main(xml_validation.java:5855)

[statistics] disconnected

Job xml_validation ended at 07:10 03/06/2020. [exit code=1]

Re: XSLT component Issue

akumar2301 — Wed, 03 Jun 2020 17:28:03 GMT

Hello
the path specified is not available or there is no such file on this path. Try 1st to put these files in local drive and check if it works.

/Client/Z$/file_processing_path/test_xsl.xsl (No such file
or directory)

Re: XSLT component Issue

gtaware — Wed, 03 Jun 2020 17:39:52 GMT

Thanks . Actually Error Looks like that I am not referring correct XLS file as per provided path or File is not present .

But it is not like that . I am actually taking a file directly from my Local drive .

Here is attached screenshot .

XSLT JOB-1.png

Re: XSLT component Issue

akumar2301 — Wed, 03 Jun 2020 17:53:45 GMT

Hello ,

This is network drive . Can you put in your C:// or E:// drive and try once.

Abhishek

Re: XSLT component Issue

gtaware — Wed, 03 Jun 2020 18:25:06 GMT

I kept the files on C drive but throws same error :

As I said earlier , this error is not actually file missing error . It is something else . But it is showing that file is missing .

[statistics] connecting to socket on port 3888
[statistics] connected
[FATAL]: pymts_batch.xml_validation_0_1.xml_validation - tXSLT_1 Failed to compile stylesheet. 1 error detected.
javax.xml.transform.TransformerConfigurationException: Failed to compile stylesheet. 1 error detected.
at net.sf.saxon.PreparedStylesheet.prepare(PreparedStylesheet.java:176)
at net.sf.saxon.TransformerFactoryImpl.newTemplates(TransformerFactoryImpl.java:139)
at net.sf.saxon.TransformerFactoryImpl.newTransformer(TransformerFactoryImpl.java:91)
at pymts_batch.xml_validation_0_1.xml_validation.tFixedFlowInput_1Process(xml_validation.java:1029)
at pymts_batch.xml_validation_0_1.xml_validation.runJobInTOS(xml_validation.java:6118)
at pymts_batch.xml_validation_0_1.xml_validation.main(xml_validation.java:5855)
Error
java.io.FileNotFoundException: /Client/C$/Users/69645793/Downloads/test_xsl.xsl (No such
file or directory)
Exception in component tXSLT_1 (xml_validation)
javax.xml.transform.TransformerConfigurationException: Failed to compile stylesheet. 1 error detected.
at net.sf.saxon.PreparedStylesheet.prepare(PreparedStylesheet.java:176)
at net.sf.saxon.TransformerFactoryImpl.newTemplates(TransformerFactoryImpl.java:139)
at net.sf.saxon.TransformerFactoryImpl.newTransformer(TransformerFactoryImpl.java:91)
at pymts_batch.xml_validation_0_1.xml_validation.tFixedFlowInput_1Process(xml_validation.java:1029)
at pymts_batch.xml_validation_0_1.xml_validation.runJobInTOS(xml_validation.java:6118)
at pymts_batch.xml_validation_0_1.xml_validation.main(xml_validation.java:5855)

[statistics] disconnected