IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
  • 1.  & Special Char in xml version tag

    Posted Wed August 26, 2015 08:23 PM

    Hi,

    I am encountered with issue while parsing the xml to document. I am fetching the xml from the DB queues by http url posters and trying to convert that xml to documnet for further processing. But the xml what i get is with the special character in main xml vesrion tag like &S<?xml version="1.0" encoding="UTF-8" ?> . This first & (amp) is causing mal formed error.

    I know this is coming from our source but, i am unable to find the root cause of these scenarios.

    Please share if any one came accross this issue before

    Thanks
    Shafi :idea:


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 2.  RE: & Special Char in xml version tag

    Posted Thu August 27, 2015 06:40 AM

    If you are sure about the special character is from the source system, inform them about it. (You might have already done this :slight_smile: )

    OR

    Before processing the xml in IS remove the special characters by a replace function and then process it further.


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 3.  RE: & Special Char in xml version tag

    Posted Thu August 27, 2015 04:39 PM

    did you try setting encoding when you invoke pub.xml:xmlStringToXMLNode
    may solve your issue


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: & Special Char in xml version tag

    Posted Thu August 27, 2015 05:50 PM

    Hi All,

    As i mentioned before, this is not a webMethods issue. I am trying to figure out what must caused the clob content to create a special character when we convert the bytes to string (xml).

    Process

    1. DB AQ – > clob content – >https url poster – > bytes → string (xml) with ‘&’ special char.

    Thanks
    Shafi :idea:


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 5.  RE: & Special Char in xml version tag

    Posted Fri August 28, 2015 12:13 PM

    Hi Shafi,

    did you consider that the special character has been already at the sender´s side before inserting into the database?

    If so continue the research at their side.

    If not can you try to find out where the special character gets added on the way from db to your string.

    Regards,
    Holger


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB