|
| I am using Biztalk 2000/2002. I have created a custom preprocessor that talks
to the SQL database. I am using MSMQ Receive function that is configured
with the preprocessor.
Normally if there is a failure in the preprocessing component, messages are
rolled back to the MSMQ queue.
The problem I am facing is, messages are commited and rolled back to the
Queue in batches and proprocessing component processes one message at a time.
As I have observed, once all the messages in the batch( Batch size varies
from time to time) are preprocessed, they are written to the work queue.
So, I want to have the pre-processing component to be transactional and
enlist in the root transaction started by the Server.
I have tried to install the component in COM+ (Transaction- DISABLED) and it
works normally (Ofcourse with the above issue). If I change its TRANSACTION
attribute to (SUPPORTS), the messages get stuck in the Work Queue. No error
whatsoever and I feel the messages are not commited to the work queue.
Can any of the Biztalk Gurus help me on this.
Thanks in Advance.
|
|