|
Home > Archive > BizTalk Server > February 2004 > Error RFSQL adaptader Distributed Transaction
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error RFSQL adaptader Distributed Transaction
|
|
| Andres Felipe Arguello 2004-02-08, 8:39 am |
| I have a receive funcion SQL job executing a stored procedure, and works
fine, but qhen another transaction is running in the SQL Server the RFSQL
send me a error message a dont execute the stored procedure until the
another transaction commit or rollback.
The error Message is:
A worker thread reported a failure: Transaction manager has canceled the
distributed transaction.
The error code is shown in the data area below.
The operation was: ISQLWorker->Execute
The worker thread was working on:
Job Name: SELECT_COLAS_OUT
SQL Script: Exec [SP_SELECT_COLAS_OUT]
This SP is not under a distributed transaction, i think is problem of the
RFSQL.
Maybe the connection OLE DB has the fault but the system try to insert in
the actual tranasacction.
If someone has the same problem or the solution please response
| |
| Shaheer Abubucker 2004-02-08, 8:39 am |
| Hello Felipe,
Is the other transaction accessing the same tables that the stored proc
that RFSQL is using is accessing? If so, it seems that the other
transaction has locks on this table and this stored proc cannot execute
until that transaction is done and the locks are released. This is
expected behavior under these circumstances.
Thanks,
Shaheer Abubucker
Microsoft Biztalk Server Team
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
--------------------
| I have a receive funcion SQL job executing a stored procedure, and works
| fine, but qhen another transaction is running in the SQL Server the RFSQL
| send me a error message a dont execute the stored procedure until the
| another transaction commit or rollback.
| The error Message is:
| A worker thread reported a failure: Transaction manager has canceled the
| distributed transaction.
|
| The error code is shown in the data area below.
|
| The operation was: ISQLWorker->Execute
|
| The worker thread was working on:
|
| Job Name: SELECT_COLAS_OUT
|
| SQL Script: Exec [SP_SELECT_COLAS_OUT]
|
| This SP is not under a distributed transaction, i think is problem of the
| RFSQL.
|
| Maybe the connection OLE DB has the fault but the system try to insert in
| the actual tranasacction.
|
| If someone has the same problem or the solution please response
|
|
|
|
|
|
|
|