June 22, 2009 at 12:10 pm
I'm getting the dreaded
Executed as user: "user". The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a]. [SQLSTATE 01000] (Error 7300). The step failed.
This started after we upgraded our second server with Windows Sp2 and the latest hot fixes, etc. I've looked at the various articles regarding the MSDTC service, but this looks all OK. The reason why I don't think this is the issue also is because the problem is intermittent. For example, the job runs every 2 hours. My 8am run was all successful, but the 10am run, it failed. Even more odd, is that within the job itself, there are several steps. Each step runs stored procedure that does a distributed transaction, but it can go thru step 1 and 2 even and then fail on step 3 due to the error above. Right now, the only way I'm getting thru this is to comment out the "BEGIN TRAN and COMMIT"
Any help would be greatly appreciated. Thanks!
Environment:
Server 1
Win2000 Sp3 with Sql2000 Sp3/Sp3a (yeah I know. not my server.)
This is the server that the query runs from and calls the link server to Server 2.
Server 2
Win2003 Sp2 with Sql2000 Sp4
(This is the server that was recently patched to Sp2)
December 2, 2009 at 2:41 am
Hi,
I have exactly the same problem. Couldn't find any solution except this post...
Removing BEGIN/COMMIT/ROLLBACK TRAN really helps. But this is not a good solution 🙁
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply