| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQ Series issue with Greek characters. |
« View previous topic :: View next topic » |
| Author |
Message
|
| pratik_du |
 Posted: Wed Feb 29, 2012 5:59 am Post subject: MQ Series issue with Greek characters. |
 |
|
Newbie
Joined: 29 Feb 2012
Posts: 1
|
Hi All,
I haven't got much experience with MQ Series (being a SAP PI consultant) but still have done my bit of research and hence trying to summarize the issue which we currently face when sending JMS messages between SAP PI and MQ Series.
Short Description of Problem:
The end to end scenario works fine with general data and even for some of the foreign language characters like Spanish, German etc. But we are getting garbled characters when data has Greek and/or Turkish characters.
Flow
The flow is SAP PI posts the message as text message using MQ JMS API to MQ Series hosted on Server 1. The character encoding used by SAP PI is UTF-8. Here, SAP PI is posting the message to a remote queue which is pointing to a queue on MQ Series on Server 2. So there is a MQ to MQ transfer in between the two MQ Series. Then, once it reaches the second MQ Series, the data is picked up by WTX transfomation maps and sent to final target system after necessary conversions.
Problem Description and Analysis
Test with JMS Compliant mode (MQ JMS API) (This is the format we have used and is live in Production and is the one to be used. )
Issue Description
As SAP PI is sending data in Unicode (UTF- we expected this to work without setting CCSID but when we post the message without CCSID and for testing purposes put it in a local queue the Greek characters come as garbled. When we set the CCSID to 819 (Queue Manager CCSID), the characters come as ‘?’. We have tried setting many other CCSIDs (which refer to Greek characters) but nothing seems to be working for us. We have also tried the actual scenario where we post the message to remote queue and as expected the recipient MQ series and target system receive the message as ‘?’. So we are not sure where the problem lies. Does it in happen while putting the message in queue or after MQGET and what CCSID needs to be set to support such a scenario. Also the format visible in MQ Explorer is MQRFH2.
Here are the details of MQ Series on Server 1 and 2:
MQ Series (on MQ Server 1)
Queue Manager CCSID 819
OS: UNIX
AIX 5.3
MQ Version: 6.02
MQ Series on MQ Server 2
Queue Manager CCSID 437
OS: Windows
MQ version:7.0
It would be really great if somebody can help us on how to resolve the issue with greek characters.
Thanks,
Pratik |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Feb 29, 2012 6:09 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Write the message to a local queue without setting the CCSID.
Use the command line program amqsbcg (or the client version amqsbcgc) to read the contents of the message and print it out.
Confirm that the CCSID of the message is reported as 1200 or 1208.
Confirm that the byte values shown are the proper byte values for the Greek characters in question (remember that UTF is a multi-byte character set).
If any of the above are false, then the problem is with how you construct the QCF or the JMSMessage object, or write into it.
If these all validate, then the problem is with the *receiving* application, not the *sending* application. In particular, it's likely the receiving application is trying to do a convert into a character set that doesn't support the characters. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Feb 29, 2012 9:44 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
As SAP PI is using the JMS API, here are some points to consider
- set CCSID 1208 on the connection factory
- Verify that no CCSID is set on the destination object.
You might want to set CCSID 1208 on the destination object as it will supersede the CCSID of the connection factory.
- create the message as a TextMessage
This should be all that is required from the sending side.
Have the local MQ Admin handle the other aspects.
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
|
|
|
|
