| Author |
Message
|
| Monk |
 Posted: Tue May 15, 2007 12:51 am Post subject: Conversion error |
 |
|
Master
Joined: 21 Apr 2007
Posts: 282
|
Hi all
When i Start the channel on my MQ(windows 2003, v6) I get the following error message in my log
WebSphere MQ is unable to convert string data tagged in CCSID 437 to data in
CCSID 420.
any help on this would be appreciated.
Thanks
_________________
Thimk |
|
| Back to top |
|
 |
| Vitor |
| Posted: Tue May 15, 2007 12:54 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
I'd guess you have convert set to yes on the channel, and no conversion table installed for those 2 CCSIDs.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| zpat |
| Posted: Tue May 15, 2007 12:56 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
| Turn off CONVERT on the sender channel? |
|
| Back to top |
|
|
| Monk |
| Posted: Tue May 15, 2007 1:07 am Post subject: |
|
|
Master
Joined: 21 Apr 2007
Posts: 282
|
I have set the Convert option to off.
I still get the error.
what about the conversion table.Where do i get it for this specific conversion?.
_________________
Thimk |
|
| Back to top |
|
|
| marcin.kasinski |
| Posted: Tue May 15, 2007 1:12 am Post subject: |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
| Monk wrote: |
I have set the Convert option to off.
I still get the error.
|
Do you get this error for new messages ?
_________________
Marcin |
|
| Back to top |
|
|
| Monk |
| Posted: Tue May 15, 2007 1:18 am Post subject: |
|
|
Master
Joined: 21 Apr 2007
Posts: 282
|
Every time i try to start the sender channel , i get the error message
_________________
Thimk |
|
| Back to top |
|
|
| Monk |
| Posted: Tue May 15, 2007 1:42 am Post subject: |
|
|
Master
Joined: 21 Apr 2007
Posts: 282
|
it working now...
I enabled default conversion for MQ on my machine...
_________________
Thimk |
|
| Back to top |
|
|
| Nigelg |
| Posted: Tue May 15, 2007 4:40 am Post subject: |
|
|
Grand Master
Joined: 02 Aug 2004
Posts: 1046
|
That is the wrong solution. 437 is Windows English, and 420 is Arabic EBCDIC, i.e. on a mainframe. Clearly conversion between these character sets is not possible. Default conversion should only be used where the character sets are similar, e.g. both English (or Arabic), most of the character values in the CCSIDs represent the same characters, and for some reason or other there is no actual conversion table available.
If you want machines with such dissimilar code pages to communicate you should define the qmgrs with a common code page, e.g. Unicode 1208.
_________________
MQSeries.net helps those who help themselves.. |
|
| Back to top |
|
|
| Monk |
| Posted: Wed May 16, 2007 12:31 am Post subject: |
|
|
Master
Joined: 21 Apr 2007
Posts: 282
|
Hi
I changed the CCSID of my QM to 850 from 437 and disabled default conversion.
Now its working.
Thanks
_________________
Thimk |
|
| Back to top |
|
|
| Nigelg |
| Posted: Wed May 16, 2007 5:27 am Post subject: |
|
|
Grand Master
Joined: 02 Aug 2004
Posts: 1046
|
Nonsense.
850 is also English, and it is equally impossible for it to convert to Arabic.
What else did you do?
_________________
MQSeries.net helps those who help themselves.. |
|
| Back to top |
|
|
| Monk |
| Posted: Wed May 16, 2007 5:32 am Post subject: |
|
|
Master
Joined: 21 Apr 2007
Posts: 282
|
I didnt do anything...like i said i just changed the ccsid to 850 and disabled default conversion and channels started to work...
_________________
Thimk |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed May 16, 2007 5:32 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Nigelg wrote: |
Nonsense.
850 is also English, and it is equally impossible for it to convert to Arabic.
What else did you do? |
With default conversion switched off the channel will start. Pulling it off the queue will pose a few issues if he specifies MQGMO_CONVERT....
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| andygarcia11 |
| Posted: Fri May 18, 2007 6:54 am Post subject: help with ccsid |
|
|
Newbie
Joined: 18 May 2007
Posts: 2
|
hi,
can you help me with this.i have mainframe websphere MQ and its putting message from cobol program.now i have to retrive it in JMS program on windows.
i m getting every text from queue.but the problem is some special characters like '^' and '|' , '~' are not converted correctly...
problem is with CCSID only.can you tell me where to set it?on mainframe side in QMGR or in my Connection Factory.and what value to set.
thanks. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri May 18, 2007 5:37 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Looks like the mainframe and its qmgr have a different CCSID code (37/500). In the sending program make sure to set the CCSID either on the message or the qmgr object to the CCSID the data being sent is in....
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
