| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Urgent: XA transaction problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| unilog |
 Posted: Thu Aug 22, 2002 7:31 am Post subject: Urgent: XA transaction problem |
 |
|
Novice
Joined: 29 Apr 2002
Posts: 17
Location: Paris, France
|
Hello,
I'm trying to set up the XA transaction with WMQI and encountered some problems. I'm using WMQI 2.1, MQSeries 5.2 on AIX V4.3.3 and Oracle 8.1.7. As my flows call several stored procedures, I absolutly need an XA transaction.
I have configured my qm.ini file, created the commutation file and gave rights to my oracle DB. However, I cannot initialise the transaction. When I'm starting the queue manager, I'm always getting in the MQ/WMQI log, an error message saying that Oracle is answering to the XA open, with an XAER_RMER or XAER_RMFAIL, and the transaction cannot be coordinated.
Do you think it is an Oracle, or MQ error?
Can anybody send me an exemple of its qm.ini configuration for XA transaction?
I follow the instructions of the WMQI/Oracle guide. What could be the possible error I made with Oracle?
I do not get any Oracle error back.
Thanks a lot for your help, I really don't know how to solve my problem.
Alex |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Aug 22, 2002 7:47 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Alex,
Are you able to access Oracle db from queue manager machine?
XAER_RMFAIL - resource manager unavailable
XAER_RMERR - A resource manager error occurred in the transaction branch.
Chapter 12 in MQSeries System Administration Guide explains how to Configure Oracle for 2-phase commit with MQ. They also have an example of qm.ini file.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| unilog |
| Posted: Fri Aug 23, 2002 12:15 am Post subject: |
|
|
Novice
Joined: 29 Apr 2002
Posts: 17
Location: Paris, France
|
Hi Kiran,
Thanks for your quick reply. When I set up my XA transaction, I used MQSeries System Administration Guide and followed all the instructions. First I had several .trc Oracle errors, that I now do not have anymore. I guess, this means that my XA OpenString is now correct. However I still have MQ/WMQI errors.
I suceed to connect to my remote DB from the queue Manager machine using SQL+.
I will try to do some other tests. Have you any advice about XA test or control on MQ ?
Thanks for your help,
Alex
PS: Here is a copy of my qm.ini file. Does it look correct?
MQS521 is the TNS/SID of my DB.
XAResourceManager:
Name=Oracle8_MQS521
SwitchFile=/usr/opt/wmqi/merant/lib/UKor8dtc16.so
XAOpenString=Oracle_XA+SQLNET=MQS521+ACC=P/eai_dev/eai_dev+sesTm=10+LogDir=/home/mqseries/alex
XACloseString=
ThreadOfControl=THREAD |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Aug 23, 2002 4:32 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Alex,
I only have experience in setting up DB2 for 2-phase commit with MQ.
It is a good sign that you don't get any error while starting queue manager. What exact error do you get in MQSI?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| unilog |
| Posted: Tue Aug 27, 2002 6:43 am Post subject: |
|
|
Novice
Joined: 29 Apr 2002
Posts: 17
Location: Paris, France
|
Hi KIran,
Using the mqsireadlog command of WMQI, I get the following MQ Series error:
Code: 2057
Text (translated from French): When the broker tried to initiate the coordinated transaction, the MQbegin operation failed, and the message flow is not anymore using the coordinated transaction.
Checking the MQ logs in var/mqm/qmgrs/[Name of the QM]/errors,
I get the following error (translated from french too):
The XA resource manager '[Name of the RM]' indicated, it is not available by replying XAER_RMERR following an xa_open request or XAER_RMFAIL, if it was for another request. This generally means that the RM stops.
I do not get any error code.
In the var/mqm/errors directory, I do not get any .FDC files.
I do not know if MQ succeeds to connect to Oracle, or if the problem occurs before.
Thanks for your help,
Alex |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Aug 27, 2002 2:58 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Alex,
After you get this error you could use dspmqtrn command to display in-doubt transactions. Do you see errors logged into oracle log files? If the transaction has started successfully that means MQBEGIN call was successful.
I think, you should report this problem to IBM.
FYI. There is an article in Xephon's MQUpdate journal (May, June 2002) on "Setting up Global Transactions with MQSeries and Oracle". The info in this article might help you.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
