Hello Experts,
Can we read MQHRF2 message format MQ messages in Datastage?
Currently the jobs are failing with a Fatal Message:
"The WebSphere MQ plug-in is unable to process non-string formatted messages."
Is there a patch/ admin variable that will enable DS to read the MQHRF2 messages?
Please let me know.
Regards,
Vijay
Reading MQ messages in MQHRF2 message format in DS
Moderators: chulett, rschirm, roy
It's been too long since I've looked at this issue in a release 7 environment to remember......but the release 8 MQ Connector, if you have access to release 8 or are making plans for it, provides specific support for these types of messages.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Solution
In the MQStage, Under Tab "Output", and in "Message Filtering Options",
Check "Apply Filtering" and in the "Message Format" text box, you can add the type of messageformat eg.MQSTR or MQRFH2. This will enable the MQ stage to read XML messages of different messageFormats.
Incase you have multiple message Formats you need to have these messageFormats mentioned as a comma seperated and it should work for all messageFormats in the "MessageFormat" textbox.
Kindly Note, that though the MQ stage successully passes diff. messageFormats if you are using a XML stage it fails. So you need to either strip off the messageHeader or have the source send messages in the MQSTR format.
Check "Apply Filtering" and in the "Message Format" text box, you can add the type of messageformat eg.MQSTR or MQRFH2. This will enable the MQ stage to read XML messages of different messageFormats.
Incase you have multiple message Formats you need to have these messageFormats mentioned as a comma seperated and it should work for all messageFormats in the "MessageFormat" textbox.
Kindly Note, that though the MQ stage successully passes diff. messageFormats if you are using a XML stage it fails. So you need to either strip off the messageHeader or have the source send messages in the MQSTR format.
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore