Posted: Thu Nov 23, 2006 3:30 pm Post subject: File Extender question
Centurion
Joined: 03 Oct 2005 Posts: 146
Hi All,
what are the consequences, if exceptions are not handle in message flows using File Extender?.
Here is the situation :
FileInput node reads Input file record by record until Endoffile and each records updated in database table and also store in a queue as a XML message.
If any exceptions occurs while reading the record, the Database updates and message in Queue should be rolled back.This is working perfect when exception are not handle (catch or failure are not handle).
But when I handle the exception the Databse updates and Queue is not rolled back.
For eg :
If I have 5 records in input file and Exception occurs in 3rd record and exception is handled then 2 rows and 2 messages are not rolled back.
Also I need to send an notification when exception occurs.
It has everything to do with basic error handling in WMB.
It is the *Input node that causes rollback to occur. If you wire a CATCH terminal on an *Input node, then you are saying that you will handle all error processing, including rollback.
I believe there's a devWorks article by Tim Dunn that goes over this.
Wire a Throw node to the end of your catch branch, and do not connect the failure terminal. _________________ I am *not* the model of the modern major general.
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