| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| XA coordinated transaction problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| mrL |
 Posted: Wed Nov 26, 2008 9:12 am Post subject: XA coordinated transaction problem |
 |
|
Newbie
Joined: 26 Nov 2008
Posts: 2
Location: IBM
|
Hello all
Recently i faced a problem with coordinated transaction.
The flow is simple:
MQInput -> Compute -> MQOutput
I get a XML message, use 2 field that will be inserted into DB in compute node, and then propagate without any changes.
This flow is designed to test two-phase transaction.
WMB is version 6.1. WMQ 6.0 with fix-pac 5. Oracle 10g db in VMWare machine on the same computer.
I use DataDirect 5.3 driver.
So, the problem is I get an error:
[DataDirect][ODBC Oracle Wire Protocol driver]xa_open must be called before a connection is enlisted in a distributed transaction.
MQ XA settings are:
ORACLE_XA+SQLNET=INTEGRA+
HostName=192.168.20.2+PortNumber=1521+
Sid=INTEGRA+ACC=P/system/system+sestm=100+
threads=TRUE+DataSource=INTEGRA+DB=INTEGRA+K=2+
All documented scripts on Oracle side have been run and all needed permissions granted.
All transaction mode properties of nodes are set in Automatic.
I forgot to mention that all products runs on MS 2003 server.
Could anybody provide me with any suggestions?
Is it a problem of ODBC provider or lack of settings?
Thank you |
|
| Back to top |
|
 |
| mvic |
| Posted: Wed Nov 26, 2008 5:26 pm Post subject: Re: XA coordinated transaction problem |
|
|
Jedi
Joined: 09 Mar 2004
Posts: 2080
|
| mrL wrote: |
MQ XA settings are:
ORACLE_XA+SQLNET=INTEGRA+
HostName=192.168.20.2+PortNumber=1521+
Sid=INTEGRA+ACC=P/system/system+sestm=100+
threads=TRUE+DataSource=INTEGRA+DB=INTEGRA+K=2+ |
Is the xa_open string really split over multiple lines like that? I didn't think that was allowed.
Secondly, are there any errors appearing under /var/mqm/qmgrs/QMNAME/errors or /var/mqm/errors |
|
| Back to top |
|
|
| mrL |
| Posted: Wed Nov 26, 2008 11:54 pm Post subject: |
|
|
Newbie
Joined: 26 Nov 2008
Posts: 2
Location: IBM
|
Yes, of cause it is in one line, i just split it to make it visually.
No, no mq qmgr errors.
That is why i'm in stuck... |
|
| Back to top |
|
|
| jacky1982728 |
| Posted: Wed May 04, 2011 10:41 pm Post subject: |
|
|
Newbie
Joined: 17 Feb 2011
Posts: 4
|
| Try to check the transation properties of nodes that assosiated with the database such as DatabaseUpdate ,DataBaseInsert Database have been correctly set to 'yes' or 'commit' |
|
| 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
|
|
|
|
