Originally posted by: mohit121happy

Hi,

We are processing very large XML file from WTX for transformation.

If some of the tags are missing in the XML, then we need to send  Exception to Message Broker along with the Information which is present in one of the tag(lets say Message ID).

What is the best possible way to do it?

For eg : If we have an XML file which have start and end tag is missing, so in this case it is throwing the XML Parser ERROR. But what if we have to extract the information from one of the tag which is present in that XML(lets sat Message ID) . How can we Extract soch information from that breaked XML files with missing tags.

Also please suggest a way with which we can share the detailed message(logs) to Message Broker when some of the XML tag is missing in the Input file.

Currently it is throwing either SUCCESS or FAILURE

Originally posted by: paul.brett

Your MB flow could call a dummy map with no input validation.  The dummy map could then use a RUN() or perhaps the XVALIDATE() function to determine if the data is valid, and if not, use the FIND(), LEFT(), RIGHT() and MID() functions to extract the Message ID from the text blob, then use a FAIL() function pass this back to the MB flow.

Thank-you

Paul

Follow me on Twitter

Originally posted by: mohit121happy

Hi Paul,

We are doing Syntax check for XML file and sending the response to WMB after extracting the message id in the same way as per your suggestion above.
We are calling the sub map (Syntax_check)from the first Output card of our caller map(Caller_Map) with Audit trace on.This sub map(Syntax_check) is doing the syntax check and we are putting the Message ID in Audit trace log(Text Blob) with the help of Data audit setting in Syntax_check map.
To extract the Message ID we are calling the another map Get_Message_ID from the next Output card of Caller_Map.
Sub Map - Get_Message_ID is reading the Text Blob of Audit trace to fetch the Message ID with the help of WORD function which later on we are sending as a response to WMB via another Output card.

Issue : In Response to WMB some of the characters of Message ID are replaced with Junk characters.
Message ID should be same like the one present in Input file.

Please suggest how can be the correct Message ID can be shared with WMB. What is going wrong here?