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 IndexWebSphere Message Broker (ACE) SupportDatabase Node - Remote ORACLE database - failure

Post new topicReply to topic
Database Node - Remote ORACLE database - failure View previous topic :: View next topic
Author Message
mqalf
PostPosted: Thu Oct 28, 2010 1:12 am Post subject: Database Node - Remote ORACLE database - failure Reply with quote

Novice

Joined: 22 Jan 2010
Posts: 12
I am trying to debug a flow which passes into a database node (which should be querying a remote ORCALE database). The flow is bombing when it hits the database node with no strong clues as to what has gone wrong.
I think I have set up my ODBC Data Source correctly - the Test Connect button works.
I have detailed below the first message from the event viewer and the associated dump file:

( WBRK61_DEFAULT_BROKER.default ) Broker process terminating abnormally: The following diagnostic information will be required when contacting IBM: '
Severe Abend Error detected.
For full details see Abend File: C:\Documents and Settings\All Users\Application Data\IBM\MQSI/common/errors/WBRK61_DEFAULT_BROKER.default.4788.6744.Abend
A summary of the Error follows:
An Unhandled Exception detected in process 4788, on thread 0x1A58.
Type: EXCEPTION_ACCESS_VIOLATION (C0000005).
Address: 001B:60AB79EA.
The thread could not read from memory address 0x00000000.
'.

A broker process is terminating abnormally.

Contact your IBM support center.

Dump:

+-----------------------------------------------------------------------------+
| |
| |
| First Failure Symptom Report |
| ======================== |
| |
| |
| |
| |
| |
| |
| |
| |
| Proc start time :- Thu Oct 28 09:18:39 2010 |
| |
| Product Details |
| +++++++++++++++ |
| |
| |
| |
| |
| |
| |
| |
| Vendor :- IBM |
| Product Name :- WebSphere Message Brokers |
| Program ID :- 5724-J04 |
| Version :- 6103 |
| |
| OS Information |
| ++++++++++++++ |
| |
| |
| |
| |
| |
| |
| |
| Operating System :- Microsoft Windows XP |
| Product Type :- Professional |
| Maintenance :- Service Pack 3 (Build 2600) |
| Node Name :- AGXP076117 |
| No of Processors :- 2 |
| Processor Type :- x86 Family 6 Model 23 Stepping 10 |
| Current Type :- Multiprocessor Free |
| Dbghelp version :- 0.0.0.0 |
| |
| Environment |
| +++++++++++ |
| |
| |
| |
| |
| |
| |
| |
| Installation Path :- C:\Program Files\IBM\MQSI\6.1 |
| Service User ID :- mqsiuid |
| Work Path :- C:\Documents and Settings\All Users\Application |
| Data\IBM\MQSI |
| |
| |
| |
| |
| |
| |
| |
| |
| Executable Name :- DataFlowEngine.exe |
| Process ID :- 4788 |
| |
| Deployment |
| ++++++++++ |
| |
| |
| |
| |
| |
| |
| |
| Component Name :- WBRK61_DEFAULT_BROKER |
| Component UUID :- a41c76a8-2601-0000-0080-bb76c7a8c301 |
| Queue Manager :- WBRK61_DEFAULT_QUEUE_MANAGER |
| User trace :- 0 |
| Service trace :- 0 |
| Trace size :- 0 |
| |
| Build Information |
| +++++++++++++++++ |
| |
| |
| |
| |
| |
| |
| |
| Backing build :- |
| Sandbox :- F:\build\S610_P |
| CMVC Level :- S610-FP03 |
| Build type :- Production |
| 64 Bit Build :- no |
| |
| Failure Location |
| ++++++++++++++++ |
| |
| |
| |
| |
| |
| |
| |
| Time of Report :- Thu Oct 28 09:48:09 2010 |
| Message Flow :- DocumentService_Request_V001 |
| Thread ID :- 0x00001A58 |
| |
+-----------------------------------------------------------------------------+

Abend Record for PID: 4788 TID: 0x1A58 on: Thu Oct 28 09:48:09 2010

---> Location <---
File: F:\build\S610_P\src\CommonServices\Win32\ImbAbend.cpp
Line: 2146
Function: ImbAbend::unhandledExceptionFilterInternal()
AbendAction: 3

---> Inserts <---
An Unhandled Exception detected in process 4788, on thread 0x1A58.
Type: EXCEPTION_ACCESS_VIOLATION (C0000005).
Address: 001B:60AB79EA.
The thread could not read from memory address 0x00000000.

---> Last Errors <---
Note these error codes are not necessarily reliable
GetLastError() returned: 3
errno returned: 0


---> Process Status <---
Memory:
Usage Load: 70 percent
Total Physical Memory: 3039156 Kbytes
Available Physical Memory: 882504 Kbytes
Total PageFile: 7431244 Kbytes
Available PageFile: 5078940 Kbytes
Total Virtual Memory: 2097024 Kbytes
Available Virtual Memory: 1600396 Kbytes
Available Extended Memory: 0 free Kbytes

Working Set:
Min: 200 Kbytes
Max: 1380 Kbytes

Timings:
Creation Time: D-28 M-10 Y-2010 : 8:18:39.199
Kernel Time: 2125 ms
User Time: 6890 ms

Wow64:
False: Running on 32 bit Windows

---> Process Environment Variables <---
=C:=C:\Program Files\ibm\MQSI\6.1\bin
ALLUSERSPROFILE=C:\Documents and Settings\All Users
BMC_GLOBALC_HOME=C:\Program Files\BMC Software\common\globalc
BMC_ROOT=C:\Program Files\BMC Software\
CLASSPATH=C:\Program Files\IBM\MQSI\6.1\messages;C:\Program Files\IBM\MQSI\6.1\classes;C:\Program Files\IBM\MQSI\6.1\classes\ConfigManagerProxy.jar;C:\Program Files\IBM\MQSI\6.1\classes\configutil.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mqjms.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mq.jar;.;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\PROGRA~1\IBM\SQLLIB\bin;C:\Documents and Settings\All Users\Application Data\IBM\MQSI\common\wsrr;C:\Program Files\IBM\MQSI\6.1\classes\com.ibm.mq.jar
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=AGXP076117
ComSpec=C:\WINDOWS\system32\cmd.exe
DB2INSTANCE=DB2
DB2PATH=C:\Program Files\IBM\SQLLIB
DB2TEMPDIR=C:\PROGRA~1\IBM\SQLLIB\
DISTHUB_PATH=C:\Program Files\IBM\MQSI\6.1
FP_NO_HOST_CHECK=NO
GC_LOCALEDIR=C:\Program Files\BMC Software\common\globalc\locale\Windows-x86
IBM_JAVACOREDIR=C:\Documents and Settings\All Users\Application Data\IBM\MQSI/common/errors/
include=C:\Program Files\IBM\MQSI\6.1\include;C:\Program Files\IBM\WebSphere MQ\tools\c\include;C:\Program Files\IBM\WebSphere MQ\tools\cplus\include;
lib=C:\Program Files\IBM\MQSI\6.1\lib;C:\Program Files\IBM\WebSphere MQ\tools\lib;
MQCHLLIB=C:\Program Files\ibm\WebSphere MQ\Qmgrs\WBRK61_DEFAULT_QUEUE_MANAGER\@ipcc
MQCHLTAB=AMQCLCHL.TAB
MQFT_JAVA_LIB_PATH=C:\Program Files\IBM\WebSphere MQ\java\lib
MQFT_JRE_BIN_PATH=C:\Program Files\IBM\WebSphere MQ\java\jre\bin
MQSICOMMAND_PATH="C:\Program Files\ibm\WMBT610"
MQSI_CATALINA_HOME=C:\Program Files\IBM\MQSI\6.1\catalina
MQSI_CONSOLE_NLSPATH=C:\Program Files\IBM\MQSI\6.1\messages\
MQSI_DEVELOPMENT=SOFTWARE\IBM\WebSphereMQIntegrator\2
MQSI_EXMLTCONFIGPATH=C:\Program Files\IBM\MQSI\6.1\exmltConfig
MQSI_FAD=4
MQSI_FILEPATH=C:\Program Files\IBM\MQSI\6.1
MQSI_JARPATH=C:\Program Files\IBM\MQSI\6.1\classes;C:\Program Files\IBM\MQSI\6.1\messages;
MQSI_JREPATH=C:\Program Files\IBM\MQSI\6.1\jre15
MQSI_LILPATH32=C:\Program Files\IBM\MQSI\6.1\bin;C:\Program Files\IBM\MQSI\6.1\jplugin;
MQSI_REGISTRY=C:\Documents and Settings\All Users\Application Data\IBM\MQSI
MQSI_SECURITY_PROVIDER_PATH32=C:\Program Files\IBM\MQSI\6.1\bin;
MQSI_VERSION=6.1.0.3
MQSI_VERSION_F=3
MQSI_VERSION_M=0
MQSI_VERSION_R=1
MQSI_VERSION_V=6
MQSI_WORKPATH=C:\Documents and Settings\All Users\Application Data\IBM\MQSI
MQ_FILE_PATH=C:\Program Files\IBM\WebSphere MQ\
MQ_JAVA_DATA_PATH=C:\Program Files\IBM\WebSphere MQ
MQ_JAVA_INSTALL_PATH=C:\Program Files\IBM\WebSphere MQ\Java
MQ_JAVA_LIB_PATH=C:\Program Files\IBM\WebSphere MQ\Java\lib
NUMBER_OF_PROCESSORS=2
ORACLE_HOME=C:\oracle\product\10.2.0
OS=Windows_NT
Path=C:\Program Files\IBM\MQSI\6.1\jre15\bin;"C:\Program Files\ibm\WMBT610";C:\Program Files\IBM\MQSI\6.1\bin;/bin;C:\Program Files\Common Files\OTG;C:\Perl\site\bin;C:\Perl\bin;C:\Program Files\IBM\WebSphere MQ\Java\lib;C:\oracle\product\10.2.0\client_1\BIN\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Personal Communications\;C:\Program Files\IBM\Trace Facility\;C:\Program Files\IDM Computer Solutions\UltraEdit-32\;C:\Program Files\Rational\common;C:\Program Files\Rational\ClearCase\bin;C:\Program Files\IBM\WebSphere MQ\bin;C:\Program Files\IBM\WebSphere MQ\tools\c\samples\bin;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\PROGRA~1\BMCSOF~1\common\bmc\bin\Windows-x86;C:\PROGRA~1\BMCSOF~1\common\globalc\bin\Windows-x86;C:\PROGRA~1\BMCSOF~1\Patrol3\bin;C:\PROGRA~1\BMCSOF~1\Patrol7\bin\Windows-x86;C:\Program Files\Common Files\Lenovo;;;C:\Program Files\IBM\WebSphere MQ\Java\lib;C:\Program Files\IBM\MQSI\6.1\bin;C:\Program Files\IBM\MQSI\6.1\jplugin;;;C:\Program Files\IBM\MQSI\6.1\bin;
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PATROL_GC_VERSION=v3.3.20
PATROL_HOME=C:\PROGRA~1\BMCSOF~1\Patrol3\
PATROL_ROOT=C:\Program Files\BMC Software\Patrol7
PATROL_TEMP=C:\PROGRA~1\BMCSOF~1\Patrol3\tmp
PCOMM_Root=C:\Program Files\Personal Communications\
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 23 Stepping 10, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=170a
ProgramFiles=C:\Program Files
PROMPT=$P$G
RTSERVERS=tcp:alcapppat001:2059
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\mqsiuid\LOCALS~1\Temp
TMP=C:\DOCUME~1\mqsiuid\LOCALS~1\Temp
USERDOMAIN=AGXP076117
USERNAME=mqsiuid
USERPROFILE=C:\Documents and Settings\mqsiuid
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
windir=C:\WINDOWS
__MSVCRT_HEAP_SELECT=__GLOBAL_HEAP_SELECTED,1


---> Stack dump for the faulting thread (0x1A58), with malloc disallowed. <---
Registers:
EAX=0x00000002 EBX=0x00000080 ECX=0x00000000 EDX=0x01FEC098
ESI=0x01FEC0FC EDI=0x00000000 EIP=0x60AB79EA ESP=0x0724694C
EBP=0x07246960 EFlags=0x00010212
CS=0x001B DS=0x0023 SS=0x0023 ES=0x0023 FS=0x003B GS=0x0000

Stack Backtrace:
# ChildEBP RetAddr Param#1 Param#2 Param#3 Param#4 Fn-Loc'n : Module!Function+Offset [File Name # Line+Offset @ Address]
00 07246960 61CD610E (61E0D718 00000000 01FEC0FC 00000002) 60AB79EA : oranls10!lxhLaToId+0x1e<NLN:487>
01 0724697C 61CD5FE2 (01FEC008 00005F15 07246DB8 61DDE5BC) 61CD610E : OraClient10!kpusebh+0x4fa<NLN:487>
02 0724698C 61DDE5BC (01FEC008 00005F15 0724698C 056FBFF8) 61CD5FE2 : OraClient10!kpusebh+0x3ce<NLN:487>
03 07246DB8 61CCDB09 (0866A79C 00000008 00000000 00000000) 61DDE5BC : OraClient10!OCIPHeapFree+0x89950<NLN:487>
04 07246DFC 61C261BC (0866A79C 00000008 00000000 00000000) 61CCDB09 : OraClient10!kpuinit+0x29<NLN:487>
05 07246E20 085F70F6 (0866A79C 00000008 00000000 00000000) 61C261BC : OraClient10!OCIEnvInit+0x28<NLN:487>
06 07246E38 286AB8C7 (0866A79C 00000008 00000000 00000000) 085F70F6 : OCI!OCIEnvInit+0x1e<NLN:487>
07 07246E3C 0866A79C (00000008 00000000 00000000 08666008) 286AB8C7 : UKOR823!getCompanyNameString+0x2667<NLN:487>
08 07246E40 00000000 (00000000 00000000 08666008 08666008) 0866A79C : ***StackWalk Warning: Module does not appear to exist. Following frames may be wrong. Error Code: 0 *** <Unknown:126><No Symbol Found>, Error Code: 126 <NLN:126>

---> Raw stack dump <---
ESP : 00 01 02 03-04 05 06 07-08 09 0A 0B-0C 0D 0E 0F ASCII 00 04 08 0C
0724694C: 00 00 00 00-d5 e6 da 61-70 c5 fe 01-9c a7 66 08 ....;.ap...Ϥf. 00000000 61dae6d5 01fec570 0866a79c
0724695C: 80 00 00 00-7c 69 24 07-0e 61 cd 61-18 d7 e0 61 €...|i$..a.a.×àa 00000080 0724697c 61cd610e 61e0d718
0724696C: 00 00 00 00-fc c0 fe 01-02 00 00 00-98 c0 fe 01 ....ü.......˜... 00000000 01fec0fc 00000002 01fec098
0724697C: 8c 69 24 07-e2 5f cd 61-08 c0 fe 01-15 5f 00 00 Œi$.â_.a....._.. 0724698c 61cd5fe2 01fec008 00005f15
0724698C: b8 6d 24 07-bc e5 dd 61-08 c0 fe 01-15 5f 00 00 ¸m$..åÝa....._.. 07246db8 61dde5bc 01fec008 00005f15
0724699C: 8c 69 24 07-f8 bf 6f 05-d0 6b 24 07-78 11 5d 05 Œi$.ø.o.Ðk$.x.]. 0724698c 056fbff8 07246bd0 055d1178
072469AC: 28 02 91 7c-03 00 00 00-22 02 91 7c-9b 01 91 7c (.‘|....".‘|›.‘| 7c910228 00000003 7c910222 7c91019b
072469BC: db 01 91 7c-98 56 32 06-18 00 00 00-43 3a 5c 6f ..‘|˜V2.....C:\o 7c9101db 06325698 00000018 6f5c3a43
072469CC: 72 61 63 6c-65 5c 70 72-6f 64 75 63-74 5c 31 30 racle\product\10 6c636172 72705c65 6375646f 30315c74
072469DC: 2e 32 2e 30-5c 6f 72 61-63 6f 72 65-5c 7a 6f 6e .2.0\oracore\zon 302e322e 61726f5c 65726f63 6e6f7a5c
072469EC: 65 69 6e 66-6f 5c 74 69-6d 65 7a 6c-72 67 2e 64 einfo\timezlrg.d 666e6965 69745c6f 6c7a656d 642e6772
072469FC: 61 74 00 00-00 00 00 00-00 00 00 00-00 00 00 00 at.............. 00007461 00000000 00000000 00000000
07246A0C: 00 00 00 00-00 00 00 00-00 00 00 00-00 00 00 00 ................ 00000000 00000000 00000000 00000000
07246A1C: 00 00 00 00-00 00 00 00-00 00 00 00-00 00 00 00 ................ 00000000 00000000 00000000 00000000
07246A2C: 00 00 00 00-00 00 00 00-00 00 00 00-00 00 00 00 ................ 00000000 00000000 00000000 00000000
07246A3C: 00 00 00 00-00 00 00 00-00 00 00 00-00 00 00 00 ................ 00000000 00000000 00000000 00000000
07246A4C: 00 00 00 00-00 00 00 00-00 00 00 00-00 00 00 00 ................ 00000000 00000000 00000000 00000000
07246A5C: 00 00 00 00-00 00 00 00-00 00 00 00-00 00 00 00 ................ 00000000 00000000 00000000 00000000
07246A6C: 00 00 00 00-00 00 00 00-00 00 00 00-00 00 00 00 ................ 00000000 00000000 00000000 00000000
07246A7C: 00 00 00 00-00 00 00 00-00 00 00 00-00 00 00 00 ................ 00000000 00000000 00000000 00000000

---> Loaded Modules <---
Start End SymTyp ImagePath (ModuleLinkTime) : SymbolPath
0x00400000 0x00405000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\DataFlowEngine.exe
0x7C900000 0x7C9B2000 SymExp C:\WINDOWS\system32\ntdll.dll (Mon Feb 09 12:10:48 2009 [49901D48])
0x7C800000 0x7C8F6000 SymDef C:\WINDOWS\system32\kernel32.dll
0x2DBE0000 0x2DBEB000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\Personality.dll
0x78130000 0x781CB000 SymDef C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.3053_x-ww_b80fa8ca\MSVCR80.dll
0x77C10000 0x77C68000 SymDef C:\WINDOWS\system32\msvcrt.dll
0x2F820000 0x2F9C8000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\CommonServices.dll
0x77DD0000 0x77E6B000 SymDef C:\WINDOWS\system32\ADVAPI32.dll
0x77E70000 0x77F02000 SymDef C:\WINDOWS\system32\RPCRT4.dll
0x77FE0000 0x77FF1000 SymDef C:\WINDOWS\system32\Secur32.dll
0x4A800000 0x4A895000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\icuuc32.dll
0x4AD00000 0x4B660000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\icudt32.dll
0x7C340000 0x7C396000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\MSVCR71.dll
0x4A900000 0x4A9AA000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\icuin32.dll
0x03000000 0x0311B000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\dbghelp.dll
0x76B40000 0x76B6D000 SymDef C:\WINDOWS\system32\WINMM.dll
0x77F10000 0x77F59000 SymDef C:\WINDOWS\system32\GDI32.dll
0x7E410000 0x7E4A1000 SymDef C:\WINDOWS\system32\USER32.dll
0x2EAE0000 0x2EAE8000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\ImbIbmts.dll
0x77C00000 0x77C08000 SymDef C:\WINDOWS\system32\VERSION.dll
0x71AB0000 0x71AC7000 SymDef C:\WINDOWS\system32\WS2_32.dll
0x71AA0000 0x71AA8000 SymDef C:\WINDOWS\system32\WS2HELP.dll
0x2DA40000 0x2DAD8000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\Stlport510.dll
0x7C420000 0x7C4A7000 SymDef C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.3053_x-ww_b80fa8ca\MSVCP80.dll
0x2FE30000 0x2FE3F000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\bipmain.dll
0x2E3D0000 0x2E62C000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\MessageServices.dll
0x003C0000 0x003E2000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\PlatFormSupport.dll
0x4FB80000 0x4FB8B000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\PSAPI.DLL
0x4FDE0000 0x4FDEE000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\MQM.dll
0x4E7E0000 0x4E9B9000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\AMQXCS2.dll
0x4EA20000 0x4EA36000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\amqxcsn.DLL
0x5B860000 0x5B8B5000 SymDef C:\WINDOWS\system32\NETAPI32.dll
0x4F750000 0x4F88A000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\AMQZST.dll
0x4F590000 0x4F5A3000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\AMQZC.dll
0x4D840000 0x4D84B000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\AMQLDATN.dll
0x4E750000 0x4E76C000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\AMQVWAA2.dll
0x4FF10000 0x4FF1C000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\MQMVXD.dll
0x4DFE0000 0x4E00E000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\amqmtmgr.dll
0x774E0000 0x7761D000 SymDef C:\WINDOWS\system32\ole32.dll
0x77120000 0x771AB000 SymDef C:\WINDOWS\system32\OLEAUT32.dll
0x4F8D0000 0x4F8E2000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\AMQZTM.dll
0x4F690000 0x4F6B8000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\amqzsai.dll
0x2EAA0000 0x2EABC000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\ImbJni.dll
0x74320000 0x7435D000 SymDef C:\WINDOWS\system32\ODBC32.dll
0x5D090000 0x5D12A000 SymDef C:\WINDOWS\system32\COMCTL32.dll
0x763B0000 0x763F9000 SymDef C:\WINDOWS\system32\comdlg32.dll
0x7C9C0000 0x7D1D7000 SymDef C:\WINDOWS\system32\SHELL32.dll
0x77F60000 0x77FD6000 SymDef C:\WINDOWS\system32\SHLWAPI.dll
0x76390000 0x763AD000 SymDef C:\WINDOWS\system32\IMM32.DLL
0x773D0000 0x774D3000 SymDef C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83\comctl32.dll
0x00A00000 0x00A17000 SymDef C:\WINDOWS\system32\odbcint.dll
0x10000000 0x10030000 SymDef C:\WINDOWS\system32\sxwmon32.dll
0x4FFB0000 0x4FFBB000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\mqutx.dll
0x2F170000 0x2F17B000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfdb2.lil
0x6C010000 0x6C6B5000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\DB2APP.dll
0x6C9F0000 0x6CB52000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\DB2SYS.dll
0x6EB20000 0x6EB2C000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\DB2WINT.dll
0x00C70000 0x00C91000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\DB2SYSP.dll
0x6CB60000 0x6CCFA000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\db2osse.dll
0x00CA0000 0x00D08000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\db2g11n.dll
0x00D10000 0x00D1C000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\db2locale.dll
0x00D20000 0x00D28000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\db2sec.dll
0x00D30000 0x00D39000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\db2trcapi.dll
0x00D40000 0x00D47000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\db2install.dll
0x00D50000 0x00D77000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\db2genreg.dll
0x00D80000 0x00D95000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\db2dascmn.dll
0x00DA0000 0x00DC8000 SymDef C:\PROGRA~1\IBM\SQLLIB\BIN\db2osse_db2.dll
0x77690000 0x776B1000 SymDef C:\WINDOWS\system32\NTMARTA.DLL
0x71BF0000 0x71C03000 SymDef C:\WINDOWS\system32\SAMLIB.dll
0x76F60000 0x76F8C000 SymDef C:\WINDOWS\system32\WLDAP32.dll
0x00E00000 0x00E0D000 SymDef C:\PROGRA~1\IBM\SQLLIB\bin\icc\icc\icclib\icclib.dll
0x00E10000 0x00EDD000 SymDef C:\PROGRA~1\IBM\SQLLIB\bin\icc\icc\osslib\libeay32.dll
0x71AD0000 0x71AD9000 SymDef C:\WINDOWS\system32\WSOCK32.dll
0x68000000 0x68036000 SymDef C:\WINDOWS\system32\rsaenh.dll
0x6C000000 0x6C00A000 SymDef C:\Program Files\IBM\SQLLIB\BIN\DB2CLI.DLL
0x01030000 0x01038000 SymDef C:\PROGRA~1\IBM\SQLLIB\security\plugin\IBM\client\IBMOSauthclient.dll
0x6EEC0000 0x6EED1000 SymDef C:\PROGRA~1\IBM\SQLLIB\bin\db2tcp.DLL
0x71A50000 0x71A8F000 SymDef C:\WINDOWS\System32\mswsock.dll
0x76F20000 0x76F47000 SymDef C:\WINDOWS\system32\DNSAPI.dll
0x76FB0000 0x76FB8000 SymDef C:\WINDOWS\System32\winrnr.dll
0x751D0000 0x751EE000 SymDef C:\WINDOWS\system32\wshbth.dll
0x77920000 0x77A13000 SymDef C:\WINDOWS\system32\SETUPAPI.dll
0x76FC0000 0x76FC6000 SymDef C:\WINDOWS\system32\rasadhlp.dll
0x662B0000 0x66308000 SymDef C:\WINDOWS\system32\hnetcfg.dll
0x71A90000 0x71A98000 SymDef C:\WINDOWS\System32\wshtcpip.dll
0x012D0000 0x012E6000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\dhbNBIO.dll
0x7C3A0000 0x7C41B000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\MSVCP71.dll
0x7E780000 0x7E78A000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\classic\jvm.dll
0x7E790000 0x7E7A3000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\j9vm\jvm.dll
0x7F040000 0x7F088000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\j9vm23.dll
0x7F0C0000 0x7F0CA000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\J9THR23.dll
0x7F870000 0x7F876000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\J9HOOKABLE23.dll
0x7F100000 0x7F11F000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\J9PRT23.dll
0x7F000000 0x7F011000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\j9zlib23.dll
0x7FA60000 0x7FA71000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\iverel23.dll
0x7F900000 0x7F919000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\j9dmp23.dll
0x7F0B0000 0x7F0BD000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\j9trc23.dll
0x7EBC0000 0x7EBC6000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\jsig.dll
0x7F940000 0x7F952000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\j9bcv23.dll
0x7F890000 0x7F8D3000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\j9gc23.dll
0x7F8E0000 0x7F8FC000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\j9dyn23.dll
0x7F120000 0x7F141000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\j9jvmti23.dll
0x7F020000 0x7F036000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\j9vrb23.dll
0x7EEE0000 0x7EF22000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\jclscar_23.dll
0x7EE80000 0x7EEB5000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\jdwp.dll
0x7F090000 0x7F0A9000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\j9ute23.dll
0x7EF90000 0x7EFBD000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\java.dll
0x7E7D0000 0x7E7D8000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\wrappers.dll
0x769C0000 0x76A74000 SymDef C:\WINDOWS\system32\userenv.dll
0x7E7B0000 0x7E7C9000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\zip.dll
0x7FB60000 0x7FB6B000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\dt_socket.dll
0x2FE10000 0x2FE1F000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\bipnativetrace.dll
0x2F590000 0x2F597000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\GenXmlFactory.lil
0x027A0000 0x027E1000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\GenXmlParser2.lil
0x2D3D0000 0x2D3DD000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\xmlcommon2.dll
0x02810000 0x029AB000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\xml4c_5_6.dll
0x029B0000 0x029CB000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\XML4CMessages5_6.DLL
0x2FB10000 0x2FB1E000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\bipprefixmgr.dll
0x2F4E0000 0x2F4EA000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbadpmgr.lil
0x2D8E0000 0x2D8F9000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\TextFileResMgr.dll
0x02A00000 0x02A99000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbjplg.dll
0x2EDC0000 0x2EE65000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfplg.lil
0x02AC0000 0x02D10000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\ImbRdl.dll
0x2E010000 0x2E200000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\MQLibrary.dll
0x4FEF0000 0x4FEFC000 SymDef C:\Program Files\IBM\WebSphere MQ\bin\MQMVX.dll
0x2D950000 0x2D996000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\TemplateNodes.dll
0x2F260000 0x2F296000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfagg.lil
0x2F200000 0x2F23A000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfbas.lil
0x2F1A0000 0x2F1B8000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfcfg.lil
0x2F120000 0x2F142000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfjmt.lil
0x03120000 0x032DB000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfjps.lil
0x2D860000 0x2D875000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\UGBroker.dll
0x7EAA0000 0x7EAC9000 SymDef C:\Program Files\IBM\MQSI\6.1\jre15\bin\net.dll
0x76D60000 0x76D79000 SymDef C:\WINDOWS\system32\iphlpapi.dll
0x76D40000 0x76D58000 SymDef C:\WINDOWS\system32\MPRAPI.dll
0x77CC0000 0x77CF2000 SymDef C:\WINDOWS\system32\ACTIVEDS.dll
0x76E10000 0x76E35000 SymDef C:\WINDOWS\system32\adsldpc.dll
0x76B20000 0x76B31000 SymDef C:\WINDOWS\system32\ATL.DLL
0x76E80000 0x76E8E000 SymDef C:\WINDOWS\system32\rtutils.dll
0x045E0000 0x04617000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfmqe.lil
0x02FE0000 0x02FEC000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfmqm.lil
0x2ECC0000 0x2ED27000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfscada.lil
0x2EC20000 0x2EC34000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfsmq.lil
0x04640000 0x04676000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfsql.lil
0x2EBA0000 0x2EBBB000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbdfws.lil
0x04840000 0x04A36000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\WSLibrary.dll
0x046B0000 0x0470E000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbgxml4.lil
0x04A40000 0x04B44000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\BIPNVBRT.dll
0x2EAC0000 0x2EACE000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbjcomp.lil
0x2E980000 0x2E986000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbjplug2.lil
0x2DC20000 0x2DC26000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\NativePersonality.dll
0x04770000 0x04778000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\JavaStartParameters.dll
0x068E0000 0x068FD000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbmimeparser.lil
0x2FFC0000 0x30049000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\bipbitstreamutilities.dll
0x2E940000 0x2E949000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbphpmgr.lil
0x06920000 0x06948000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbtimer.lil
0x06960000 0x06980000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbtnp.lil
0x06990000 0x06999000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbwtxmgr.lil
0x069B0000 0x069B9000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbxmlmgr.lil
0x069D0000 0x069DE000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbxsdmgr.lil
0x069F0000 0x069F9000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\imbxslmgr.lil
0x2DD20000 0x2DDC6000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\MtiImbParser.lil
0x2FAB0000 0x2FAD5000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\biprsmgr.dll
0x06A30000 0x06A77000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\bipstddictinfo.dll
0x2FE70000 0x2FE7B000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\bipdictinfo.dll
0x2FAF0000 0x2FAFD000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\biprgxutil.dll
0x2FE90000 0x2FEA0000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\bipdbrsmgr.rmg
0x2FEF0000 0x2FF30000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\bipcwfworker.wrk
0x2FB60000 0x2FB8F000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\bippdfworker.wrk
0x2FA00000 0x2FAA5000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\biptdsworker.wrk
0x06AF0000 0x06B4D000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\bipxmlworker.wrk
0x06B60000 0x06B79000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\ldapSecurityProvider.lsl
0x2D8B0000 0x2D8BF000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\tfimSecurityProvider.lsl
0x2D450000 0x2D45C000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\XAJdbcJni.dll
0x070D0000 0x07104000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\JDBCSwitch.dll
0x08510000 0x085B5000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\BIPNVBAT.dll
0x286A0000 0x287A9000 SymExp C:\Program Files\IBM\MQSI\6.1\bin\UKOR823.DLL (Wed Apr 23 19:26:50 2008 [480F7F6A])
0x088F0000 0x094EA000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\ukicu23.dll
0x085F0000 0x08647000 SymExp C:\oracle\product\10.2.0\client_1\BIN\OCI.dll (Tue Aug 30 04:47:37 2005 [4313D6D9])
0x5FE80000 0x5FE9B000 SymDef C:\WINDOWS\system32\odbccp32.dll
0x08670000 0x08687000 SymDef C:\Program Files\IBM\MQSI\6.1\bin\UKOR823R.DLL
0x61C20000 0x61E72000 SymExp C:\oracle\product\10.2.0\client_1\BIN\OraClient10.Dll (Tue Aug 30 03:22:32 2005 [4313C2E8])
0x60870000 0x60953000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oracore10.dll
0x60A80000 0x60B44000 SymExp C:\oracle\product\10.2.0\client_1\BIN\oranls10.dll (Wed Aug 17 21:53:24 2005 [4303A3C4])
0x63690000 0x636A8000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oraunls10.dll
0x60EB0000 0x60EB7000 SymDef C:\oracle\product\10.2.0\client_1\BIN\orauts.dll
0x636B0000 0x636B6000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oravsn10.dll
0x60FA0000 0x61092000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oracommon10.dll
0x60300000 0x60857000 SymDef C:\oracle\product\10.2.0\client_1\BIN\orageneric10.dll
0x63430000 0x63457000 SymDef C:\oracle\product\10.2.0\client_1\BIN\orasnls10.dll
0x094F0000 0x09650000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oraxml10.dll
0x086A0000 0x086B1000 SymDef C:\WINDOWS\system32\MSVCIRT.dll
0x60960000 0x60A6D000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oran10.dll
0x62740000 0x6277D000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oranl10.dll
0x62790000 0x627A7000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oranldap10.dll
0x627F0000 0x628F9000 SymDef C:\oracle\product\10.2.0\client_1\BIN\orannzsbb10.dll
0x62530000 0x62583000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oraldapclnt10.dll
0x62670000 0x6268B000 SymDef C:\oracle\product\10.2.0\client_1\BIN\orancrypt10.dll
0x62920000 0x6296C000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oranro10.dll
0x626B0000 0x626B7000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oranhost10.dll
0x62660000 0x62666000 SymDef C:\oracle\product\10.2.0\client_1\BIN\orancds10.dll
0x629C0000 0x629C8000 SymDef C:\oracle\product\10.2.0\client_1\BIN\orantns10.dll
0x60B50000 0x60EA8000 SymDef C:\oracle\product\10.2.0\client_1\BIN\orapls10.dll
0x086C0000 0x086C9000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oraslax10.dll
0x63080000 0x63284000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oraplp10.dll
0x61ED0000 0x61F5B000 SymDef C:\oracle\product\10.2.0\client_1\BIN\orahasgen10.dll
0x62AB0000 0x62B1A000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oraocr10.dll
0x62B20000 0x62B60000 SymDef C:\oracle\product\10.2.0\client_1\BIN\oraocrb10.dll
0x62980000 0x62990000 SymDef C:\oracle\product\10.2.0\client_1\BIN\orantcp10.dll
0x09650000 0x096EA000 SymDef C:\oracle\product\10.2.0\client_1\BIN\orasql10.dll
--+++--

---> Sys Info <---
Machine Name: AGXP076117
Process User Name: mqsiuid
No of Processors: 2
Processor Type: x86 Family 6 Model 23 Stepping 10
OS: Microsoft Windows XP Professional Service Pack 3 (Build 2600)
Current Type: Multiprocessor Free
Command Line: "C:\Program Files\IBM\MQSI\6.1\bin\DataFlowEngine.exe" "WBRK61_DEFAULT_BROKER" "8914b6b6-2901-0000-0080-aec7e52a55da" "default" "1"
CMVC: @(#) 1.47.1.3 CommonServices/Win32/ImbAbend.cpp, CommonServices, S610, S610-L81016 08/10/16 14:46:09 [10/16/08 20:00:19]
Lib Version: 0.0.0.0 : Required Version: TRUE

---> Sym Search Path <---
.

--->------------------------------<ABEND FILE END>------------------------------<---

Any ideas anyone?
Back to top
View user's profile Send private message
smdavies99
PostPosted: Thu Oct 28, 2010 1:55 am Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
Which ODBC Driver did you setup the DSN with?

Don't use the Oracle ODBC drivers. PErhaps this is what you have done?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
mqalf
PostPosted: Thu Oct 28, 2010 2:21 am Post subject: Database Node - Remote ORACLE database - failure Reply with quote

Novice

Joined: 22 Jan 2010
Posts: 12
Thanks, I used MQSeries DataDirect Technologies 5.3 32-BIT Oracle driver.
Back to top
View user's profile Send private message
mqalf
PostPosted: Thu Oct 28, 2010 2:26 am Post subject: Reply with quote

Novice

Joined: 22 Jan 2010
Posts: 12
When I "Test Connect" through the ODBC set up I have to enter my userid and password and it works. Im wondering whether its fo do with my dbparms? I used the following command to set this up:
mqsisetdbparms WBRK61_DEFAULT_BROKER -n DSN -u xxxxxxx -p xxxxxxx
Back to top
View user's profile Send private message
mqjeff
PostPosted: Thu Oct 28, 2010 3:20 am Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447
Fix this.
Quote:

| Version :- 6103 |


It should read 6108.
Back to top
View user's profile Send private message
mqalf
PostPosted: Thu Oct 28, 2010 4:47 am Post subject: Reply with quote

Novice

Joined: 22 Jan 2010
Posts: 12
Thanks for that. Im now on version 6.1.0.8 - Im now getting a new error

( WBRK61_DEFAULT_BROKER.default ) Database error: SQL State ''08001''; Native Error Code ''12154''; Error Text ''[DataDirect][ODBC Oracle driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified ''.

The error has the following diagnostic information: SQL State ''08001'' SQL Native Error Code ''12154'' SQL Error Text ''[DataDirect][ODBC Oracle driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified ''

This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
Back to top
View user's profile Send private message
mqjeff
PostPosted: Thu Oct 28, 2010 6:05 am Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447
That's an error in the Oracle client setup.

Review your odbc ini setup. Make sure you've specified the right things to allow the 32-bit drivers to find and use the Oracle client and find and use the TNSNAMES.ORA file. Then make sure the TNSNAMES.ORA file has an entry for the database you're trying to use.
Back to top
View user's profile Send private message
mqalf
PostPosted: Thu Oct 28, 2010 7:55 am Post subject: Reply with quote

Novice

Joined: 22 Jan 2010
Posts: 12
I have double checked my odbc settings and can't see anything wrong

ODBC32.ini reference

# Oracle stanza - points to PRE_PROD
[ORACLE_ECOMMERCE]
Driver=/opt/IBM/mqsi/6.1/ODBC32/V5.3/lib/UKor823.so
Description=DataDirect 5.3 Oracle Driver
EnableDescribeParam=1
OptimizePrepare=1
ServerName=ORCL
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1

tnsnames.ora reference:

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = rs6tdb04) (PORT = 1521))
)
(CONNECT_DATA = (SID = ORCL)
)
)
Back to top
View user's profile Send private message
mqalf
PostPosted: Fri Oct 29, 2010 12:39 am Post subject: Reply with quote

Novice

Joined: 22 Jan 2010
Posts: 12
Managed to get it sorted!

Turns out I had to add an mqsisetdbparms using the databse schema name as user id and password (?) .... don't ask me why, Im assuming it's maybe a local thing to do with the way our datatbases are set up?

Many thanks for all you help though, you sent me down the right proad.

I am a happy chappy!
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker (ACE) SupportDatabase Node - Remote ORACLE database - failure
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.