| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| Fixed length to XML |
« View previous topic :: View next topic » |
| Author |
Message
|
| giorginus80 |
 Posted: Wed Jul 09, 2008 1:13 am Post subject: |
 |
|
Centurion
Joined: 08 Jul 2008
Posts: 124
Location: Rome, Italy
|
| kimbert wrote: |
Please insert a Trace node and post the output that you are getting. Or if you are getting error messages, post those.
If you're on v6.1, please also take a debug-level user trace of the parse and post that. |
I think it's this:
| Code: |
Timestamps are formatted in local time, 120 minutes past GMT.
Trace written by version ; formatter version 6102
2008-07-09 11:32:41.366413 41 UserTrace BIP2632I: Message received and propagated to 'out' terminal of MQ input node 'it.test.CSV2XML.In'.
2008-07-09 11:32:41.366905 41 UserTrace BIP6060I: Parser type ''Properties'' created on behalf of node 'it.test.CSV2XML.In' to handle portion of incoming message of length 0 bytes beginning at offset '0'.
2008-07-09 11:32:41.366943 41 UserTrace BIP6061I: Parser type ''MQMD'' created on behalf of node 'it.test.CSV2XML.In' to handle portion of incoming message of length '364' bytes beginning at offset '0'. Parser type selected based on value ''MQHMD'' from previous parser.
2008-07-09 11:32:41.367397 41 UserTrace BIP6061I: Parser type ''MRM'' created on behalf of node 'it.test.CSV2XML.In' to handle portion of incoming message of length '214' bytes beginning at offset '364'. Parser type selected based on value ''MRM'' from previous parser.
2008-07-09 11:32:41.368736 41 UserTrace BIP5616I: '25' bytes from byte '1' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:41.368949 41 UserTrace BIP5616I: '25' bytes from byte '28' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:41.368949 41 UserTrace BIP5616I: '25' bytes from byte '55' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:41.368949 41 UserTrace BIP5616I: '25' bytes from byte '82' were matched using data pattern ''[9]{3}[a-zA-Z0-9\s]{22}'' for ''resume''.
2008-07-09 11:32:41.369552 41 UserTrace BIP5616I: '25' bytes from byte '109' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:41.369647 41 UserTrace BIP5616I: '25' bytes from byte '136' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:41.369781 41 UserTrace BIP5616I: '25' bytes from byte '163' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:41.369880 41 UserTrace BIP5616I: '25' bytes from byte '190' were matched using data pattern ''[9]{3}[a-zA-Z0-9\s]{22}'' for ''resume''.
2008-07-09 11:32:41.369934 41 UserTrace BIP5607I: The end of the bit stream has been reached at byte '215'.
2008-07-09 11:32:41.369937 41 UserTrace BIP5607I: The end of the bit stream has been reached at byte '215'.
2008-07-09 11:32:47.333816 41 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''BEGIN ... END;'' at ('it.test.CSV2XML_Trasformation.Main', '2.2').
2008-07-09 11:32:47.334033 41 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''CopyEntireMessage();'' at ('it.test.CSV2XML_Trasformation.Main', '3.3').
2008-07-09 11:32:47.334140 41 UserTrace BIP2538I: Node 'it.test.CSV2XML.Trasformation': Evaluating expression ''CopyEntireMessage()'' at ('it.test.CSV2XML_Trasformation.Main', '3.8').
2008-07-09 11:32:47.334201 41 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''BEGIN ... END;'' at ('it.test.CSV2XML_Trasformation.CopyEntireMessage', '1.39').
2008-07-09 11:32:47.334232 41 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''SET OutputRoot = InputRoot;'' at ('it.test.CSV2XML_Trasformation.CopyEntireMessage', '2.3').
2008-07-09 11:32:47.334262 41 UserTrace BIP2539I: Node 'it.test.CSV2XML.Trasformation': Evaluating expression ''InputRoot'' at ('it.test.CSV2XML_Trasformation.CopyEntireMessage', '2.20'). This resolved to ''InputRoot''. The result was ''ROW... Root Element Type=16777216 NameSpace='' Name='Root' Value=NULL''.
2008-07-09 11:32:47.334274 41 UserTrace BIP2568I: Node 'it.test.CSV2XML.Trasformation': Copying sub-tree from ''InputRoot'' to ''OutputRoot''.
2008-07-09 11:32:47.334461 41 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''SET OutputRoot.Properties.MessageFormat = 'XML1';'' at ('it.test.CSV2XML_Trasformation.Main', '4.3').
2008-07-09 11:32:47.334854 41 UserTrace BIP2566I: Node 'it.test.CSV2XML.Trasformation': Assigning value '''XML1''' to field / variable ''OutputRoot.Properties.MessageFormat''.
2008-07-09 11:32:47.334899 41 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''RETURN TRUE;'' at ('it.test.CSV2XML_Trasformation.Main', '5.3').
2008-07-09 11:32:47.335018 41 UserTrace BIP4007I: Message propagated to 'out' terminal of node 'it.test.CSV2XML.Trasformation'.
2008-07-09 11:32:47.335079 41 UserTrace BIP5616I: '25' bytes from byte '1' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:47.335376 41 UserTrace BIP5616I: '25' bytes from byte '28' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:47.335380 41 UserTrace BIP5616I: '25' bytes from byte '55' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:47.335731 41 UserTrace BIP5616I: '25' bytes from byte '82' were matched using data pattern ''[9]{3}[a-zA-Z0-9\s]{22}'' for ''resume''.
2008-07-09 11:32:47.335807 41 UserTrace BIP5616I: '25' bytes from byte '109' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:47.335895 41 UserTrace BIP5616I: '25' bytes from byte '136' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:47.335971 41 UserTrace BIP5616I: '25' bytes from byte '163' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 11:32:47.336105 41 UserTrace BIP5616I: '25' bytes from byte '190' were matched using data pattern ''[9]{3}[a-zA-Z0-9\s]{22}'' for ''resume''.
2008-07-09 11:32:47.336185 41 UserTrace BIP5607I: The end of the bit stream has been reached at byte '215'.
2008-07-09 11:32:47.336219 41 UserTrace BIP5607I: The end of the bit stream has been reached at byte '215'.
2008-07-09 11:32:47.336387 41 UserTrace BIP5494I: The logical tree is now being matched to the message model.
2008-07-09 11:32:47.336456 41 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(1 of unbounded)''.
2008-07-09 11:32:47.336505 41 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(1 of unbounded)/person(1 of unbounded)''.
2008-07-09 11:32:47.336540 41 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(1 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 11:32:47.336780 41 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(1 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 11:32:47.336814 41 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(1 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 11:32:47.336845 41 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(2 of unbounded)''.
2008-07-09 11:32:47.336887 41 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(2 of unbounded)/person(1 of unbounded)''.
2008-07-09 11:32:47.336944 41 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(2 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 11:32:47.336978 41 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(2 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 11:32:47.337013 41 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(2 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 11:32:47.337043 41 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(3 of unbounded)''.
2008-07-09 11:32:47.337074 41 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(3 of unbounded)/person(1 of unbounded)''.
2008-07-09 11:32:47.337104 41 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(3 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 11:32:47.337146 41 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(3 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 11:32:47.337177 41 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(3 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 11:32:47.337219 41 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(4 of unbounded)''.
2008-07-09 11:32:47.337253 41 UserTrace BIP5564I: Item ''resume'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(4 of unbounded)/resume''.
2008-07-09 11:32:47.337291 41 UserTrace BIP5564I: Item ''sector'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(4 of unbounded)/resume/sector''.
2008-07-09 11:32:47.337322 41 UserTrace BIP5564I: Item ''param1'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(4 of unbounded)/resume/param1''.
2008-07-09 11:32:47.337322 41 UserTrace BIP5564I: Item ''param2'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(4 of unbounded)/resume/param2''.
2008-07-09 11:32:47.337345 41 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(5 of unbounded)''.
2008-07-09 11:32:47.337345 41 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(5 of unbounded)/person(1 of unbounded)''.
2008-07-09 11:32:47.337345 41 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(5 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 11:32:47.337383 41 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(5 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 11:32:47.337387 41 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(5 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 11:32:47.337387 41 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(6 of unbounded)''.
2008-07-09 11:32:47.337474 41 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(6 of unbounded)/person(1 of unbounded)''.
2008-07-09 11:32:47.337711 41 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(6 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 11:32:47.337745 41 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(6 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 11:32:47.337779 41 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(6 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 11:32:47.337810 41 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(7 of unbounded)''.
2008-07-09 11:32:47.337879 41 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(7 of unbounded)/person(1 of unbounded)''.
2008-07-09 11:32:47.337917 41 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(7 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 11:32:47.337947 41 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(7 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 11:32:47.337982 41 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(7 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 11:32:47.338012 41 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(8 of unbounded)''.
2008-07-09 11:32:47.338047 41 UserTrace BIP5564I: Item ''resume'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(8 of unbounded)/resume''.
2008-07-09 11:32:47.338077 41 UserTrace BIP5564I: Item ''sector'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(8 of unbounded)/resume/sector''.
2008-07-09 11:32:47.338108 41 UserTrace BIP5564I: Item ''param1'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(8 of unbounded)/resume/param1''.
2008-07-09 11:32:47.338165 41 UserTrace BIP5564I: Item ''param2'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(8 of unbounded)/resume/param2''.
2008-07-09 11:32:47.338886 41 UserTrace BIP2638I: The MQ output node 'it.test.CSV2XML.Out' attempted to write a message to queue ''codaOut'' connected to queue manager ''''. The MQCC was '0' and the MQRC was '0'.
2008-07-09 11:32:47.338920 41 UserTrace BIP2622I: Message successfully output by output node 'it.test.CSV2XML.Out' to queue ''codaOut'' on queue manager ''''.
Threads encountered in this trace:
41
|
and this is my messageset
recordsType has DES Use data pattern:
personType data pattern [a-zA-Z0-9\s]{22}[9]{3}
resumeType data pattern [9]{3}[a-zA-Z0-9\s]{22} |
|
| Back to top |
|
 |
| kimbert |
| Posted: Wed Jul 09, 2008 1:37 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5543
Location: Southampton
|
Yes - that's what I was after. Please remember this trick, and use it for diagnosing TDS problems.
I would also like to see the Trace node output. Did you get that?
- Insert a Trace node in your message flow
- Set the Pattern to '${Root}'
- Set Destination to User Trace ( its the default anyway, I think )
Then your user trace will show you the message tree.
I still don't see the problem. It looks as if the parser is distinguishing between person and resume records, and they are grouped under multiple Record elements. That seems to be exactly what you asked for in your previous post
Please post an example of the message tree that you want to obtain, and indicate where the current message tree is incorrect. Sorry if I'm being a bit slow. |
|
| Back to top |
|
|
| giorginus80 |
| Posted: Wed Jul 09, 2008 1:58 am Post subject: |
|
|
Centurion
Joined: 08 Jul 2008
Posts: 124
Location: Rome, Italy
|
| kimbert wrote: |
Yes - that's what I was after. Please remember this trick, and use it for diagnosing TDS problems.
I would also like to see the Trace node output. Did you get that?
- Insert a Trace node in your message flow
- Set the Pattern to '${Root}'
- Set Destination to User Trace ( its the default anyway, I think )
Then your user trace will show you the message tree.
I still don't see the problem. It looks as if the parser is distinguishing between person and resume records, and they are grouped under multiple Record elements. That seems to be exactly what you asked for in your previous post
Please post an example of the message tree that you want to obtain, and indicate where the current message tree is incorrect. Sorry if I'm being a bit slow. |
This is the User Trace I put a trace with pattern ${Root} and set to debug the execution grup the output is :
| Code: |
Timestamps are formatted in local time, 120 minutes past GMT.
Trace written by version ; formatter version 6102
2008-07-09 12:18:40.696834 49 UserTrace BIP2632I: Message received and propagated to 'out' terminal of MQ input node 'it.test.CSV2XML.In'.
2008-07-09 12:18:40.697204 49 UserTrace BIP6060I: Parser type ''Properties'' created on behalf of node 'it.test.CSV2XML.In' to handle portion of incoming message of length 0 bytes beginning at offset '0'.
2008-07-09 12:18:40.697219 49 UserTrace BIP6061I: Parser type ''MQMD'' created on behalf of node 'it.test.CSV2XML.In' to handle portion of incoming message of length '364' bytes beginning at offset '0'. Parser type selected based on value ''MQHMD'' from previous parser.
2008-07-09 12:18:40.697559 49 UserTrace BIP6061I: Parser type ''MRM'' created on behalf of node 'it.test.CSV2XML.In' to handle portion of incoming message of length '214' bytes beginning at offset '364'. Parser type selected based on value ''MRM'' from previous parser.
2008-07-09 12:18:40.697628 49 UserTrace BIP2539I: Node 'it.test.CSV2XML.Trace': Evaluating expression ''Root'' at ('', '1.3'). This resolved to ''Root''. The result was ''ROW... Root Element Type=16777216 NameSpace='' Name='Root' Value=NULL''.
2008-07-09 12:18:40.698501 49 UserTrace BIP5616I: '25' bytes from byte '1' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:40.698673 49 UserTrace BIP5616I: '25' bytes from byte '28' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:40.698749 49 UserTrace BIP5616I: '25' bytes from byte '55' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:40.698871 49 UserTrace BIP5616I: '25' bytes from byte '82' were matched using data pattern ''[9]{3}[a-zA-Z0-9\s]{22}'' for ''resume''.
2008-07-09 12:18:40.698936 49 UserTrace BIP5616I: '25' bytes from byte '109' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:40.699016 49 UserTrace BIP5616I: '25' bytes from byte '136' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:40.699119 49 UserTrace BIP5616I: '25' bytes from byte '163' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:40.699192 49 UserTrace BIP5616I: '25' bytes from byte '190' were matched using data pattern ''[9]{3}[a-zA-Z0-9\s]{22}'' for ''resume''.
2008-07-09 12:18:40.699256 49 UserTrace BIP5607I: The end of the bit stream has been reached at byte '215'.
2008-07-09 12:18:40.699298 49 UserTrace BIP5607I: The end of the bit stream has been reached at byte '215'.
2008-07-09 12:18:40.699623 49 UserTrace BIP4067I: Message propagated to output terminal for trace node 'it.test.CSV2XML.Trace'.
The trace node 'it.test.CSV2XML.Trace' has received a message and is propagating it to any nodes connected to its output terminal.
No user action required.
2008-07-09 12:18:47.045272 49 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''BEGIN ... END;'' at ('it.test.CSV2XML_Trasformation.Main', '2.2').
2008-07-09 12:18:47.045406 49 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''CopyEntireMessage();'' at ('it.test.CSV2XML_Trasformation.Main', '3.3').
2008-07-09 12:18:47.045478 49 UserTrace BIP2538I: Node 'it.test.CSV2XML.Trasformation': Evaluating expression ''CopyEntireMessage()'' at ('it.test.CSV2XML_Trasformation.Main', '3.8').
2008-07-09 12:18:47.045543 49 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''BEGIN ... END;'' at ('it.test.CSV2XML_Trasformation.CopyEntireMessage', '1.39').
2008-07-09 12:18:47.045585 49 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''SET OutputRoot = InputRoot;'' at ('it.test.CSV2XML_Trasformation.CopyEntireMessage', '2.3').
2008-07-09 12:18:47.045661 49 UserTrace BIP2539I: Node 'it.test.CSV2XML.Trasformation': Evaluating expression ''InputRoot'' at ('it.test.CSV2XML_Trasformation.CopyEntireMessage', '2.20'). This resolved to ''InputRoot''. The result was ''ROW... Root Element Type=16777216 NameSpace='' Name='Root' Value=NULL''.
2008-07-09 12:18:47.045703 49 UserTrace BIP2568I: Node 'it.test.CSV2XML.Trasformation': Copying sub-tree from ''InputRoot'' to ''OutputRoot''.
2008-07-09 12:18:47.045749 49 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''SET OutputRoot.Properties.MessageFormat = 'XML1';'' at ('it.test.CSV2XML_Trasformation.Main', '4.3').
2008-07-09 12:18:47.045879 49 UserTrace BIP2566I: Node 'it.test.CSV2XML.Trasformation': Assigning value '''XML1''' to field / variable ''OutputRoot.Properties.MessageFormat''.
2008-07-09 12:18:47.045909 49 UserTrace BIP2537I: Node 'it.test.CSV2XML.Trasformation': Executing statement ''RETURN TRUE;'' at ('it.test.CSV2XML_Trasformation.Main', '5.3').
2008-07-09 12:18:47.046226 49 UserTrace BIP4007I: Message propagated to 'out' terminal of node 'it.test.CSV2XML.Trasformation'.
2008-07-09 12:18:47.046710 49 UserTrace BIP5616I: '25' bytes from byte '1' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:47.046749 49 UserTrace BIP5616I: '25' bytes from byte '28' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:47.046752 49 UserTrace BIP5616I: '25' bytes from byte '55' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:47.046890 49 UserTrace BIP5616I: '25' bytes from byte '82' were matched using data pattern ''[9]{3}[a-zA-Z0-9\s]{22}'' for ''resume''.
2008-07-09 12:18:47.046955 49 UserTrace BIP5616I: '25' bytes from byte '109' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:47.047328 49 UserTrace BIP5616I: '25' bytes from byte '136' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:47.047405 49 UserTrace BIP5616I: '25' bytes from byte '163' were matched using data pattern ''[a-zA-Z0-9\s]{22}[9]{3}'' for ''person''.
2008-07-09 12:18:47.047538 49 UserTrace BIP5616I: '25' bytes from byte '190' were matched using data pattern ''[9]{3}[a-zA-Z0-9\s]{22}'' for ''resume''.
2008-07-09 12:18:47.047645 49 UserTrace BIP5607I: The end of the bit stream has been reached at byte '215'.
2008-07-09 12:18:47.047679 49 UserTrace BIP5607I: The end of the bit stream has been reached at byte '215'.
2008-07-09 12:18:47.047718 49 UserTrace BIP5494I: The logical tree is now being matched to the message model.
2008-07-09 12:18:47.047748 49 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(1 of unbounded)''.
2008-07-09 12:18:47.047748 49 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(1 of unbounded)/person(1 of unbounded)''.
2008-07-09 12:18:47.047817 49 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(1 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 12:18:47.048110 49 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(1 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 12:18:47.048145 49 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(1 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 12:18:47.048187 49 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(2 of unbounded)''.
2008-07-09 12:18:47.048240 49 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(2 of unbounded)/person(1 of unbounded)''.
2008-07-09 12:18:47.048271 49 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(2 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 12:18:47.048305 49 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(2 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 12:18:47.048351 49 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(2 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 12:18:47.048381 49 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(3 of unbounded)''.
2008-07-09 12:18:47.048412 49 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(3 of unbounded)/person(1 of unbounded)''.
2008-07-09 12:18:47.048446 49 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(3 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 12:18:47.048477 49 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(3 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 12:18:47.048530 49 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(3 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 12:18:47.048564 49 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(4 of unbounded)''.
2008-07-09 12:18:47.048595 49 UserTrace BIP5564I: Item ''resume'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(4 of unbounded)/resume''.
2008-07-09 12:18:47.048629 49 UserTrace BIP5564I: Item ''sector'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(4 of unbounded)/resume/sector''.
2008-07-09 12:18:47.048664 49 UserTrace BIP5564I: Item ''param1'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(4 of unbounded)/resume/param1''.
2008-07-09 12:18:47.048698 49 UserTrace BIP5564I: Item ''param2'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(4 of unbounded)/resume/param2''.
2008-07-09 12:18:47.048698 49 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(5 of unbounded)''.
2008-07-09 12:18:47.048717 49 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(5 of unbounded)/person(1 of unbounded)''.
2008-07-09 12:18:47.048717 49 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(5 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 12:18:47.048717 49 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(5 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 12:18:47.048755 49 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(5 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 12:18:47.048763 49 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(6 of unbounded)''.
2008-07-09 12:18:47.048763 49 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(6 of unbounded)/person(1 of unbounded)''.
2008-07-09 12:18:47.048763 49 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(6 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 12:18:47.048763 49 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(6 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 12:18:47.049072 49 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(6 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 12:18:47.049125 49 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(7 of unbounded)''.
2008-07-09 12:18:47.049160 49 UserTrace BIP5564I: Item ''person'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(7 of unbounded)/person(1 of unbounded)''.
2008-07-09 12:18:47.049205 49 UserTrace BIP5564I: Item ''name'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(7 of unbounded)/person(1 of unbounded)/name''.
2008-07-09 12:18:47.049240 49 UserTrace BIP5564I: Item ''surname'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(7 of unbounded)/person(1 of unbounded)/surname''.
2008-07-09 12:18:47.049270 49 UserTrace BIP5564I: Item ''code'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(7 of unbounded)/person(1 of unbounded)/code''.
2008-07-09 12:18:47.049304 49 UserTrace BIP5564I: Item ''record'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(8 of unbounded)''.
2008-07-09 12:18:47.049339 49 UserTrace BIP5564I: Item ''resume'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(8 of unbounded)/resume''.
2008-07-09 12:18:47.049373 49 UserTrace BIP5564I: Item ''sector'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(8 of unbounded)/resume/sector''.
2008-07-09 12:18:47.049430 49 UserTrace BIP5564I: Item ''param1'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(8 of unbounded)/resume/param1''.
2008-07-09 12:18:47.049461 49 UserTrace BIP5564I: Item ''param2'' from the logical tree has matched with the message model as ''[MESSAGE]_FixedFile/record(8 of unbounded)/resume/param2''.
2008-07-09 12:18:47.050144 49 UserTrace BIP2638I: The MQ output node 'it.test.CSV2XML.Out' attempted to write a message to queue ''codaOut'' connected to queue manager ''''. The MQCC was '0' and the MQRC was '0'.
2008-07-09 12:18:47.050178 49 UserTrace BIP2622I: Message successfully output by output node 'it.test.CSV2XML.Out' to queue ''codaOut'' on queue manager ''''.
Threads encountered in this trace:
41 49
|
My MessageSet is this
personType has DES Fixed Length:
name length 10 legths units Bytes
surname length 10 legths units Bytes
code length 5 legths units Bytes
resumeType has DES Fixed Length:
sector length 5 legths units Bytes
param1 length 15 legths units Bytes
param2 length 5 legths units Bytes
recordsType has DES Use data pattern and Group delimiter <CR><LF>:
personType data pattern [a-zA-Z0-9\s]{22}[9]{3}
resumeType data pattern [9]{3}[a-zA-Z0-9\s]{22}
fileType has DES FixedLength
My input in the queue is:
| Code: |
GIORGIO FEDERICI 88999
PAOLO CRETI 83999
FEDERICO CILICHI 23999
99973UURIIRURJKNFDJFDJFDI
ROBERTA LIPARI 98999
STEFANO DESANTICST82999
GIORGIANAIPILACCIN 92999
999ADAOIUUUUIU9823792JDJD
|
and the output is
| Code: |
<?xml version="1.0"?>
<test:FixedFile xmlns:test="http://www.test.it" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<record>
<person>
<name>GIORGIO </name>
<surname>FEDERICI </surname>
<code>88999</code>
</person>
</record>
<record>
<person>
<name>PAOLO </name>
<surname>CRETI </surname>
<code>83999</code>
</person>
</record>
<record>
<person>
<name>FEDERICO </name>
<surname>CILICHI </surname>
<code>23999</code>
</person>
</record>
<record>
<resume>
<sector>99973</sector>
<param1>UURIIRURJKNFDJF</param1>
<param2>DJFDI</param2>
</resume>
</record>
<record>
<person>
<name>ROBERTA </name>
<surname>LIPARI </surname>
<code>98999</code>
</person>
</record>
<record>
<person>
<name>STEFANO </name>
<surname>DESANTICST</surname>
<code>82999</code>
</person>
</record>
<record>
<person>
<name>GIORGIANAI</name>
<surname>PILACCIN </surname>
<code>92999</code>
</person>
</record>
<record>
<resume>
<sector>999AD</sector>
<param1>AOIUUUUIU982379</param1>
<param2>2JDJD</param2>
</resume>
</record>
</test:FixedFile>
|
and I can't do this output 'record' with 1 or more 'person' and 1 'resume' as described in messageSet:
| Code: |
<?xml version="1.0"?>
<test:FixedFile xmlns:test="http://www.test.it" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<record>
<person>
<name>GIORGIO </name>
<surname>FEDERICI </surname>
<code>88999</code>
</person>
<person>
<name>PAOLO </name>
<surname>CRETI </surname>
<code>83999</code>
</person>
<person>
<name>FEDERICO </name>
<surname>CILICHI </surname>
<code>23999</code>
</person>
<resume>
<sector>99973</sector>
<param1>UURIIRURJKNFDJF</param1>
<param2>DJFDI</param2>
</resume>
</record>
<record>
<person>
<name>ROBERTA </name>
<surname>LIPARI </surname>
<code>98999</code>
</person>
<person>
<name>STEFANO </name>
<surname>DESANTICST</surname>
<code>82999</code>
</person>
<person>
<name>GIORGIANAI</name>
<surname>PILACCIN </surname>
<code>92999</code>
</person>
<resume>
<sector>999AD</sector>
<param1>AOIUUUUIU982379</param1>
<param2>2JDJD</param2>
</resume>
</record>
</test:FixedFile>
|
I tried everything, I don't know If I missed terminator or group terminator, or delimiter in some type. |
|
| Back to top |
|
|
| jeeth_m |
| Posted: Wed Jul 09, 2008 3:05 am Post subject: |
|
|
Voyager
Joined: 21 Jan 2002
Posts: 93
|
Hi giorginus80,
In your input message persone is coming 3 times and then one resume.
Is this the case all the time? Or it can appear any number of time?
Regards,
Jeeth |
|
| Back to top |
|
|
| kimbert |
| Posted: Wed Jul 09, 2008 4:05 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5543
Location: Southampton
|
| Quote: |
2008-07-09 12:18:40.699623 49 UserTrace BIP4067I: Message propagated to output terminal for trace node 'it.test.CSV2XML.Trace'.
The trace node 'it.test.CSV2XML.Trace' has received a message and is propagating it to any nodes connected to its output terminal. |
Looks as if your Trace node output is going to a file. It's certainly not going into the user trace!
| Quote: |
| recordsType has DES Use data pattern and Group delimiter <CR><LF>: |
There is no such property as 'Group Delimiter'. A Group Terminator indicates the end of a structure. If you have set the Group Terminator to <CR><LF> then the parser is probably seeing each and every end-of-line as end-of-record-element.
I suggest that you include the end-of-line characters in your data patterns, and remove the group terminator. |
|
| Back to top |
|
|
| giorginus80 |
| Posted: Wed Jul 09, 2008 4:48 am Post subject: |
|
|
Centurion
Joined: 08 Jul 2008
Posts: 124
Location: Rome, Italy
|
| jeeth_m wrote: |
Hi giorginus80,
In your input message persone is coming 3 times and then one resume.
Is this the case all the time? Or it can appear any number of time?
Regards,
Jeeth |
No it's appearing one or more time.
| kimbert wrote: |
There is no such property as 'Group Delimiter'. A Group Terminator indicates the end of a structure. If you have set the Group Terminator to <CR><LF> then the parser is probably seeing each and every end-of-line as end-of-record-element.
I suggest that you include the end-of-line characters in your data patterns, and remove the group terminator.
|
I solved, I just add in the regular espression of 'person' \r\n and so the regular expression is [a-zA-Z0-9\s]{22}[9]{3}\r\n now my output is right I want, I don't know if this is the right way to solve this problem!
In this case if I don't keep <CR><LF> in the 'record' group terminator, I have a parse exception after the first 'record' built |
|
| Back to top |
|
|
| kimbert |
| Posted: Wed Jul 09, 2008 6:29 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5543
Location: Southampton
|
Your solution is fine.
FYI, when a data pattern is placed on a structure ( i.e. a complex element or a group) the matching portion of bitstream is pre-selected. The child elements will only see that pre-selected portion of bitstream. That probably explains your problem. |
|
| Back to top |
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
