Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    iSM Listener Transaction Management
Go
New
Search
Notify
Tools
Reply
  
iSM Listener Transaction Management
 Login/Join
 
Member
posted
Hello All,

I couldn't find any iSM documentation which has details about how to setup the PFlow to participate in a transaction.

I am using a File Listener with "Listener is Transaction Manager" set to TRUE. This listener is invoking a PFlow. In my PFlow I am using the three SQL Objects in the following sequence - one object to delete a record in Table B, another object to select a row from Table A, the last SQL object to insert a record in Table B. Table A and Table B are in MS SQL Server 2005 database.

What I would like to happen is if the insert object fails I would like to roll back the PFlow logic i.e. the delete should be rolled back. My understanding is that since the file listener is the transaction manager it rolls back the sql operations if it detects any failure in the PFlow.

I tested this logic by adding a typo in SQL and failed the insert sql statement. I noticed that the listener is comiting the delete operation and NOT rolling back.

1) Can the Channel/Listener automatically roll back transactions if a PFlow fails?
2) What are the PFlow objects that are allowed to participate in a transaction?
3) Do I need to set any other properties in the SQL object to participate in a transaction?


Thanks.

This message has been edited. Last edited by: AK,


iSM 616
iDM 7705
iDQC 802
WF 77
Windows 2008 Server
 
Posts: 29 | Registered: May 01, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    iSM Listener Transaction Management

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.