| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Input XML to Output Char |
« View previous topic :: View next topic » |
| Author |
Message
|
| srailkar |
 Posted: Fri Jul 29, 2005 5:30 am Post subject: Input XML to Output Char |
 |
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
My input is XML format message. I need to send char - plain text messages out
eg:
Input message:
InputRoot.XML.ClientElement.MessageHDR.DataBody
<DataBody>||@||</DataBody>
Expected format of Outputroot
||@||
Thanks for your help in advance. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Jul 29, 2005 5:46 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What have you tried?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| srailkar |
| Posted: Fri Jul 29, 2005 5:52 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
Hello Jeff,
I have tried different variations with setting the output domain and then the output root
the code works fine when no domain changes and
SET OutputRoot.XML.REC.(XML.AsisElementContent) = CAST(WorkingSourceO as CHAR);
however when I:
SET OutputRoot.Properties.MessageDomain = 'CHAR';
.
.
SET OutputRoot = CAST(WorkingSourceO as CHAR);
OR
SET OutputRoot.Properties.MessageDomain = 'BLOB';
SET OutputRoot."BLOB"."BLOB" = CAST(WorkingSourceO as BLOB);
This does not work. Zero bytes are sent in the message data |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Jul 29, 2005 6:09 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
So you are trying to extract the contents of a single element, and put that out as your entire message.
There is no such message domain as "CHAR", so that will never do anything useful.
What does a trace show, between your compute node and your MQOutput node, after your try with BLOB at the end there?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| srailkar |
| Posted: Fri Jul 29, 2005 6:28 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
Code :
SET OutputRoot.Properties.MessageDomain = 'BLOB';
.
.
.
SET OutputRoot = CAST(WorkingSourceO as BLOB);
PROPAGATE;
Executing statement 'SET OutputRoot = CAST(WorkingSourceO AS BLOB);' at (.CLPRO_POST_Compute.ReBuildFILE, 41. .
2005-07-29 10:16:54.296997 3416 UserTrace BIP2538I: Node 'CLPRO_POST.UNPACK': Evaluating expression 'CAST(WorkingSourceO AS BLOB)' at (.CLPRO_POST_Compute.ReBuildFILE, 41.25).
2005-07-29 10:16:54.297046 3416 UserTrace BIP2538I: Node 'CLPRO_POST.UNPACK': Evaluating expression 'WorkingSourceO' at (.CLPRO_POST_Compute.ReBuildFILE, 41.30).
2005-07-29 10:16:54.297660 3416 UserTrace BIP2231E: Error detected whilst processing a message 'CLPRO_POST.UNPACK'.
.
.
.
2005-07-29 10:16:54.297832 3416 RecoverableException BIP2521E: (.CLPRO_POST_Compute.ReBuildFILE, 41.25) : Error casting a value from CHARACTER to BLOB.
An error occurred when casting a value of data type CHARACTER to a value of data type BLOB.
Subsequent messages will indicate the context of the error.
2005-07-29 10:16:54.297893 3416 RecoverableException BIP2590E: Error casting character string '||#||' to a byte string.
An attempt was made to cast the character string '||#||' to a byte string, but the string was of the wrong format. There must be an even number of hexadecimal digits (0-9, a-f, A-F).
Other messages will give an indication of context of this error.
Last edited by srailkar on Fri Jul 29, 2005 6:36 am; edited 1 time in total |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Jul 29, 2005 6:31 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
That wasn't the trace I meant, I wanted to see a trace of the message tree, particularly what OutputRoot.BLOB.BLOB contained. But it's very useful anyway...
It says that it can't perform the cast to BLOB.
Is there more there after 10:16:54.297... ?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| srailkar |
| Posted: Fri Jul 29, 2005 6:45 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
Added Trace node on Failure path to get the Message Tree:
Here's the new trace:
Executing statement 'SET OutputRoot = CAST(WorkingSourceO AS BLOB);' at (.CLPRO_POST_Compute.ReBuildFILE, 43..
2005-07-29 10:41:48.144176 3416 UserTrace BIP2538I: Node 'CLPRO_POST.UNPACK': Evaluating expression 'CAST(WorkingSourceO AS BLOB)' at (.CLPRO_POST_Compute.ReBuildFILE, 43.25).
2005-07-29 10:41:48.144226 3416 UserTrace BIP2538I: Node 'CLPRO_POST.UNPACK': Evaluating expression 'WorkingSourceO' at (.CLPRO_POST_Compute.ReBuildFILE, 43.30).
2005-07-29 10:41:48.144790 3416 UserTrace BIP2231E: Error detected whilst processing a message 'CLPRO_POST.UNPACK'.
The message broker detected an error whilst processing a message in node 'CLPRO_POST.UNPACK'. The message has been augmented with an exception list and has been propagated to the node's failure terminal for further processing.
See the following messages for details of the error.
2005-07-29 10:41:48.144840 3416 RecoverableException BIP2488E: (.CLPRO_POST_Compute.Main, 5.3) Error detected whilst executing the SQL statement 'ReBuildFILE();'.
The message broker detected an error whilst executing the given statement. An exception has been thrown to cut short the SQL program.
See the following messages for details of the error.
2005-07-29 10:41:48.144882 3416 RecoverableException BIP2934E: Error detected whilst executing the function or procedure 'ReBuildFILE'.
The message broker detected an error whilst executing the function or procedure 'ReBuildFILE'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2005-07-29 10:41:48.144916 3416 RecoverableException BIP2488E: (.CLPRO_POST_Compute.ReBuildFILE, 43. Error detected whilst executing the SQL statement 'SET OutputRoot = CAST(WorkingSourceO AS BLOB);'.
The message broker detected an error whilst executing the given statement. An exception has been thrown to cut short the SQL program.
See the following messages for details of the error.
2005-07-29 10:41:48.144962 3416 RecoverableException BIP2521E: (.CLPRO_POST_Compute.ReBuildFILE, 43.25) : Error casting a value from CHARACTER to BLOB.
An error occurred when casting a value of data type CHARACTER to a value of data type BLOB.
Subsequent messages will indicate the context of the error.
2005-07-29 10:41:48.145011 3416 RecoverableException BIP2590E: Error casting character string '||#||C||e||ssssssssssssssss||e||dddddddddddddd||e|| 2,000.00||e||' to a byte string.
An attempt was made to cast the character string '||#||C||e||ssssssssssssssss||e||dddddddddddddd||e|| 2,000.00||e||' to a byte string, but the string was of the wrong format. There must be an even number of hexadecimal digits (0-9, a-f, A-F).
Other messages will give an indication of context of this error.
2005-07-29 10:41:48.145095 3416 UserTrace BIP2538I: Node 'CLPRO_POST.FAILURE.Trace': Evaluating expression 'Root' at (, 1.3).
2005-07-29 10:41:48.145919 3416 UserTrace BIP4060I: Data '(
(0x01000000):Properties = (
(0x03000000):MessageSet = ''
(0x03000000):MessageType = ''
(0x03000000):MessageFormat = ''
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 437
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2005-07-29 14:41:47.610'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'CLAIMSPRO.OUT'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 437
(0x03000000):Format = ' '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 0
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d5120544d4d434d44312020202020c838e9422002db05'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'TMMCMD1 '
(0x03000000):UserIdentifier = 'railkash '
(0x03000000):AccountingToken = X'160105150000001199b97818514964833d2b46a00c000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 11
(0x03000000):PutApplName = 's\IBM\WebSphere MQ\bin\q.exe'
(0x03000000):PutDate = DATE '2005-07-29'
(0x03000000):PutTime = GMTTIME '14:41:47.610'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000010):XML = (
(0x01000000):ClientElement = (
(0x01000000):MessageHDR = (
(0x01000000):DATABody = (
(0x02000000): = '||#||C||e||ssssssssssssssss||e||dddddddddddddd||e|| 2,000.00||e||||@||||#||P||e||DDDDDDDDDDDDDD||e||DDDDDD||e||DDDDDDD||e||||@||||#||T||e||MMMMMMMMMMMMM ||e||1000.00||e|| $9,000,000.00||e||||@||'
)
)
)
)
)
' from trace node 'CLPRO_POST.FAILURE.Trace'.
The trace node 'CLPRO_POST.FAILURE.Trace' has output the specified trace data.
This is an information message provided by the message flow designer. The user response will be determined by the local environment.
2005-07-29 10:41:48.146339 3416 UserTrace BIP4067I: Message propagated to output terminal for trace node 'CLPRO_POST.FAILURE.Trace'.
The trace node 'CLPRO_POST.FAILURE.Trace' has received a message and is propagating it to any nodes connected to its output terminal.
No user action required.
2005-07-29 10:41:48.146671 3416 UserTrace BIP2638I: The MQ output node 'CLPRO_POST.FAIL' attempted to write a message to queue 'FAIL' connected to queue manager ''. The MQCC was '0' and the MQRC was '0'.
2005-07-29 10:41:48.146720 3416 UserTrace BIP2622I: Message successfully output by output node 'CLPRO_POST.FAIL' to queue 'FAIL' on queue manager ''.
2005-07-29 10:41:49.272449 3428 UserTrace BIP2632I: Message received and propagated to 'out' terminal of MQ input node 'ConfigurationMessageFlow.InputNode'.
2005-07-29 10:41:49.272563 3428 UserTrace BIP6060I: Parser type 'Properties' created on behalf of node 'ConfigurationMessageFlow.InputNode' to handle portion of incoming message of length 0 bytes beginning at offset '0'.
2005-07-29 10:41:49.272693 3428 UserTrace BIP6061I: Parser type 'MQMD' created on behalf of node 'ConfigurationMessageFlow.InputNode' to handle portion of incoming message of length '364' bytes beginning at offset '0'. Parser type selected based on value 'MQHMD' from previous parser.
2005-07-29 10:41:49.273376 3428 UserTrace BIP6061I: Parser type 'XML' created on behalf of node 'ConfigurationMessageFlow.InputNode' to handle portion of incoming message of length '228' bytes beginning at offset '364'. Parser type selected based on value 'XML' from previous parser.
Threads encountered in this trace:
3416 3420 3424 3428 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Jul 29, 2005 6:53 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| Quote: |
2005-07-29 10:41:48.145011 3416 RecoverableException BIP2590E: Error casting character string '||#||C||e||ssssssssssssssss||e||dddddddddddddd||e|| 2,000.00||e||' to a byte string.
An attempt was made to cast the character string '||#||C||e||ssssssssssssssss||e||dddddddddddddd||e|| 2,000.00||e||' to a byte string, but the string was of the wrong format. There must be an even number of hexadecimal digits (0-9, a-f, A-F). |
That's the problem.
Try
| Code: |
| set OutputRoot.BLOB.BLOB = CAST(WorkingSourceO AS BLOB CCSID InputRoot.Properties.CodedCharSetID); |
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| srailkar |
| Posted: Fri Jul 29, 2005 7:04 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
Still Failing:
2005-07-29 11:01:26.668693 3416 UserTrace BIP2538I: Node 'CLPRO_POST.UNPACK': Evaluating expression 'CAST(WorkingSourceO AS BLOB CCSID InputRoot.Properties.CodedCharSetID)' at (.CLPRO_POST_Compute.ReBuildFILE, 43.35).
2005-07-29 11:01:26.668746 3416 UserTrace BIP2538I: Node 'CLPRO_POST.UNPACK': Evaluating expression 'WorkingSourceO' at (.CLPRO_POST_Compute.ReBuildFILE, 43.40).
2005-07-29 11:01:26.668796 3416 UserTrace BIP2538I: Node 'CLPRO_POST.UNPACK': Evaluating expression 'InputRoot.Properties.CodedCharSetID' at (.CLPRO_POST_Compute.ReBuildFILE, 43.69).
2005-07-29 11:01:26.668880 3416 UserTrace BIP2543E: Node 'CLPRO_POST.UNPACK': (.CLPRO_POST_Compute.ReBuildFILE, 43.90) : Failed to navigate to path element because it does not exist.
2005-07-29 11:01:26.669431 3416 UserTrace BIP2231E: Error detected whilst processing a message 'CLPRO_POST.UNPACK'.
The message broker detected an error whilst processing a message in node 'CLPRO_POST.UNPACK'. The message has been augmented with an exception list and has been propagated to the node's failure terminal for further processing.
See the following messages for details of the error.
2005-07-29 11:01:26.669477 3416 RecoverableException BIP2488E: (.CLPRO_POST_Compute.Main, 5.3) Error detected whilst executing the SQL statement 'ReBuildFILE();'.
The message broker detected an error whilst executing the given statement. An exception has been thrown to cut short the SQL program.
See the following messages for details of the error.
2005-07-29 11:01:26.669519 3416 RecoverableException BIP2934E: Error detected whilst executing the function or procedure 'ReBuildFILE'.
The message broker detected an error whilst executing the function or procedure 'ReBuildFILE'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2005-07-29 11:01:26.669603 3416 RecoverableException BIP2488E: (.CLPRO_POST_Compute.ReBuildFILE, 43. Error detected whilst executing the SQL statement 'SET OutputRoot.BLOB.BLOB = CAST(WorkingSourceO AS BLOB CCSID InputRoot.Properties.CodedCharSetID);'.
The message broker detected an error whilst executing the given statement. An exception has been thrown to cut short the SQL program.
See the following messages for details of the error.
2005-07-29 11:01:26.669935 3416 RecoverableException BIP2521E: (.CLPRO_POST_Compute.ReBuildFILE, 43.35) : Error casting a value from CHARACTER to BLOB.
An error occurred when casting a value of data type CHARACTER to a value of data type BLOB.
Subsequent messages will indicate the context of the error.
2005-07-29 11:01:26.669998 3416 RecoverableException BIP2590E: Error casting character string '||#||C||e||ssssssssssssssss||e||dddddddddddddd||e|| 2,000.00||e||' to a byte string.
An attempt was made to cast the character string '||#||C||e||ssssssssssssssss||e||dddddddddddddd||e|| 2,000.00||e||' to a byte string, but the string was of the wrong format. There must be an even number of hexadecimal digits (0-9, a-f, A-F).
Other messages will give an indication of context of this error.
2005-07-29 11:01:26.670112 3416 UserTrace BIP2538I: Node 'CLPRO_POST.FAILURE.Trace': Evaluating expression 'Root' at (, 1.3).
2005-07-29 11:01:26.670583 3416 UserTrace BIP4060I: Data '(
(0x01000000):Properties = (
(0x03000000):MessageSet = ''
(0x03000000):MessageType = ''
(0x03000000):MessageFormat = ''
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 437
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2005-07-29 15:01:26.190'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'CLAIMSPRO.OUT'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 437
(0x03000000):Format = ' '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 0
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d5120544d4d434d44312020202020c838e94220033705'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'TMMCMD1 '
(0x03000000):UserIdentifier = 'railkash '
(0x03000000):AccountingToken = X'160105150000001199b97818514964833d2b46a00c000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 11
(0x03000000):PutApplName = 's\IBM\WebSphere MQ\bin\q.exe'
(0x03000000):PutDate = DATE '2005-07-29'
(0x03000000):PutTime = GMTTIME '15:01:26.190'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000010):XML = (
(0x01000000):ClientElement = (
(0x01000000):MessageHDR = (
(0x01000000):DATABody = (
(0x02000000): = '||#||C||e||ssssssssssssssss||e||dddddddddddddd||e|| 2,000.00||e||||@||||#||P||e||DDDDDDDDDDDDDD||e||DDDDDD||e||DDDDDDD||e||||@||||#||T||e||MMMMMMMMMMMMM ||e||1000.00||e|| $9,000,000.00||e||||@||'
)
)
)
)
)
' from trace node 'CLPRO_POST.FAILURE.Trace'.
The trace node 'CLPRO_POST.FAILURE.Trace' has output the specified trace data.
This is an information message provided by the message flow designer. The user response will be determined by the local environment.
2005-07-29 11:01:26.671010 3416 UserTrace BIP4067I: Message propagated to output terminal for trace node 'CLPRO_POST.FAILURE.Trace'.
The trace node 'CLPRO_POST.FAILURE.Trace' has received a message and is propagating it to any nodes connected to its output terminal.
No user action required.
2005-07-29 11:01:26.671287 3416 UserTrace BIP2638I: The MQ output node 'CLPRO_POST.FAIL' attempted to write a message to queue 'FAIL' connected to queue manager ''. The MQCC was '0' and the MQRC was '0'.
2005-07-29 11:01:26.671333 3416 UserTrace BIP2622I: Message successfully output by output node 'CLPRO_POST.FAIL' to queue 'FAIL' on queue manager ''.
2005-07-29 11:01:27.286153 3428 UserTrace BIP2632I: Message received and propagated to 'out' terminal of MQ input node 'ConfigurationMessageFlow.InputNode'.
2005-07-29 11:01:27.286279 3428 UserTrace BIP6060I: Parser type 'Properties' created on behalf of node 'ConfigurationMessageFlow.InputNode' to handle portion of incoming message of length 0 bytes beginning at offset '0'.
2005-07-29 11:01:27.286455 3428 UserTrace BIP6061I: Parser type 'MQMD' created on behalf of node 'ConfigurationMessageFlow.InputNode' to handle portion of incoming message of length '364' bytes beginning at offset '0'. Parser type selected based on value 'MQHMD' from previous parser.
2005-07-29 11:01:27.286657 3428 UserTrace BIP6061I: Parser type 'XML' created on behalf of node 'ConfigurationMessageFlow.InputNode' to handle portion of incoming message of length '228' bytes beginning at offset '364'. Parser type selected based on value 'XML' from previous parser.
Threads encountered in this trace:
3416 3420 3424 3428 |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
