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 » Issue when inserting value from WMB to Oracle

Post new topic  Reply to topic
 Issue when inserting value from WMB to Oracle « View previous topic :: View next topic » 
Author Message
sammy_910
PostPosted: Thu Dec 16, 2010 5:41 am    Post subject: Issue when inserting value from WMB to Oracle Reply with quote

Apprentice

Joined: 16 Dec 2010
Posts: 33

Hi,

I am facing a error while inserting a row into an Orcle(10g) db.The values get inserted properly when I try through sqlplus but the same values when inserted through WMB get inserted as inverted '?'.Tried seraching for the solution but with no result.Currently the CCSID value of the message in broker is 1208.

Can anybody help with the solution?
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Dec 16, 2010 5:48 am    Post subject: Re: Issue when inserting value from WMB to Oracle Reply with quote

Grand High Poobah

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

sammy_910 wrote:
Can anybody help with the solution?


What's the CCSID of the Database? What's the data type of the Oracle column?

What's the CCSID of the input WMB is reading to do the insert?

What's the CCSID of the PC you're running sqlplus on?

What's the actual hex value in the column that's displayed as the spurious character? Are you viewing it by doing a SELECT via sqlplus or directly? How does it match to the hex value in the input?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
sammy_910
PostPosted: Fri Dec 17, 2010 3:57 am    Post subject: Reply with quote

Apprentice

Joined: 16 Dec 2010
Posts: 33

Hi,

Quote:
What's the CCSID of the Database? What's the data type of the Oracle column?.



The CCSID of the db is WE8MSWIN1252.The value gets inserted as inverted'?' irrespective of the datatype of the column.

Quote:
What's the CCSID of the input WMB is reading to do the insert?


The CCSID of the input is 1208.

Quote:
What's the CCSID of the PC you're running sqlplus on?



Could not find the CCSID of the PC.Could you please tell me how to find it?

Quote:
What's the actual hex value in the column that's displayed as the spurious character? Are you viewing it by doing a SELECT via sqlplus or directly? How does it match to the hex value in the input?



The value gets inserted as inverted'?' irrespective of the hex value being inserted.Yes I am viewing it by doing a Select from sqlplus.There is no particular pattern.

I am still not able to solve this error.Even when I do a select from WMB no value is returned and even no error is thrown.Please help.
Back to top
View user's profile Send private message
Vitor
PostPosted: Fri Dec 17, 2010 5:30 am    Post subject: Reply with quote

Grand High Poobah

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

sammy_910 wrote:
The CCSID of the db is WE8MSWIN1252.The value gets inserted as inverted'?' irrespective of the datatype of the column.


Or 1252. The datatype of the column affects the insert.

sammy_910 wrote:
Could not find the CCSID of the PC.Could you please tell me how to find it?


Look in the Control Panel; ask your Windows admin for assistance

sammy_910 wrote:
The value gets inserted as inverted'?' irrespective of the hex value being inserted.Yes I am viewing it by doing a Select from sqlplus.There is no particular pattern.


So you're saying the entire message, no matter what the content, goes into the database as rubbish?

You'd expect better from a conversion 1208 -> 1252. Are you sure the message is actually 1208 (have you checked the CCSID in the message or been told what it is) and have you used a trace node to confirm message content in WMB prior to insert?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Fri Dec 17, 2010 7:42 am    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

The real question will be does the CCSID (/code page) of the machine you are running the insert on (presumably the broker box) match the CCSID (/code page) your Oracle DB server is running on?

Check with oracle about their automatic default code page translations...

Maybe you need to serialize your data to CCSID 1252 before insertion?
But then you would expect a UTF-8 Database to run on a UTF-8 system wouldn't you?

Have fun
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
bsiggers
PostPosted: Fri Dec 17, 2010 8:45 am    Post subject: NLS_LANG Reply with quote

Acolyte

Joined: 09 Dec 2010
Posts: 53
Location: Vancouver, BC

You may also want to check the value of the NLS_LANG environment variable - check what it is on your PC (where I guess you are running SQL*Plus from), then check what it is set to in the environment where Broker is running, then check how your Oracle DB is set up. All it takes is it to be set somewhere incorrectly (or not at all) and you'll get these kinds of results - for example, when things get changed in the middle to US7ASCII or something.

Hope this helps a little - your Oracle guys may also be able to give some guidance - but you will also probably put in a trace node to make *really* sure you are generating what you think you are generating, as Vitor says.
Back to top
View user's profile Send private message
sammy_910
PostPosted: Tue Dec 21, 2010 4:30 am    Post subject: Reply with quote

Apprentice

Joined: 16 Dec 2010
Posts: 33

Thanks a lot for your responses


Actually the system on which my Broker is running and the Oracle server is running is the same.

On doin a mqsiservice I got the following:
BIPmsgs en_US
Console OEM CP=437, ICU CCSID=5348
Default codepage=ibm-5348_P100-1997, in ascii=ibm-5348_P100-1997
JAVA console codepage name=cp437

Now The broker CCSID is 5348,Oracle is 1252 and my msg CCSID is 1208.Is this the problem behind the junk value getting inserted?What should me my solution approach in this case?
Back to top
View user's profile Send private message
Vitor
PostPosted: Tue Dec 21, 2010 5:01 am    Post subject: Reply with quote

Grand High Poobah

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

sammy_910 wrote:
Now The broker CCSID is 5348,Oracle is 1252 and my msg CCSID is 1208.Is this the problem behind the junk value getting inserted?What should me my solution approach in this case?


That all sounds fine; 1208 is UTF-8 (mostly), 1252 is ISO-8859-1 (West European Latin) and 5348 is 1252 with a Euro symbol. So you shouldn't be getting everything comming out as hash; alphanumerics should work.

I stand by my previous advice - user trace and a trace node. Prove that nothing unexpected has happened in your flow to your message. WMB uses Unicode internally so the trace should look fine....
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
sammy_910
PostPosted: Sun Dec 26, 2010 11:54 pm    Post subject: Reply with quote

Apprentice

Joined: 16 Dec 2010
Posts: 33

Thanks Everyone

I proceeded with the trace.Everything looked fine.Then on further search on the WMB V7 Infocentre,I found this :

WebSphere Message Broker V7.0.0.1 or later is required for compatibility with Oracle 10g rel 2.Currently I have WMB V7.0.0.0.

Guess the issue is solved as of now till I apply the fixpack 1.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Issue when inserting value from WMB to Oracle
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.