| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Value Not Valid |
« View previous topic :: View next topic » |
| Author |
Message
|
| timmy |
 Posted: Wed Feb 19, 2003 2:39 am Post subject: Value Not Valid |
 |
|
Novice
Joined: 12 Aug 2002
Posts: 24
Location: Torello
|
Hi,
I'm converting a XML message to a MRM using a Compute node. I have the same code and the same Message Set in other computer (I export both the message set and message flow from the first computer and import them in the second one). There are some XML tags that I use in the mapping with empty values. In the first computer the conversion is a success, but in the second one I have an error. In the Exception list I can read 'Value Not Valid' and I'm sure that the error is because of a field with empty value.
For example, I have the messsage:
<Message>
<Field1>A</Field1>
<Field2></Field2>
</Message>
In the Compute node I have:
SET OutputRoot.MRM.Field1 = InputRoot.XML.Message.Field1;
SET OutputRoot.MRM.Field2 = InputRoot.XML.Message.Field2;
Can anybody explain me what is happening? How can I control it?
Thanks in advance. |
|
| Back to top |
|
 |
| philip.baker |
| Posted: Thu Feb 20, 2003 12:30 pm Post subject: |
|
|
Voyager
Joined: 21 Mar 2002
Posts: 77
Location: Baker Systems Consulting, Inc. - Tampa
|
Hi timmy,
There could be some processing differences between the two systems being compared when dealing with empty XML tags and/or NULL evaluations. Please inform of the Operating systems being used and the versions of MQSI/WMQI being used on each system.
You can try to control the evaluation of empty XML tags by using the COALESCE function within the ESQL in your Compute Node.
For your code::
SET OutputRoot.MRM.Field1 = InputRoot.XML.Message.Field1;
SET OutputRoot.MRM.Field2 = InputRoot.XML.Message.Field2;
Try:
SET OutputRoot.MRM.Field1 = COALESCE(InputRoot.XML.Message.Field1,'');
SET OutputRoot.MRM.Field2 = COALESCE(InputRoot.XML.Message.Field2,'');
Or place a 'blank' space between the single quotes if its OK to accept blanks in your MRM character fields. Use a zero after the comma if your MRM field is numeric.
_________________
Regards,
Phil |
|
| 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
|
|
|
|
