MQSeries.net :: View topic - Pending Transaction Issue In Message Broker

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Pending Transaction Issue In Message Broker

Pending Transaction Issue In Message Broker

« View previous topic :: View next topic »

Author

Message

busy_chap

Posted: Fri Nov 07, 2008 8:25 am Post subject: Pending Transaction Issue In Message Broker

Acolyte

Joined: 18 May 2006
Posts: 69

Hello guys,
I am performing some tests on a flow and I see this error :
Transaction will be committed, but a pending automatic transaction exists

My flow writes the status to a database table.
I have checked the properties of all the compute nodes and see that it is set to 'commit'

Can anybody help me how to resolve this?

elvis_gn

Posted: Fri Nov 07, 2008 9:11 am Post subject:

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi busy_chap,

Problem is not with the flow...who else is writing status to the database table ? Some other flow/app has not committed its transaction yet and hence you are asked to wait.

Regards.

busy_chap

Posted: Fri Nov 07, 2008 9:39 am Post subject:

Acolyte

Joined: 18 May 2006
Posts: 69

Thanks for your response elvis_gn.

You are absolutely right. There are few other subflows that are writing to the database which had a 'commit' in the node. I changed that to 'Automatic' and it worked.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Pending Transaction Issue In Message Broker

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