SQL Port: using of the ROLLBACK

Hi,

When I tried to use

BEGIN TRAN MAIN
....
ROLLBACK TRAN MAIN

inside of the SP which is started by BizTAlk SQL port,
I've got couple events:

Event Type: Warning
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5740
Date: 11/28/2006
Time: 4:21:07 PM
User: N/A
Computer: CORPBTS1
Description:
The adapter "SQL" raised an error message. Details "HRESULT="0x80004005" Description="Cannot roll back MAIN. No transaction or savepoint of that name was found."
".

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

AND then the second event

Event Type: Warning
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5743
Date: 11/28/2006
Time: 4:21:07 PM
User: N/A
Computer: CORPBTS1
Description:
The adapter failed to transmit message going to send port "SQL://CORPNT5/Prod/". It will be retransmitted after the retry interval specified for this Send Port. Details:"HRESULT="0x80004005" Description="Cannot roll back MAIN. No transaction or savepoint of that name was found."
".

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


When I've changed to the:

BEGIN TRAN MAIN
....
ROLLBACK WORK

I've got the different events


Event Type: Warning
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5740
Date: 11/28/2006
Time: 4:16:09 PM
User: N/A
Computer: CORPBTS1
Description:
The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14" Description="Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction."
".

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

AND then the second event

Event Type: Warning
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5743
Date: 11/28/2006
Time: 4:16:09 PM
User: N/A
Computer: CORPBTS1
Description:
The adapter failed to transmit message going to send port "SQL://CORPNT5/Prod/". It will be retransmitted after the retry interval specified for this Send Port. Details:"HRESULT="0x80040e14" Description="Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction."
".

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


As I can understand the SQL Port create the wrapping transaction and...
in result I cannot properly use the ROLLBACK feature.

Or there is something different?

Have any ideas??


Thanks for help!


Leonid Ganeline
BizTalk Solution Developer
===========================
http://geekswithblogs.com/leonidganeline
================================


.

Relevant Pages

  • Re: Who Will Cheney Shoot Next?
    ... House GOP Leaders Line Up Against UAE Port Deal ... WASHINGTON - House Speaker Dennis Hastert and newly-minted House ... Bush administration-approved transaction that permits shifting control ... Security Committee, said he was urging President Bush to delay approval ...
    (rec.sport.golf)
  • Re: Help, SQL adapter deadlocked!!!
    ... The SQL port always creates the transaction across the called stored ... adapter is Serializable. ...
    (microsoft.public.biztalk.general)
  • Re: Handling locked db tables...
    ... When choosing a port the table is read and the first available ... This is normal database locking behavior. ... roll back the transaction. ...
    (comp.lang.python)
  • Re: Information about resuming a Biztalk transaction when an event occ
    ... You need to read about correlation in BizTalk. ... If you use the request-response port to send message to appproval then the ... just end the transaction without doing ...
    (microsoft.public.biztalk.general)
  • Reference count issue with uart_close() on 2.6.16-2.6.20
    ... After that the serial port is no longer usable no matter what. ... Please find my kernel config and dmesg output below. ... # ACPI Support ... # PCI Hotplug Support ...
    (Linux-Kernel)