distributed transactions throws error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

distributed transactions throws error

Hi i hav a linked server on SQL SERVER-2000 for Oracle using Microsoft OLEDB provider for oracle I created a SP that
updates the table in Oracle server
and inserts record into table on Sql server
this SP is added as a step in a job
and i scheduled the job every 30 minutes..
when i check the job history it shows me
It executed fine for some 6 times then it failed at this sp step giving error: Executed as user: <USER NAME>. The operation could not be performed because the OLE DB provider ‘MSDAORA’ was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391) OLE DB error trace [OLE/DB Provider ‘MSDAORA’ ITransactionJoin::JoinTransaction returned 0x8000d048]. [SQLSTATE 01000] (Error 7300). The step failed.
this job is not failing everytime but some times I know it throws that error when the provider does not support distributed transactions..
but this step some times fails and sometimes completes sucessfully is there a case that it supports distributed transaction sometimes and not sometimes pls correct me if i am wrong and
help me out to solve this error asap. Thanks in advance……………
KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;280106 and search on the forums about the error, as this was discussed here many times. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>