Author |
Message
|
shruthi |
Posted: Fri Sep 03, 2010 9:32 am Post subject: MQ client Errors |
|
|
Apprentice
Joined: 04 Apr 2008 Posts: 43
|
Hi Gurus,
I am receiving below errors at client:
CCSID supplied for data conversion not supported.
The program ended because, either the source CCSID '437' or the target CCSID '852' is not valid, or is not currently supported.
Correct the CCSID that is not valid, or ensure that the requested CCSID can be supported.
Our set up is:
MQ Client -->MQIPT--> MQIPT-->MQSERVER.
Just to let you know our client is in POLAND.
Please let me know how this can be fixed .
Thanks,
Shruthi |
|
Back to top |
|
 |
Vitor |
Posted: Fri Sep 03, 2010 9:44 am Post subject: Re: MQ client Errors |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
shruthi wrote: |
Please let me know how this can be fixed . |
Install support for conversion between those code pages. This is at OS level & not an WMQ function.
You might also want to search the forum; IIRC there's been another recent post on Polish character conversion. _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
zpat |
Posted: Mon Sep 06, 2010 12:07 am Post subject: |
|
|
 Jedi Council
Joined: 19 May 2001 Posts: 5866 Location: UK
|
With WMQ v7 this can occur more often as some message conversion has been moved from the MQ client to the queue manager.
However this is likely to be that the codepage 852 is not installed. |
|
Back to top |
|
 |
shruthi |
Posted: Tue Sep 07, 2010 4:58 am Post subject: |
|
|
Apprentice
Joined: 04 Apr 2008 Posts: 43
|
How to install Code page support ? |
|
Back to top |
|
 |
Vitor |
Posted: Tue Sep 07, 2010 5:04 am Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
shruthi wrote: |
How to install Code page support ? |
Get whoever administers the box to do it. _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
mvic |
Posted: Tue Sep 07, 2010 5:39 pm Post subject: |
|
|
 Jedi
Joined: 09 Mar 2004 Posts: 2080
|
shruthi wrote: |
How to install Code page support ? |
What is your OS? What code page conversion filesets do you already have installed? |
|
Back to top |
|
 |
zonko |
Posted: Tue Sep 07, 2010 10:53 pm Post subject: |
|
|
Voyager
Joined: 04 Nov 2009 Posts: 78
|
I don't think that there is a converter between 437 and 852. Check the tables in the APR. |
|
Back to top |
|
 |
busy_chap |
Posted: Wed Sep 08, 2010 1:33 pm Post subject: |
|
|
Acolyte
Joined: 18 May 2006 Posts: 69
|
I have a similar issue and similar set up. My client system is windows.
When you say install a codepage conversion file set , if I go to control panel -> Regional and Language -> Advanced -> just check the 437 box
is that going to install the fileset for me? I found this in google but not sure if that is what you mean by install a file set?
Please advise. |
|
Back to top |
|
 |
mvic |
Posted: Thu Sep 09, 2010 1:46 am Post subject: |
|
|
 Jedi
Joined: 09 Mar 2004 Posts: 2080
|
Install a fileset is AIX speak I think. Sorry, I have no idea how to achieve something similar on Windows. But I think data conversions in MQ are all supplied with MQ. Look up your intended conversion in the Application Programming Reference, which is what zonko mentioned. |
|
Back to top |
|
 |
busy_chap |
Posted: Thu Sep 09, 2010 11:12 am Post subject: |
|
|
Acolyte
Joined: 18 May 2006 Posts: 69
|
Thanks for the pointer. I googled again and found that the ccsid.tbl file is the one that should be edited to handle any new conversions.
So if I add a line in the ccsid.tbl located in C:\Program Files\IBM\WebSphere MQ\conv\table but I was also looking at the App Programming Reference
and I see the equivalent of 852 is 5346 for client connection for windows..
I don't know if I am thinking in the right direction but wanted to check how these issues were handled by anyone else. |
|
Back to top |
|
 |
busy_chap |
Posted: Thu Sep 09, 2010 11:34 am Post subject: |
|
|
Acolyte
Joined: 18 May 2006 Posts: 69
|
the issue is resolved.
We edited the ccsid.tbl file and added a line 852 to 437. The connection worked fine.
Thanks for all your help. |
|
Back to top |
|
 |
|