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 » Broker 7 ODBC 64bit Datasource

Post new topic  Reply to topic
 Broker 7 ODBC 64bit Datasource « View previous topic :: View next topic » 
Author Message
matuwe
PostPosted: Wed Mar 17, 2010 10:56 pm    Post subject: Broker 7 ODBC 64bit Datasource Reply with quote

Master

Joined: 05 Dec 2007
Posts: 296

Please help,

I have been trying to fix this and reading up on what is availabel by I think I am a little stuck,

I am running Broker 7 on AIX with oracle 64bit 10.2.0.4 and trying to create my data source. The ODBCINI and ORACLE HOME all done, but I still get an error when my compute node tries to connect to the datasource.

Database error: SQL State '82'; Native Error Code '0'; Error Text '523 80'


1. I have enabled trace on the ODBCINI file, but I cannot see the trace file to show that a db connection is done.
2. I usually see the mqsiprofile file been binary and an extra .sh file so you can use it for the .profile. But version & doesn't have this..
3. I have tested connection to database using SQLplus and I managed to connect successfully.
3. I hae also checkd all the environment variable used on ODBCINI file and they do exist.

I have looked at this thread as it is almost the same problem, but I am still stuck.
http://www.mqseries.net/phpBB2/viewtopic.php?t=30025&highlight=10g

I have created a script and I am directly calling it on my .profile.

Owwww please help
Back to top
View user's profile Send private message
matuwe
PostPosted: Wed Mar 17, 2010 11:08 pm    Post subject: Reply with quote

Master

Joined: 05 Dec 2007
Posts: 296

Here is a copy of my script , I have created this using the script I had on 6.1

export MQSI_FILENODES_ROOT_DIRECTORY=/home/wbrkadm/ftp/

export ORACLE_HOME=/uddora/app/oracle/product/10.2.0.1.0Client
export ORACLE_LIB=${ORACLE_HOME}/lib
export PATH=$ORACLE_HOME/bin:$PATH
export ORA_NLS10=$ORACLE_HOME/nls/data

ODBCINI64=${ODBCINI64:-${MQSI_REGISTRY}/odbc/odbc64.ini}
ODBCINI32=${ODBCINI32:-${MQSI_REGISTRY}/odbc/.odbc.ini}
ODBCINI=${ODBCINI:-${ODBCINI64}}
export ODBCINI ODBCINI64


#MQSI_LIBPATH64=
#export MQSI_LIBPATH64

MQSI_LILPATH32=${MQSI_FILEPATH}/lil:${MQSI_FILEPATH}/jplugin${MQSI_LILPATH32:+":"${MQSI_LILPATH32}}
MQSI_SECURITY_PROVIDER_PATH32=${MQSI_FILEPATH}/SecurityProviders${MQSI_SECURITY_PROVIDER_PATH32:+":"${MQSI_SECURITY_PROVIDER_PATH32}}

MQSI_EXMLTCONFIGPATH=${MQSI_FILEPATH}/exmltConfig


export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH
export SHLIB_PATH=$ORACLE_HOME/lib32:$SHLIB_PATH

MQSI_LILPATH32=${MQSI_FILEPATH}/lil:${MQSI_FILEPATH}/jplugin${MQSI_LILPATH32:+":"${MQSI_LILPATH32}}

LD_LIBRARY_PATH=${ORACLE_LIB}:${MQSI_FILEPATH}/lib:${MQSI_FILEPATH}/bin:${MQSI_FILEPATH}/ODBC/V6.0/lib:${MQSI_FILEPATH}/xml4c/lib:${MQSI_FILEPATH}/xlxpc/lib:
${LD_LIBRARY_PATH}
export LD_LIBRARY_PATH


MQSI_DEVELOPMENT=${MQSI_REGISTRY}/registry
LD_LIBRARY_PATH=/usr/mqm/java/lib:${LD_LIBRARY_PATH}

PATH=${MQSI_JREPATH}/bin:${PATH}
Back to top
View user's profile Send private message
matuwe
PostPosted: Thu Mar 18, 2010 1:02 am    Post subject: Reply with quote

Master

Joined: 05 Dec 2007
Posts: 296

This is the exact error that I am getting

Mar 18 08:53:07 sb5esb01 user:err|error WebSphere Broker v7000[401570]: (DAFRESB.DynamicInputs)[5144]BIP4623E: Exception condition detected by input node 'DelMecInputAdaptor.TimeoutNotification'. : DAFRESB.16f1451f-2701-0000-0080-af8b4d7f6491: /build/S000_P/src/DataFlowEngine/TimeoutControl/ImbTimeoutNotificationNode.cpp: 1522: ImbTimeoutNotificationNode::propagateToCatch: ComIbmTimeoutNotificationNode: DelMecInputAdaptor#FCMComposite_1_4
Mar 18 08:53:07 sb5esb01 user:err|error WebSphere Broker v7000[401570]: (DAFRESB.DynamicInputs)[5144]BIP2230E: Error detected whilst processing a message in node 'DelMecInputAdaptor.Cache Input Mechanism Data'. : DAFRESB.16f1451f-2701-0000-0080-af8b4d7f6491: /build/S000_P/src/DataFlowEngine/ImbComputeNode.cpp: 481: ImbComputeNode::evaluate: ComIbmComputeNode: DelMecInputAdaptor#FCMComposite_1_7
Mar 18 08:53:07 sb5esb01 user:err|error WebSphere Broker v7000[401570]: (DAFRESB.DynamicInputs)[5144]BIP2393E: Database error: ODBC return code '-1' from data source 'ESBDB'. : DAFRESB.16f1451f-2701-0000-0080-af8b4d7f6491: /build/S000_P/src/DataFlowEngine/ImbOdbc.cpp: 324: ImbOdbcHandle::checkRcInner: :
Mar 18 08:53:07 sb5esb01 user:err|error WebSphere Broker v7000[401570]: (DAFRESB.DynamicInputs)[5144]BIP2322E: Database error: SQL State '82'; Native Error Code '0'; Error Text '523 80'. : DAFRESB.16f1451f-2701-0000-0080-af8b4d7f6491: /build/S000_P/src/DataFlowEngine/ImbOdbc.cpp: 447: ImbOdbcHandle::checkRcInner:


and my ODBCINI file looks like


;# Oracle stanza
[ESBDB]
Driver=${MQSI_FILEPATH}/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 Oracle Wire Protocol
HostName=100.100.100.31
PortNumber=1521
SID=TESTDB
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=10

Back to top
View user's profile Send private message
AndreasMartens
PostPosted: Thu Mar 18, 2010 3:50 am    Post subject: Your $ODBCINI file isn't set up correctly Reply with quote

Acolyte

Joined: 30 Jan 2006
Posts: 65
Location: Hursley, UK

Hi,

You need to set up your odbc.ini a little bit better, you're almost there!

1. You cannot use ${MQSI_FILEPATH} as a variable in the ini file, put the actual full path in instead.

2. Make sure your [ODBC] section at the bottom of the file is correct to, specifically the "InstallDir=<Your Broker install directory>/ODBC/V6.0" line, as if this is invalid the drivers won't find all their files and will issue a 523 80.

I hope this helps,
Andreas
Back to top
View user's profile Send private message MSN Messenger
matuwe
PostPosted: Thu Mar 18, 2010 4:34 am    Post subject: Reply with quote

Master

Joined: 05 Dec 2007
Posts: 296

Amazing stuff

It worked, I change the ODBCINI to have the full path and it worked..

Thanks AndreasMartens
Back to top
View user's profile Send private message
Trainee
PostPosted: Tue Aug 03, 2010 2:42 pm    Post subject: odbc.ini Reply with quote

Centurion

Joined: 27 Oct 2006
Posts: 124

We did some thing similar to matuve's odbc.ini file.
We are going to run mqsisetdbparms .
We don't have oracle client. WMB7 that we installed is 64bit on linux.
Does it connects to external dabase?
Do I need to do more ?
Please advise

Thanks
Trainee
Back to top
View user's profile Send private message
mqjeff
PostPosted: Tue Aug 03, 2010 3:17 pm    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

You should have started a new thread and pointed back to this one.

Start here:
http://publib.boulder.ibm.com/infocenter/wmbhelp/v7r0m0/topic/com.ibm.etools.mft.doc/ah14440_.htm













Back to top
View user's profile Send private message
AndreasMartens
PostPosted: Wed Aug 04, 2010 1:45 am    Post subject: Huh? Reply with quote

Acolyte

Joined: 30 Jan 2006
Posts: 65
Location: Hursley, UK

Looks like mqjeff has found a cache of animated emoticons...

Trainee: Please do what mqjeff suggested and start a new thread. And when you do please be a bit more specific, information such as:
a) What you are trying to do
b) Exact product version
c) The error you're seeing
d) What you've tried to do to fix it.

If you are having database problems, we'll probably ask for one or more of the following:
- Your odbc.ini
- An odbc trace
- Usertrace of the operation you're attempting.

Thanks.

matuwe: Glad to be of service, hope all is well.
Back to top
View user's profile Send private message MSN Messenger
mqjeff
PostPosted: Wed Aug 04, 2010 2:03 am    Post subject: Re: Huh? Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

AndreasMartens wrote:
Looks like mqjeff has found a cache of animated emoticons...

all from the forum here. clickety-click on the "view more emoticons" button when posting.
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 » Broker 7 ODBC 64bit Datasource
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.