Error 8525. Distributed transaction completed. Either enlist this se

[VB400]

I'm getting the message:

-2147217900 Distributed transaction completed. Either
enlist this session in a new transaction or the NULL
transaction.

I have one component running in COM+ which is defined
as "Requires Transaction".

First call I make to the component, it works without a
problem.

Subsequent calls receive the above message.

This is driving me nuts! Please help if you can.

Thanks in advance!


Tarek

 

[acsian]

Hi,

I encountered this error and its driving me nuts. I usually encounter this when 2-3 pc's are calling the same component.

I tried to process lesser data by modifying the where clause in the SQL statement and it doesn't give any errors. The recordset.Open command causes this error on a loop. When the number of PC's using this component increases even if there's less data to process in a loop, I think the error will occur again. It's somewhat related to data size. I think the Com+ wants us to create a new transaction since it can't handle the large data or transaction it is processing.

Then after playing with the code, I get a BOF,EOF error while creating the object in the client. I reviewed the code but there's no recordset that causes this. It only happens if there are 2 or more pc's running the component.

If I didnt use the MTS/COm+, I didnt experienced any problems,except that its a little slow since it is being processed in the client.

 

[PieterM]

Hi


I get this error (8525) when I try to commit a distributed transaction. The transaction is executed by a proc calling a remote proc through a linked server. Both servers run SQL 2k enterprise and are contained in the same cluster. I tried SQL server 2k sp3a as a solution but no luck. The amount of data is insignificant.