topic Re: Error with tESBConsumer when converting the XML response into a "Document" in Talend Studio

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

RJCL — Mon, 18 Jun 2018 11:51:01 GMT

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

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

fdenis — Mon, 18 Jun 2018 13:38:59 GMT

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

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

RJCL — Mon, 18 Jun 2018 15:23:56 GMT

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.

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

fdenis — Mon, 18 Jun 2018 15:57:19 GMT

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

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

RJCL — Mon, 18 Jun 2018 16:31:15 GMT

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