MQSeries.net :: View topic - XA-Transaction Problem (commit)

sommos · Posted: Fri Jul 08, 2005 5:22 am Post subject: XA-Transaction Problem (commit)

Hi!

I got the following Error-Message in my Application:

MQJE001: Completion Code 2, Reason 2195 (Unexpected Error)
MQJE001: Completion Code 2, Reason 2009

SunOS da3XX011 5.9 sun4u sparc SUNW,Sun-Fire-V440System = SunOS
===========================================================

In the MQ-Error- log I found this Message:

AMQ7605: The XA resource manager Oracle_AEFMQM1 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 Oracle_AEFMQM1 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'004D514D0000000E0000000442C50ADC200022014145464D514D00000001'. 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.

===========================================================

Configuration qm.ini-File

XAResourceManager:
Name=Oracle_AEFMQM1
SwitchFile=/export/home/AEFHOME/mqmaef/mqm/jdbcora
XAOpenString=oracle_xa+Acc=p/user/passwd+sestm=30+LogDir=/tmp/mq/ora.log+SQLNET=aef.da3XX01+threads=TRUE+DbgFl=0x15
XACloseString=
ThreadOfControl=THREAD

===========================================================

ora.log-File

ORACLE XA: Version 9.2.0.1.0. RM name = 'Oracle_XA'.

132717.16807.59.1:
xaoopen: xa_info=oracle_xa+Acc=p/user/passwd+sestm=30+LogDir=/tmp/mq/ora.log+SQLNET=aef.da3XX01+threads=TRUE+DbgFl=0x15,rmid=1,flags=0x0

132717.16807.59.1:
xaolgn_help: version#: 153093376 banner: Oracle9i Release 9.2.0.5.0 - 64bit Production
JServer Release 9.2.0.5.0 - Production

132717.16807.59.1:
xaolgn: sqlxrc/sqlxss completed

132717.16807.59.1:
xaoopen: xaolgn completed

132717.16807.59.1:
xaoopen: return 0

133217.16807.59.1:
xaoprepare: xid=0x4d514d-42c50adc200021014145464d514d-00000001, rmid=1, flags=0x0

133217.16807.59.1:
OCITransPrepare: Attempting

133217.16807.59.1:
ORA-24788: cannot switch to specified transaction (server type)
133217.16807.59.1:
xaoprepare: rtn -3

133217.16807.59.1:
xaorollback: xid=0x4d514d-42c50adc200021014145464d514d-00000001, rmid=1, flags=0x0

133217.16807.59.1:
OCITransRollback: Attempting

133217.16807.59.1:
OCITransRollback return code: -1

133217.16807.59.1:
ORA-24788: cannot switch to specified transaction (server type)

133217.16807.59.1:
xaorollback: rtn -3

133227.16807.59.1:
xaoclose: xa_info=, rmid=1, flags=0x0

133227.16807.59.1:
OCIServerDetach: Attempting

133227.16807.59.1:
OCIServerDetach: Succeeded

133227.16807.59.1:
xaoclose: rtn 0

ORACLE XA: Version 9.2.0.1.0. RM name = 'Oracle_XA'.

155745.16807.60.1:
xaolog: Could not open file in directory /tmp/mq/ora.log

ORACLE XA: Version 9.2.0.1.0. RM name = 'Oracle_XA'.

155745.16807.60.1:
xaoopen: xa_info=oracle_xa+Acc=p/user/passwd+sestm=30+LogDir=/tmp/mq/ora.log+SQLNET=aef.da3XX01+threads=TRUE+DbgFl=0x15,rmid=1,flags=0x0

155745.16807.60.1:
xaolgn_help: version#: 153093376 banner: Oracle9i Release 9.2.0.5.0 - 64bit Production
JServer Release 9.2.0.5.0 - Production

155745.16807.60.1:
xaolgn: sqlxrc/sqlxss completed

155745.16807.60.1:
xaoopen: xaolgn completed

155745.16807.60.1:
xaoopen: return 0

160246.16807.60.1:
xaoprepare: xid=0x4d514d-42c50adc200022014145464d514d-00000001, rmid=1, flags=0x0

160246.16807.60.1:
OCITransPrepare: Attempting

160246.16807.60.1:
ORA-24788: cannot switch to specified transaction (server type)

160246.16807.60.1:
xaoprepare: rtn -3

160246.16807.60.1:
xaorollback: xid=0x4d514d-42c50adc200022014145464d514d-00000001, rmid=1, flags=0x0

160246.16807.60.1:
OCITransRollback: Attempting

160246.16807.60.1:
OCITransRollback return code: -1

160246.16807.60.1:
ORA-24788: cannot switch to specified transaction (server type)

160246.16807.60.1:
xaorollback: rtn -3

160256.16807.60.1:
xaoclose: xa_info=, rmid=1, flags=0x0

160256.16807.60.1:
OCIServerDetach: Attempting

160256.16807.60.1:
OCIServerDetach: Succeeded

160256.16807.60.1:
xaoclose: rtn 0
=================================================================

What is the reason of this problem?

Thanks!