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 » IBM MQ Java / JMS » QM as transaction coordinator

Post new topic  Reply to topic
 QM as transaction coordinator « View previous topic :: View next topic » 
Author Message
fjcarretero
PostPosted: Fri Dec 03, 2004 1:42 pm    Post subject: QM as transaction coordinator Reply with quote

Voyager

Joined: 13 Oct 2003
Posts: 88
Hi all,

This is my system
MQServer v5.3 CSD07
Oracle 9.2.0.4
Java 1.4

I have configured Oracle as a XA resource. The QM starts without any problem.

But when I call qMgr.begin it throws an MQRC 2195, and it also creates an FDC file:
Code:
WebSphere MQ First Failure Symptom Report                                   |
| =========================================                                   |
|                                                                             |
| Date/Time         :- vie diciembre 03 18:04:40 Hor 2004                     |
| Host Name         :- PEPITO (Windows XP Build 2600: Service Pack 1)         |
| PIDS              :- 5724B4100                                              |
| LVLS              :- 530.7  CSD07                                           |
| Product Long Name :- WebSphere MQ for Windows                               |
| Vendor            :- IBM                                                    |
| Probe Id          :- ZM008001                                               |
| Application Name  :- MQM                                                    |
| Component         :- ztmAssociateParticipants                               |
| Build Date        :- May 28 2004                                            |
| CMVC level        :- p530-07-L040527                                        |
| Build Type        :- IKAP - (Production)                                    |
| UserID            :- felipe                                                 |
| Process Name      :- C:\j2sdk1.4.2_04\bin\javaw.exe                         |
| Process           :- 00003068                                               |
| Thread            :- 00000002                                               |
| QueueManager      :- QMSU031                                                |
| Major Errorcode   :- trcE_UNEXPECTED_RM_ERROR                               |
| Minor Errorcode   :- OK                                                     |
| Probe Type        :- MSGAMQ7605                                             |
| Probe Severity    :- 2                                                      |
| Probe Description :- AMQ7605: El gestor de recursos XA XA ha devuelto un    |
|   código de retorno inesperado -3, cuando se le llamó para xa_start.        |
| FDCSequenceNumber :- 0                                                      |
| Arith1            :- 4294967293 fffffffd                                    |
| Arith2            :- 1 1                                                    |
| Comment1          :- XA                                                     |
|                                                                             |
| Comment2          :- xa_start                                               |
|                                                                             |
| Comment3          :-                                                        |
|   4D514D000F00000004000000C8D2B04120000301514D535530333100000001            |
|                                                                             |
+-----------------------------------------------------------------------------+
 
MQM Function Stack
MQBEGIN
trmzstMQBEGIN
zstMQBEGIN
ziiMQBEGIN
ztmAssociateParticipants
xcsFFST
 
MQM Trace History
-------} xcsRequestThreadMutexSem rc=OK
-------{ xcsRequestThreadMutexSem
-------} xcsRequestThreadMutexSem rc=OK
-------{ xcsReleaseThreadMutexSem
-------} xcsReleaseThreadMutexSem rc=OK
-------{ xstAttachSharedMemSet
--------{ xstConnectExtent
---------{ xcsRequestThreadMutexSem
---------} xcsRequestThreadMutexSem rc=OK
---------{ xstStorageRequest
----------{ xstServerRequest
----------} xstServerRequest rc=OK
---------} xstStorageRequest rc=OK
---------{ xcsReleaseThreadMutexSem
---------} xcsReleaseThreadMutexSem rc=OK
--------} xstConnectExtent rc=OK
--------{ xcsGetMem
--------} xcsGetMem rc=OK
--------{ xcsGetMem
--------} xcsGetMem rc=OK
-------} xstAttachSharedMemSet rc=OK
-------{ xcsReleaseThreadMutexSem
-------} xcsReleaseThreadMutexSem rc=OK
------} xcsConnectSharedMemSet rc=OK
-----} ziiStartAllPlugServices rc=OK
-----{ ziiCreateIPCCMessage
------{ zcpCreateMessage
------} zcpCreateMessage rc=OK
-----} ziiCreateIPCCMessage rc=OK
-----{ ziiSendReceiveAgent
------{ zcpSendOnPipe
-------{ xcsResetEventSem
--------{ xllAccessEventHandle
--------} xllAccessEventHandle rc=OK
-------} xcsResetEventSem rc=OK
-------{ xcsPostEventSem
--------{ xllAccessEventHandle
--------} xllAccessEventHandle rc=OK
-------} xcsPostEventSem rc=OK
------} zcpSendOnPipe rc=OK
------{ zcpReceiveOnPipe
-------{ xcsWaitEventSem
-------} xcsWaitEventSem rc=OK
------} zcpReceiveOnPipe rc=OK
-----} ziiSendReceiveAgent rc=OK
-----{ zcpDeleteMessage
-----} zcpDeleteMessage rc=OK
----} ziiMQCONN rc=OK
---} zstMQConnect rc=OK
--} zstMQCONN rc=OK
-} trmzstMQCONNX rc=OK
} MQCONN rc=OK
{ MQOPEN
-{ zstMQOPEN
--{ zstVerifyPCD
--} zstVerifyPCD rc=OK
--{ zstCheckODAddressability
---{ xcsCheckPointer
---} xcsCheckPointer rc=OK
--} zstCheckODAddressability rc=OK
--{ xcsCheckPointer
--} xcsCheckPointer rc=OK
--{ ziiMQOPEN
---{ ziiCreateIPCCMessage
----{ zcpCreateMessage
----} zcpCreateMessage rc=OK
---} ziiCreateIPCCMessage rc=OK
---{ ziiSendReceiveAgent
----{ zcpSendOnPipe
-----{ xcsResetEventSem
-----} xcsResetEventSem rc=OK
-----{ xcsPostEventSem
-----} xcsPostEventSem rc=OK
----} zcpSendOnPipe rc=OK
----{ zcpReceiveOnPipe
-----{ xcsWaitEventSem
-----} xcsWaitEventSem rc=OK
----} zcpReceiveOnPipe rc=OK
---} ziiSendReceiveAgent rc=OK
---{ zcpDeleteMessage
---} zcpDeleteMessage rc=OK
--} ziiMQOPEN rc=OK
-} zstMQOPEN rc=OK
} MQOPEN rc=OK
{ MQINQ
-{ zstMQINQ
--{ zstVerifyPCD
--} zstVerifyPCD rc=OK
--{ xcsCheckPointer
--} xcsCheckPointer rc=OK
--{ xcsCheckPointer
--} xcsCheckPointer rc=OK
--{ ziiMQINQ
---{ ziiCreateIPCCMessage
----{ zcpCreateMessage
----} zcpCreateMessage rc=OK
---} ziiCreateIPCCMessage rc=OK
---{ ziiSendReceiveAgent
----{ zcpSendOnPipe
-----{ xcsResetEventSem
-----} xcsResetEventSem rc=OK
-----{ xcsPostEventSem
-----} xcsPostEventSem rc=OK
----} zcpSendOnPipe rc=OK
----{ zcpReceiveOnPipe
-----{ xcsWaitEventSem
-----} xcsWaitEventSem rc=OK
----} zcpReceiveOnPipe rc=OK
---} ziiSendReceiveAgent rc=OK
---{ zcpDeleteMessage
---} zcpDeleteMessage rc=OK
--} ziiMQINQ rc=OK
-} zstMQINQ rc=OK
} MQINQ rc=OK
{ MQCLOSE
-{ zstMQCLOSE
--{ zstVerifyPCD
--} zstVerifyPCD rc=OK
--{ xcsCheckPointer
--} xcsCheckPointer rc=OK
--{ ziiMQCLOSE
---{ ziiCreateIPCCMessage
----{ zcpCreateMessage
----} zcpCreateMessage rc=OK
---} ziiCreateIPCCMessage rc=OK
---{ ziiSendReceiveAgent
----{ zcpSendOnPipe
-----{ xcsResetEventSem
-----} xcsResetEventSem rc=OK
-----{ xcsPostEventSem
-----} xcsPostEventSem rc=OK
----} zcpSendOnPipe rc=OK
----{ zcpReceiveOnPipe
-----{ xcsWaitEventSem
-----} xcsWaitEventSem rc=OK
----} zcpReceiveOnPipe rc=OK
---} ziiSendReceiveAgent rc=OK
---{ zcpDeleteMessage
---} zcpDeleteMessage rc=OK
--} ziiMQCLOSE rc=OK
-} zstMQCLOSE rc=OK
} MQCLOSE rc=OK
{ MQOPEN
-{ zstMQOPEN
--{ zstVerifyPCD
--} zstVerifyPCD rc=OK
--{ zstCheckODAddressability
---{ xcsCheckPointer
---} xcsCheckPointer rc=OK
--} zstCheckODAddressability rc=OK
--{ xcsCheckPointer
--} xcsCheckPointer rc=OK
--{ ziiMQOPEN
---{ ziiCreateIPCCMessage
----{ zcpCreateMessage
----} zcpCreateMessage rc=OK
---} ziiCreateIPCCMessage rc=OK
---{ ziiSendReceiveAgent
----{ zcpSendOnPipe
-----{ xcsResetEventSem
-----} xcsResetEventSem rc=OK
-----{ xcsPostEventSem
-----} xcsPostEventSem rc=OK
----} zcpSendOnPipe rc=OK
----{ zcpReceiveOnPipe
-----{ xcsWaitEventSem
-----} xcsWaitEventSem rc=OK
----} zcpReceiveOnPipe rc=OK
---} ziiSendReceiveAgent rc=OK
---{ zcpDeleteMessage
---} zcpDeleteMessage rc=OK
--} ziiMQOPEN rc=OK
-} zstMQOPEN rc=OK
} MQOPEN rc=OK
{ MQOPEN
-{ zstMQOPEN
--{ zstVerifyPCD
--} zstVerifyPCD rc=OK
--{ zstCheckODAddressability
---{ xcsCheckPointer
---} xcsCheckPointer rc=OK
--} zstCheckODAddressability rc=OK
--{ xcsCheckPointer
--} xcsCheckPointer rc=OK
--{ ziiMQOPEN
---{ ziiCreateIPCCMessage
----{ zcpCreateMessage
----} zcpCreateMessage rc=OK
---} ziiCreateIPCCMessage rc=OK
---{ ziiSendReceiveAgent
----{ zcpSendOnPipe
-----{ xcsResetEventSem
-----} xcsResetEventSem rc=OK
-----{ xcsPostEventSem
-----} xcsPostEventSem rc=OK
----} zcpSendOnPipe rc=OK
----{ zcpReceiveOnPipe
-----{ xcsWaitEventSem
-----} xcsWaitEventSem rc=OK
----} zcpReceiveOnPipe rc=OK
---} ziiSendReceiveAgent rc=OK
---{ zcpDeleteMessage
---} zcpDeleteMessage rc=OK
--} ziiMQOPEN rc=OK
-} zstMQOPEN rc=OK
} MQOPEN rc=OK
{ MQBEGIN
-{ trmzstMQBEGIN
--{ zstMQBEGIN
---{ zstVerifyPCD
---} zstVerifyPCD rc=OK
---{ zstSetMQModel
---} zstSetMQModel rc=OK
---{ xcsCheckPointer
---} xcsCheckPointer rc=OK
---{ ziiMQBEGIN
----{ ztmBeginInitialise
-----{ tmsLoadXASwitch
------{ xcsRequestThreadMutexSem
------} xcsRequestThreadMutexSem rc=OK
------{ xcsLoadFunction
------} xcsLoadFunction rc=OK
------{ xcsGetMem
------} xcsGetMem rc=OK
------{ xcsReleaseThreadMutexSem
------} xcsReleaseThreadMutexSem rc=OK
-----} tmsLoadXASwitch rc=OK
----} ztmBeginInitialise rc=OK
----{ ziiCreateIPCCMessage
-----{ zcpCreateMessage
-----} zcpCreateMessage rc=OK
----} ziiCreateIPCCMessage rc=OK
----{ ziiSendReceiveAgent
-----{ zcpSendOnPipe
------{ xcsResetEventSem
------} xcsResetEventSem rc=OK
------{ xcsPostEventSem
------} xcsPostEventSem rc=OK
-----} zcpSendOnPipe rc=OK
-----{ zcpReceiveOnPipe
------{ xcsWaitEventSem
------} xcsWaitEventSem rc=OK
-----} zcpReceiveOnPipe rc=OK
----} ziiSendReceiveAgent rc=OK
----{ ztmAssociateParticipants
-----{ xcsBuildDumpPtr
------{ xcsGetMem
------} xcsGetMem rc=OK
-----} xcsBuildDumpPtr rc=OK
-----{ xcsFFST


Does anyone know how to solve this problem?. I think it's a problem with the oracle configuration.

TIA
Cheers
Felipe
Back to top
View user's profile Send private message
csmith28
PostPosted: Fri Dec 03, 2004 3:43 pm    Post subject: Reply with quote

Grand Master

Joined: 15 Jul 2003
Posts: 1196
Location: Arizona
$ mqrc AMQ7605

536901125 0x20007605 trcE_UNEXPECTED_RM_ERROR

MESSAGE:
The XA resource manager <insert one> has returned an unexpected return code
1111, when called for <insert two>.

EXPLANATION:
WebSphere MQ received an unexpected return code when calling XA resource
manager <insert one> at its <insert two> entry point. This indicates an
internal error, either within MQ or the resource manager.

ACTION:
Try to determine the source of the error. A trace of the failure could be used
to look at the XA flows between MQ and the resource manager. MQ has allocated
an RMId of 2222 to this resource manager. This will be useful when isolating
the flows associated with the resource manager concerned. If the error occurs
on an xa_commit or xa_rollback request, the queue manager will not attempt to
redeliver the commit or rollback instruction for this transaction, until after
the queue manager has been restarted. The transaction indoubt is identified by
the following XID of X'<insert three>'. If you think that the error lies within
the queue manager, contact your IBM support center. Do not discard any
information describing the problem until after the problem has been resolved.

Have you tried searching for the Probe Id or the AMQ7605 on the IBM Support Search web site?
_________________
Yes, I am an agent of Satan but my duties are largely ceremonial.
Back to top
View user's profile Send private message
sjensen
PostPosted: Mon Dec 06, 2004 3:05 am    Post subject: Reply with quote

Centurion

Joined: 18 Dec 2003
Posts: 134
Location: London
Hi,

How does the XA part of the qm.ini file look?

Can you connect to the DB using sqlplus?

Do you have the loadxa test program and if so does that work?

Good luck

Stefan
Back to top
View user's profile Send private message
fjcarretero
PostPosted: Wed Dec 08, 2004 6:27 am    Post subject: Reply with quote

Voyager

Joined: 13 Oct 2003
Posts: 88
Thank you very much for all the responses.

Finally it turned out to be a problem with some oracle libs.

Thanks
Cheers
Felipe
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 » IBM MQ Java / JMS » QM as transaction coordinator
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.