MQSeries.net :: View topic

rahoor · Posted: Fri Mar 09, 2007 10:20 am Post subject:

Greetings;
A queue manager serving a broker reported XA issues.

I am getting an AMQ7605 with Probe ID TM051000 in a system that uses oracle for XA manager. There were reportedly Oracle issues at the same time. What is a return code -3 and does this show that the root cause was on the XA manager side?

qm.ini thread control is on:
XAResourceManager:
Name=OracleDB_ISSICK
SwitchFile=/opt/IBM/mqsi/6.0/merant/lib/UKor8dtc20.so
XAOpenString=<something>
XACloseString=
ThreadOfControl=THREAD

thanks in advance.

+-----------------------------------------------------------------------------+
| |
| WebSphere MQ First Failure Symptom Report |
| ========================================= |
| |
| Date/Time :- Thursday March 08 13:00:43 EST 2007 |
| Host Name :- addbi02 (AIX 5.2) |
| PIDS :- 5724B4101 |
| LVLS :- 530.13 CSD13 |
| Product Long Name :- WebSphere MQ for AIX |
| Vendor :- IBM |
| Probe Id :- TM051000 |
| Application Name :- MQM |
| Component :- tmiPerformPrepare |
| Build Date :- Dec 5 2006 |
| CMVC level :- p530-13-L061205 |
| Build Type :- IKAP - (Production) |
| UserID :- 00000203 (adaixbr) |
| Program Name :- amqzlaa0_nd |
| Process :- 00704526 |
| Thread :- 00027957 |
| QueueManager :- ADDPD05 |
| Major Errorcode :- trcE_UNEXPECTED_RM_ERROR |
| Minor Errorcode :- OK |
| Probe Type :- MSGAMQ7605 |
| Probe Severity :- 2 |
| Probe Description :- AMQ7605: The XA resource manager OracleDB_ISSICK has |
| returned an unexpected return code -3, when called for xa_prepare. |
| FDCSequenceNumber :- 0 |
| Arith1 :- 4294967293 fffffffd |
| Arith2 :- 1 1 |
| Comment1 :- OracleDB_ISSICK |
| Comment2 :- xa_prepare |
| Comment3 :- |
| 004D514D0000000F0000000445D50AC5203D63654244315044303500000001 |
| |
+-----------------------------------------------------------------------------+

-------------------------------------------------------------------------------
03/08/07 13:00:43
AMQ7605: The XA resource manager OracleDB_ISSICK has returned an unexpected
return code -3, when called for xa_prepare.

EXPLANATION:
WebSphere MQ received an unexpected return code when calling XA resource
manager OracleDB_ISSICK at its xa_prepare 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 1 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'004D514D0000000F0000000445D50AC5203D63654244315044303500000001'. 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.