Database Software

Hello,

I have to set up a link between IBM WebSphere (MQSeries) 6.0 and Oracle 9i on WinXP. I'm using Oracle Procedural Gateway. I've successfully installed and tested the gateway, meaning that I can put and get messages from MQ queue using test scripts. I've also installed Visual Workbench and created a mapping that seems to be working properly (I can get and put messages on MQ queue). The problem is that I[b] can't create a propagation between Oracle and IBM queues (inbound or outbound). When I try to do that by calling dbms_hqadm.schedule_propagation, nothing happens. Querying the DBA_OUTBOUND_SCHEDULES or DBA_INBOUND_SCHEDULES, I can see that propagations have failed, but with no error messages. On the IBM side, though, I get an error "WinNT error 5 from OpenProces".

I'm sending an excerpt from IBM error logs.

Any help would be appreciated.

Regards,
Marin

-----------------------------------------------------------------------------
| |
| WebSphere MQ First Failure Symptom Report |
| ========================================= |
| |
| Date/Time :- Thu September 13 08:29:00 Central European Standard T |
| Host Name :- ZGSERVER (Windows XP Build 2600: Service Pack 2) |
| PIDS :- 5724H7200 |
| LVLS :- 6.0.0.0 |
| Product Long Name :- WebSphere MQ for Windows |
| Vendor :- IBM |
| Probe Id :- XY485114 |
| Application Name :- MQM |
| Component :- xcsDerestrictProcessHandle |
| SCCS Info :- lib/cs/pc/winnt/amqxsecn.c, 1.109 |
| Line Number :- 1018 |
| Build Date :- May 24 2005 |
| CMVC level :- p000-L050524 |
| Build Type :- IKAP - (Production) |
| UserID :- TEST |
| Process Name :- D:\oracle\ora92\bin\pg4mqs92.exe |
| Process :- 00000704 |
| Thread :- 00000001 |
| Major Errorcode :- xecF_E_UNEXPECTED_SYSTEM_RC |
| Minor Errorcode :- OK |
| Probe Type :- MSGAMQ6119 |
| Probe Severity :- 2 |
| Probe Description :- AMQ6119: An internal WebSphere MQ error has occurred |
| (WinNT error 5 from OpenProcess.) |
| FDCSequenceNumber :- 0 |
| Comment1 :- WinNT error 5 from OpenProcess. |
| |
| Comment2 :- Access is denied. |
| |
| |
-----------------------------------------------------------------------------

MQM Function Stack
MQCONN
trmzstMQCONNX
zstMQCONN
zstMQConnect
zstInitCS
xcsInitialize
xcsDerestrictProcessHandle
xcsFFST

MQM Trace History
{ InitProcessInitialisation
-{ xcsReleaseThreadMutexSem
-} xcsReleaseThreadMutexSem rc=OK
-{ xcsGetEnvironmentString
-} xcsGetEnvironmentString rc=xecE_E_ENV_VAR_NOT_FOUND
-{ xcsGetEnvironmentInteger
--{ xcsGetEnvironmentString
--} xcsGetEnvironmentString rc=xecE_E_ENV_VAR_NOT_FOUND
-} xcsGetEnvironmentInteger rc=xecE_E_ENV_VAR_NOT_FOUND
} InitProcessInitialisation rc=OK
{ xcsCreateThreadMutexSem
-{ xcsCloseHandle
-} xcsCloseHandle rc=Unknown(1)
} xcsCreateThreadMutexSem rc=OK
{ DLLMain
-{ MCSInitCriticalSection
-} MCSInitCriticalSection rc=OK
-{ InitializeGCS
--{ MCSInitCriticalSection
--} MCSInitCriticalSection rc=OK
-} InitializeGCS rc=OK
} DLLMain rc=Unknown(1)
{ MQCONN
-{ trmzstMQCONNX
--{ MCSGetDefaultThreadModel
--} MCSGetDefaultThreadModel rc=OK
--{ IsMTSEnvironment
--} IsMTSEnvironment rc=OK
--{ zstMQCONN
---{ xcsInitialize
----{ xcsRequestThreadMutexSem
----} xcsRequestThreadMutexSem rc=OK
----{ xcsGetNTUserName
----} xcsGetNTUserName rc=OK
----{ xcsGetNTOwnerSid
----} xcsGetNTOwnerSid rc=OK
----{ xcsReleaseThreadMutexSem
----} xcsReleaseThreadMutexSem rc=OK
----{ xcsUpdateThreadUserDetails
-----{ xcsGetNTOwnerSid
-----} xcsGetNTOwnerSid rc=OK
----} xcsUpdateThreadUserDetails rc=OK
----{ xcsRequestThreadMutexSem
----} xcsRequestThreadMutexSem rc=OK
----{ xihCheckThreadList
----} xihCheckThreadList rc=OK
----{ xcsReleaseThreadMutexSem
----} xcsReleaseThreadMutexSem rc=OK
---} xcsInitialize rc=OK
---{ zstMQConnect
----{ zstMQConnect_CheckParameters
-----{ xcsCheckPointer
-----} xcsCheckPointer rc=OK
-----{ xcsCheckPointer
-----} xcsCheckPointer rc=OK
----} zstMQConnect_CheckParameters rc=OK
----{ zutBlankPad
----} zutBlankPad rc=OK
----{ zutLockLocalThreads
-----{ xcsCreateThreadMutexSem
-----} xcsCreateThreadMutexSem rc=OK
----} zutLockLocalThreads rc=OK
----{ zutIsItBlank
----} zutIsItBlank rc=OK
----{ zutCheckQMName
-----{ zutCheckValidName
-----} zutCheckValidName rc=OK
----} zutCheckQMName rc=OK
----{ zutCvtMQName2Str
----} zutCvtMQName2Str rc=OK
----{ zutQuickInquire
-----{ xcsGetQMgrLocation
-----} xcsGetQMgrLocation rc=OK
----} zutQuickInquire rc=OK
----{ zstGetPCDbyTID
----} zstGetPCDbyTID rc=OK
----{ zstInitCS
-----{ xcsInitialize
------{ xcsUpdateThreadUserDetails
-------{ xcsGetNTOwnerSid
-------} xcsGetNTOwnerSid rc=OK
------} xcsUpdateThreadUserDetails rc=OK
------{ xcsRequestThreadMutexSem
------} xcsRequestThreadMutexSem rc=OK
------{ xihCheckThreadList
------} xihCheckThreadList rc=OK
------{ xcsInitGlobalSecurityData
-------{ xcsRequestThreadMutexSem
-------} xcsRequestThreadMutexSem rc=OK
-------{ xcsGetNTGroupSID
--------{ xcsTimedLookupAccountName
--------} xcsTimedLookupAccountName rc=OK
-------} xcsGetNTGroupSID rc=OK
-------{ xcsReleaseThreadMutexSem
-------} xcsReleaseThreadMutexSem rc=OK
------} xcsInitGlobalSecurityData rc=OK
------{ InitPrivateServices
-------{ xcsGetEnvironmentString
-------} xcsGetEnvironmentString rc=xecE_E_ENV_VAR_NOT_FOUND
-------{ xcsGetEnvironmentString
-------} xcsGetEnvironmentString rc=xecE_E_ENV_VAR_NOT_FOUND
-------{ xcsCreateThreadMutexSem
-------} xcsCreateThreadMutexSem rc=OK
-------{ xcsForcePSAPILoaded
-------} xcsForcePSAPILoaded rc=OK
------} InitPrivateServices rc=OK
------{ xcsDerestrictProcessHandle
-------{ xcsFFST

(...)

Component Dumps (Thread 00000001)
-------------------------------------

Environment Variables
ALLUSERSPROFILE=C:\Documents and Settings\All Users
CLASSPATH=C:\Program Files\IBM\WebSphere MQ\lib\com.ibm.mqetclient.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\providerutil.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mqjms.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\ldap.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jta.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jndi.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jms.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\connector.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\fscontext.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mq.jar
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=ZGSERVER
ComSpec=C:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK=NO
ORACLE_HOME=D:\oracle\ora92
ORACLE_SID=pg4mqs92
include=C:\Program Files\IBM\WebSphere MQ\tools\c\include;C:\Program Files\IBM\WebSphere MQ\tools\cplus\include
JSERV=D:\oracle\ora92/Apache/Jserv/conf
lib=C:\Program Files\IBM\WebSphere MQ\tools\lib
MQFT_JAVA_LIB_PATH=C:\Program Files\IBM\WebSphere MQ\java\lib
MQFT_JRE_BIN_PATH=C:\Program Files\IBM\Eclipse SDK30eclipse\jre\bin
MQ_JAVA_CAP_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=1
OS=Windows_NT
Path=C:\Program Files\IBM\WebSphere MQ\Java\lib;D:\oracle\ora92\bin;D:\oracle\orant\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\Program Files\PC Connectivity Solution\;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\IBM\WebSphere MQ\bin;C:\Program Files\IBM\WebSphere MQ\tools\c\samples\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 79 Stepping 2, AuthenticAMD
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=4f02
ProgramFiles=C:\Program Files
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\WINDOWS\system32\config\SYSTEM~1\LOCALS~1\Temp
TMP=C:\WINDOWS\system32\config\SYSTEM~1\LOCALS~1\Temp
USERPROFILE=C:\Documents and Settings\LocalService
windir=C:\WINDOWS
WV_GATEWAY_CFG=D:\oracle\ora92\Apache\modplsql\cfg\wdbsvr.app