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 » client Oracle connection V6

Post new topic  Reply to topic
 client Oracle connection V6 « View previous topic :: View next topic » 
Author Message
Lillian
PostPosted: Thu Feb 15, 2007 12:46 am    Post subject: client Oracle connection V6 Reply with quote

Centurion

Joined: 15 Apr 2002
Posts: 102
running version 2.1 and 6.0 brokers on the same unix server. I have a flow that inserts to a remote oracle database PAPDEV.
1. works on version 2.1 broker and not on vesion 6.0.
2.SQLplus commands work
3. using the same user for both versions.

error on processing the message on version 6.0 is below.

which driver should be in the var/mqsi/odbc/.odbc.ini ? getting an error on all below.
version 2.1 uses the UKor818.so.

What am I missing?

odbc.ini :

[PAPDEV]
#Driver=/opt/IBM/mqsi/6.0/merant/lib/UKor820.so
#Driver=/opt/IBM/mqsi/6.0/DD64/lib/UKora20.so
Driver=/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=PAPDEV
EnableDescribeParam=1
OptimizePrepare=1

error :
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S600_P/src/DataFlowEngine/ImbDataFlowNode.cpp'
(0x03000000):Line = 616
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'SRS_PapyrusReportRequestXML_XML#FCMComposite_1_12'
(0x03000000):Label = 'SRS_PapyrusReportRequestXML_XML.Store Data'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Node throwing exception'
(0x01000000):DatabaseException = (
(0x03000000):File = '/build/S600_P/src/DataFlowEngine/ImbOdbc.cpp'
(0x03000000):Line = 227
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2321
(0x03000000):Text = 'Root SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '-1'
)
(0x01000000):DatabaseException = (
(0x03000000):File = '/build/S600_P/src/DataFlowEngine/ImbOdbc.cpp'
(0x03000000):Line = 355
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2322
(0x03000000):Text = 'Child SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '82'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '0'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '523 80'
Back to top
View user's profile Send private message
gregop
PostPosted: Thu Feb 15, 2007 1:00 am    Post subject: Reply with quote

Voyager

Joined: 24 Nov 2006
Posts: 81
You'll have a different location for your V6.0 odbc.ini.

For a standard install I believe this is /opt/IBM/mqsi/6.0/merant/.odbc.ini

V6.0 driver should be:

Driver=/opt/IBM/mqsi/6.0/merant/lib/UKor820.so
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Feb 15, 2007 2:43 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
You should not move the odbc.ini file for v6.

You should use the entry in the default odbc.ini for Oracle *as much as possible*. Only change the actual Oracle information - database SID etc.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
Lillian
PostPosted: Thu Feb 15, 2007 4:59 am    Post subject: Reply with quote

Centurion

Joined: 15 Apr 2002
Posts: 102
I am now really stuck.
I have not moved the .odbc file just updated the the info with the oracle data ( this is the same odbc that was used for the DB2 for broker). as defined in the profile parameter :ODBCINII

also updated the one on the /opt/IBM/mqsi/6.0/merant/odbc.ini

am I focusing on the right thing?, at this point I am not even sure that he error is symptomatic of odbc settings..
Back to top
View user's profile Send private message
PieterV
PostPosted: Thu Feb 15, 2007 6:07 am    Post subject: Reply with quote

Disciple

Joined: 04 Jan 2006
Posts: 164
Location: Belgium
I don't see why you should update the one in /opt/mqsi/merant
I think that is only a template.

I should say that adapting the one in /var/mqsi/odbc is sufficient.
Back to top
View user's profile Send private message
EddieA
PostPosted: Thu Feb 15, 2007 11:01 am    Post subject: Reply with quote

Jedi

Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
You update the one pointed to by the ODBCINI environment variable.

Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0
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 » client Oracle connection V6
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.