| Author |
Message
|
| wmb_wps_soa |
 Posted: Mon Jan 07, 2013 9:42 am Post subject: WMB8 FileInputNode - Issue with Parsed Record Sequence |
 |
|
Acolyte
Joined: 19 Feb 2010
Posts: 65
Location: Detroit,Michigan,USA.
|
Hi,
I am having issues with WMB8 FileInput node as the node is not propagating message for each record in the input XML file. I have the message flow with message domain XMLNSC, message set generated from xsd, Record and Elements --> Record detection as Parsed Record Sequence.
Input XML file:
<PayLoad>
<Header>
<TransName></ TransName>
</ Header>
<Details>
<Name>Testing1</ Name>
</Details>
<Details>
<Name>Testing2</ Name>
</Details>
<Details>
<Name>Testing3</ Name>
</Details>
</PayLoad>
When I test the flow with this inputdata, FileInput node is propagating the entire file into next node. But, i wanted it to propagate message for each Details in the input XML file. Can anybody help me to find what I am missing here?
Thank you All, |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Mon Jan 07, 2013 9:49 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Jan 07, 2013 9:50 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Just for interest, why are you using parsed record sequence rather than simply itterating through the XML document?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| wmb_wps_soa |
| Posted: Mon Jan 07, 2013 11:20 am Post subject: |
|
|
Acolyte
Joined: 19 Feb 2010
Posts: 65
Location: Detroit,Michigan,USA.
|
Hi Sirlancelotlinc,
The settings on Records and Elements are:
Record detection : Parsed Record Sequence.
Hi Vitor,
The input file comes with the size of 20MB, so thought of using FileInputNode to do the propagation for each record instead of doing that in the ESQL code. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Jan 07, 2013 11:31 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
20 MB is not so large. Is there possible size growth in those files over time? Or, will they always be 20 MB ?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| wmb_wps_soa |
| Posted: Mon Jan 07, 2013 11:46 am Post subject: |
|
|
Acolyte
Joined: 19 Feb 2010
Posts: 65
Location: Detroit,Michigan,USA.
|
Yes, there is a high possibility that the size grows along with the business growth.
Thank you |
|
| Back to top |
|
|
| Esa |
| Posted: Mon Jan 07, 2013 11:50 am Post subject: Re: WMB8 FileInputNode - Issue with Parsed Record Sequence |
|
|
Grand Master
Joined: 22 May 2008
Posts: 1387
Location: Finland
|
| wmb_wps_soa wrote: |
When I test the flow with this inputdata, FileInput node is propagating the entire file into next node. But, i wanted it to propagate message for each Details in the input XML file. Can anybody help me to find what I am missing here?
|
What happens if you select 'Skip first record'?
What happens if you try a test file that does not have Header element? |
|
| Back to top |
|
|
| wmb_wps_soa |
| Posted: Mon Jan 07, 2013 11:56 am Post subject: |
|
|
Acolyte
Joined: 19 Feb 2010
Posts: 65
Location: Detroit,Michigan,USA.
|
Hi Esa,
I tried with 'Skip First Records' but nothing happened, as the entire XML file is being passed to next node, its NOT doing record by record breakup.
I do remember that I tried without header also, and it did not worked either. But I can try again that. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Jan 07, 2013 11:57 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
What is your specification for Custom delimiter ? Or, how are you telling the FileInput node to delineate between records ?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| wmb_wps_soa |
| Posted: Mon Jan 07, 2013 12:03 pm Post subject: |
|
|
Acolyte
Joined: 19 Feb 2010
Posts: 65
Location: Detroit,Michigan,USA.
|
Hi lancelotlinc,
I dont have any specification for custom delimiter. I have defined "Details" as mult-occrance in the messageset. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Jan 07, 2013 12:33 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Since this is not working, you have two options, as I see it:
1. Define a custom delimiter, -or-
2. Open a PMR to seek IBM advice on why the FileInput node is not recognizing the multi-occurance.
Good luck.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Jan 07, 2013 2:20 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| wmb_wps_soa wrote: |
| The input file comes with the size of 20MB, so thought of using FileInputNode to do the propagation for each record instead of doing that in the ESQL code. |
You might want to review this sample
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| kimbert |
| Posted: Mon Jan 07, 2013 3:27 pm Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
No need for a PMR - the FileInput node cannot automatically split this type of input document. ESQL can do it very easily, though.
1. Process the header
2. Iterate over the Details array, deleting the message tree after each iteration of the loopo
3. Construct the output bit stream for each iteration under OutputRoot.BLOB.BLOB ( and/or else do whatever else the flow requires )
See the link to the Large Message sample in the previous post for more details. |
|
| Back to top |
|
|
|
|
