Error with tESBConsumer when converting the XML response into a "Document"

Four Stars

Error with tESBConsumer when converting the XML response into a "Document"

I am receiving the following error:

 

         Could not parse the XML stream caused by: com.ctc.wstx.exc.WstxUnexpectedCharException: Illegal character ((CTRL-CHAR, code 26))

         at [row,col {unknown-source}]: [1,1818].

 

How can I solve the problem?
      Would it be possible to change the incorrect character before the response becomes an XML DOCUMENT?

 

Any solution / idea will be appreciated.

 

Thank you

 

Twelve Stars

Re: Error with tESBConsumer when converting the XML response into a "Document"

use a low level text editor to edit your xml fine an check than xml charcode is inline with xml charcode definition.

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: Error with tESBConsumer when converting the XML response into a "Document"

Hello

 

Thank you for your answer.

 

I know what the wrong character is, but I can not (I do not know how) remove it before the TESBConsumer component tries to convert the Web Service response to a DOCUMENT TYPE.

 

Thank you again.

Twelve Stars

Re: Error with tESBConsumer when converting the XML response into a "Document"

can you debug xml generator? (best way)
second way, save the xml, open xml in text mode replace char and reopen

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: Error with tESBConsumer when converting the XML response into a "Document"

Yes

I know what character is the problem and where is in the XML response. But I want to solve the problem for future cases. It is sure that it will continue happening.

 

   The web service where I connect, occasionally, returns characters that are not correct for an XML. 

   The TESBCconsumer component always, before returning control to the next component, converts the XML result into a Document type object.

 

I would like to change the character before the conversion to avoid the error.

 

Thank you

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch