ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Mapping Node output

Post new topic  Reply to topic Goto page 1, 2  Next
 Mapping Node output « View previous topic :: View next topic » 
Author Message
sanketpatel
PostPosted: Thu Nov 16, 2006 4:49 am    Post subject: Mapping Node output Reply with quote

Apprentice

Joined: 31 Oct 2006
Posts: 40
I am not getting any body in my output.

my flow look like...

mqinput -> mapping node -> mqoutput

in input i am getting a jms compliant xml message from sap adapter and in mapping node i am converting it in to another xml message. but the output is only jms header.

pls help...
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Nov 16, 2006 4:57 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
Then you have a problem in your mapping.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
sanketpatel
PostPosted: Thu Nov 16, 2006 5:02 am    Post subject: Reply with quote

Apprentice

Joined: 31 Oct 2006
Posts: 40
jeff,

need your help...

how to convert mqhrf2 to mqstr?

i think this may be the problem..
my input message has MQMD and MQRFH2.
in MQMD format is mqhrf2.

F1..... F1........F1......
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Nov 16, 2006 5:17 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
sanketpatel wrote:

how to convert mqhrf2 to mqstr?


Why would you want to? Any more than you'd want to convert the MQMD to a string?

It's just a header. Fix the mapping in the node so it produces valid output.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Nov 16, 2006 5:20 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
Sorry, just reread what you posted....

If there is an RFH2 header in the message (very likely if the input message is from JMS) then the MQMD.Format will be MQRFH2 to reflect this. It's not a problem. The RFH2 will have the actual format of your message (presumably MQSTR).

Broker will cope with this. As jefflowrey says, you have an error in your mapping.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
sanketpatel
PostPosted: Thu Nov 16, 2006 5:23 am    Post subject: Reply with quote

Apprentice

Joined: 31 Oct 2006
Posts: 40
thnk vitor...

but the problem is i am not getting any message body in the output.

is showing me only message header....i.e mcd
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Nov 16, 2006 5:35 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
sanketpatel wrote:
but the problem is i am not getting any message body in the output.


And why do you think this is not because there's a problem in the mapping node? Do you have trace of the message leaving the mapping with an intact message body or other evidence? If so, please post.

Information is the key to solution.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
sanketpatel
PostPosted: Thu Nov 16, 2006 5:55 am    Post subject: Reply with quote

Apprentice

Joined: 31 Oct 2006
Posts: 40
(
(0x01000000):Properties = (
(0x03000000):MessageSet = 'OL4A1NO002001'
(0x03000000):MessageType = 'sap_zv_prodn_bal_mvmnt_data'
(0x03000000):MessageFormat = 'CwXML'
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 1208
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2006-11-16 13:50:35.960'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 4
(0x03000000):ReplyIdentifier = X'414d5120514d475220202020202020209e6e5b4520078c02'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
(0x03000000):ContentType = ''
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'SAPCONNECTOR/RESPONSEQUEUE'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Format = 'MQHRF2 '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 1
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 4
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d5120514d475220202020202020209e6e5b4520019c1e'
(0x03000000):CorrelId = X'414d5120514d475220202020202020209e6e5b4520078c02'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = 'SAPCONNECTOR/RESPONSEQUEUE '
(0x03000000):ReplyToQMgr = 'QMGR '
(0x03000000):UserIdentifier = 'db2admin '
(0x03000000):AccountingToken = X'160105150000000d7a5a338aa7323fdbeb0c50ed03000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 11
(0x03000000):PutApplName = 'ters\AdapterJRE\bin\java.exe'
(0x03000000):PutDate = DATE '2006-11-16'
(0x03000000):PutTime = GMTTIME '13:50:35.960'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000000):MQRFH2 = (
(0x03000000):Version = 2
(0x03000000):Format = ''
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 1208
(0x03000000):Flags = 0
(0x03000000):NameValueCCSID = 1208
(0x01000000):mcd = (
(0x01000000):Msd = (
(0x02000000): = 'mrm'
)
(0x01000000):Set = (
(0x02000000): = 'OL4A1NO002001'
)
(0x01000000):Type = (
(0x02000000): = 'sap_zv_prodn_bal_mvmnt_data'
)
(0x01000000):Fmt = (
(0x02000000): = 'CwXML'
)
)
(0x01000000):jms = (
(0x01000000):Dst = (
(0x02000000): = 'queue:///SAPCONNECTOR/RESPONSEQUEUE'
)
(0x01000000):Rto = (
(0x02000000): = 'queue:///SAPCONNECTOR/RESPONSEQUEUE'
)
(0x01000000):Tms = (
(0x02000000): = '1163685035623'
)
(0x01000000):Dlv = (
(0x02000000): = '1'
)
)
(0x01000000):usr = (
(0x01000000):Status = (
(0x02000000): = '1'
)
(0x01000000):RequestType = (
(0x02000000): = 'Response'
)
(0x01000000):Description = (
(0x02000000): = ''
)
)
(0x01000000):psc = (
(0x01000000):Topic = (
(0x02000000): = NULL
)
)
)
)
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Nov 16, 2006 6:01 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
Indeed, this is trace of a message with no output body, as per your post. The most likely cause is a mapping problem. I repeat, why do you think the mapping is working? Where's the trace that shows that?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Nov 16, 2006 6:05 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
To put a slightly different spin on it.

The message tree that you are seeing on the Out terminal of the Mapping node is exactly the one that the Mapping node is coded to produce for your input node.

That is, the Mapping node is almost certainly doing what you've TOLD it to do. But that may not be what you think it is.

I recently ran into an issue where a Mapping node produced exactly the same result you're seeing - there was no MRM tree at the Out terminal. In my case, it turned out that the Input message was in the wrong XML namespace, so the Mapping node mapped a whole set of Null values to the output tree - which ended up completely null.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
sanketpatel
PostPosted: Thu Nov 16, 2006 6:25 am    Post subject: Reply with quote

Apprentice

Joined: 31 Oct 2006
Posts: 40
jeff,

then what is the solution.

in my case i also have namespaces.

pls guide...
Back to top
View user's profile Send private message
sanketpatel
PostPosted: Thu Nov 16, 2006 6:35 am    Post subject: Reply with quote

Apprentice

Joined: 31 Oct 2006
Posts: 40
trace before mapping node

(
(0x01000000):Properties = (
(0x03000000):MessageSet = 'OL4A1NO002001'
(0x03000000):MessageType = 'sap_zv_prodn_bal_mvmnt_data'
(0x03000000):MessageFormat = 'CwXML'
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 1208
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2006-11-16 14:30:55.220'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 4
(0x03000000):ReplyIdentifier = X'414d5120514d475220202020202020209e6e5b4520078c03'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
(0x03000000):ContentType = ''
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'SAPCONNECTOR/RESPONSEQUEUE'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Format = 'MQHRF2 '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 1
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 4
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d5120514d475220202020202020209e6e5b4520019c1f'
(0x03000000):CorrelId = X'414d5120514d475220202020202020209e6e5b4520078c03'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = 'SAPCONNECTOR/RESPONSEQUEUE '
(0x03000000):ReplyToQMgr = 'QMGR '
(0x03000000):UserIdentifier = 'db2admin '
(0x03000000):AccountingToken = X'160105150000000d7a5a338aa7323fdbeb0c50ed03000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 11
(0x03000000):PutApplName = 'ters\AdapterJRE\bin\java.exe'
(0x03000000):PutDate = DATE '2006-11-16'
(0x03000000):PutTime = GMTTIME '14:30:55.220'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000000):MQRFH2 = (
(0x03000000):Version = 2
(0x03000000):Format = 'MQSTR '
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 1208
(0x03000000):Flags = 0
(0x03000000):NameValueCCSID = 1208
(0x01000000):mcd = (
(0x01000000):Msd = (
(0x02000000): = 'mrm'
)
(0x01000000):Set = (
(0x02000000): = 'OL4A1NO002001'
)
(0x01000000):Type = (
(0x02000000): = 'sap_zv_prodn_bal_mvmnt_data'
)
(0x01000000):Fmt = (
(0x02000000): = 'CwXML'
)
)
(0x01000000):jms = (
(0x01000000):Dst = (
(0x02000000): = 'queue:///SAPCONNECTOR/RESPONSEQUEUE'
)
(0x01000000):Rto = (
(0x02000000): = 'queue:///SAPCONNECTOR/RESPONSEQUEUE'
)
(0x01000000):Tms = (
(0x02000000): = '1163687455022'
)
(0x01000000):Dlv = (
(0x02000000): = '1'
)
)
(0x01000000):usr = (
(0x01000000):Status = (
(0x02000000): = '1'
)
(0x01000000):RequestType = (
(0x02000000): = 'Response'
)
(0x01000000):Description = (
(0x02000000): = ''
)
)
)
(0x01000021):MRM = (
(0x0300000D):@version = '3.0.0'
(0x0300000D):@verb = 'Retrieve'
(0x0300000D):@locale = 'en_US'
(0x0300000D):@delta = 'false'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_zv_prodn_bal_mvmnt_data:Date = '20060912'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_zv_prodn_bal_mvmnt_data:Plant = '1121'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_zv_prodn_bal_mvmnt_data:sap_prdbalmvmntdata = NULL
(
(0x0300000D):@size = '5'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:sap_prdbalmvmntdata = NULL
(
(0x0300000D):@version = '3.0.0'
(0x0300000D):@verb = 'Retrieve'
(0x0300000D):@locale = 'en_US'
(0x0300000D):@delta = 'false'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Plant = '1121'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Material_number = '16000'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Material_description = 'MOTOR SPIRIT 87 ON (Unleaded MS)'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:IS_OIL_MAP_external_details_mode_of_transport = '01'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Actual_billed_quantity = '4.346'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Base_unit_of_measure = 'TO'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Posting_date_in_the_document = '20060912'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Posting_time_in_the_document = '172049'
)
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:sap_prdbalmvmntdata = NULL
(
(0x0300000D):@version = '3.0.0'
(0x0300000D):@verb = ''
(0x0300000D):@locale = 'en_US'
(0x0300000D):@delta = 'false'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Plant = '1121'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Material_number = '32000'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Material_description = 'JET A-1 (ATF)'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:IS_OIL_MAP_external_details_mode_of_transport = NULL
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Actual_billed_quantity = '9.424'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Base_unit_of_measure = 'TO'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Posting_date_in_the_document = '20060912'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Posting_time_in_the_document = '152825'
)
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:sap_prdbalmvmntdata = NULL
(
(0x0300000D):@version = '3.0.0'
(0x0300000D):@verb = ''
(0x0300000D):@locale = 'en_US'
(0x0300000D):@delta = 'false'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Plant = '1121'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Material_number = '40000'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Material_description = 'SUPERIOR KEROSENE'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:IS_OIL_MAP_external_details_mode_of_transport = '01'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Actual_billed_quantity = '27.453'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Base_unit_of_measure = 'TO'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Posting_date_in_the_document = '20060912'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Posting_time_in_the_document = '170713'
)
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:sap_prdbalmvmntdata = NULL
(
(0x0300000D):@version = '3.0.0'
(0x0300000D):@verb = ''
(0x0300000D):@locale = 'en_US'
(0x0300000D):@delta = 'false'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Plant = '1121'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Material_number = '57000'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Material_description = 'ULTRA LOW SULPHUR DIESEL'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:IS_OIL_MAP_external_details_mode_of_transport = '01'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Actual_billed_quantity = '69.947'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Base_unit_of_measure = 'TO'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Posting_date_in_the_document = '20060912'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Posting_time_in_the_document = '172049'
)
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:sap_prdbalmvmntdata = NULL
(
(0x0300000D):@version = '3.0.0'
(0x0300000D):@verb = ''
(0x0300000D):@locale = 'en_US'
(0x0300000D):@delta = 'false'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Plant = '1121'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Material_number = '57000'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Material_description = 'ULTRA LOW SULPHUR DIESEL'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:IS_OIL_MAP_external_details_mode_of_transport = '05'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Actual_billed_quantity = '647.664'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Base_unit_of_measure = 'TO'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Posting_date_in_the_document = '20060912'
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_prdbalmvmntdata:Posting_time_in_the_document = '151912'
)
)
(0x0300000D)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_zv_prodn_bal_mvmnt_data:ObjectEventId = NULL
)
)
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Nov 16, 2006 6:54 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
sanketpatel wrote:
then what is the solution.


Fix the mapping!!

At the risk of sounding like an echo, what you think the mapping node is doing is not what it's actually doing; therefore the instructions you've given it are in error.

Have you checked the input namespace is correctly handled as per my illustrious associate's suggestion? Are you using a wrong default namespace? Have you attempted a user trace to see why you're getting nulls in the output tree? Etc? Etc?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
sanketpatel
PostPosted: Thu Nov 16, 2006 7:01 am    Post subject: Reply with quote

Apprentice

Joined: 31 Oct 2006
Posts: 40
Back to top
View user's profile Send private message
sanketpatel
PostPosted: Thu Nov 16, 2006 7:21 am    Post subject: Reply with quote

Apprentice

Joined: 31 Oct 2006
Posts: 40
jeff...

vitor.....


thanks a lot....

its working fine now....
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Goto page 1, 2  Next Page 1 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Mapping Node output
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.