| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| fn:sum returning NaN in mapping node |
« View previous topic :: View next topic » |
| Author |
Message
|
| gs |
 Posted: Wed Oct 30, 2013 2:04 am Post subject: fn:sum returning NaN in mapping node |
 |
|
Master
Joined: 31 May 2007
Posts: 254
Location: Sweden
|
We've got a flow mapping from an XML to a CSV (DFDL parser).
Two of the XML input fields are defined as double and they contain "11.0" and "8.0". They are summed using the mapping node and the function fn:sum.
Now, on one broker (1) this works perfectly but on another (2) it doesn't work - fn:sum returning "NaN".
The brokers are on the same fixpack level, a user trace (and service) trace shows the exact same message tree. The input is a FileInput node where ccsid 1208 is set to match the input data.
Worth to mention...on the broker (2) where the above doesn't work, it does work when using a comma as the decimal separator.
What am I missing here and/or what more should I test / check?
Sounds like some kind of locale issue but that shouldn't affect xpath functions on a parsed logical message tree?
Toolkit version 8.0.0.3
Working WMB setup (1):
Windows 2008 server (swedish locale)
WMB 8.0.0.1
Non-working WMB setup (2):
Windows 7 (swedish locale)
WMB 8.0.0.1 |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Oct 30, 2013 5:46 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The user trace should show the step by step execution of the map...
The model shouldn't change how the map performs.
It sounds like either it's a bizarre product bug, or it's a platform configuration issue - if the systems are linux, for example, maybe some of the installed os packages are different or at different levels. |
|
| Back to top |
|
|
| gs |
| Posted: Wed Oct 30, 2013 10:00 am Post subject: |
|
|
Master
Joined: 31 May 2007
Posts: 254
Location: Sweden
|
Thanks, neither of the traces give much as they only show that the xpath function returns a NaN.
Sounds like a bug...I'll raise a PMR for it anyways. Would there even be system configuration affecting the Mapping node / xpath? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Oct 30, 2013 10:06 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| gs wrote: |
| Worth to mention...on the broker (2) where the above doesn't work, it does work when using a comma as the decimal separator. |
Makes me think that you have a different locale set for the service user, or for the broker. Number representation changes with the locale and as such your input / or output becomes incompatible with the format definition you used on broker 1...
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Oct 30, 2013 10:07 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| gs wrote: |
| Worth to mention...on the broker (2) where the above doesn't work, it does work when using a comma as the decimal separator. |
Makes me think that you have a different locale set for the service user, or for the broker. Number representation changes with the locale and as such your input / or output becomes incompatible with the format definition you used on broker 1...
Have fun
_________________
MQ & Broker admin |
|
| 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
|
|
|
|
