| Author |
Message
|
| matuwe |
 Posted: Wed Mar 17, 2010 10:56 pm Post subject: Broker 7 ODBC 64bit Datasource |
 |
|
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 |
|
 |
| matuwe |
| Posted: Wed Mar 17, 2010 11:08 pm Post subject: |
|
|
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 |
|
|
| matuwe |
| Posted: Thu Mar 18, 2010 1:02 am Post subject: |
|
|
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 |
|
|
| AndreasMartens |
| Posted: Thu Mar 18, 2010 3:50 am Post subject: Your $ODBCINI file isn't set up correctly |
|
|
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 |
|
|
| matuwe |
| Posted: Thu Mar 18, 2010 4:34 am Post subject: |
|
|
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 |
|
|
| Trainee |
| Posted: Tue Aug 03, 2010 2:42 pm Post subject: odbc.ini |
|
|
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 |
|
|
| mqjeff |
| Posted: Tue Aug 03, 2010 3:17 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| AndreasMartens |
| Posted: Wed Aug 04, 2010 1:45 am Post subject: Huh? |
|
|
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 |
|
|
| mqjeff |
| Posted: Wed Aug 04, 2010 2:03 am Post subject: Re: Huh? |
|
|
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 |
|
|
|
|
