ORA-02074: cannot ROLLBACK in a distributed transaction

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › ORA-02074: cannot ROLLBACK in a distributed transaction

Viewing 1 reply thread
  • Author
    Posts
    • September 15, 2008 at 11:48 AM #20720
      community-content

        I am calling a Oracle SP using WCF-Custom adapter and receiving following errors:

        • ORA-02074: cannot ROLLBACK in a distributed transaction

        • ORA-02074: cannot SET SAVEPOINT in a distributed transaction

          •  

          I can’t modify code on Oracle side as it is 3rd party SP.
          I just call it supplying 1 parameter. SP logic is invisible to me.

        Does anybody know if there is any solution to this? 

         

        oracle version = 10g ; biztalk version = 2006R2

      • September 15, 2008 at 12:10 PM #20721
        community-content

          Have you verified that the issue is specifically with the WCF Oracle adapter calling the SP?  For example, can you call the SP successfully outside of BizTalk?  A good test would be to write a small C# app to call the SP, and run it from the BizTalk server.  Can you access Oracle at all using the WCF adapter?  For example, try calling another SP or just selecting some data from a table.

          • September 15, 2008 at 2:06 PM #20723
            community-content

               

              Yes, I can call the SP outside of Biztalk as well as I am able to call other SP’s the same way. it’s only this SP giving issues and that too the code of This SP is not visible to me… So can’t check the what’s in SP.

              I suspect the issue is due to some SAVEPOINT created in SP and some exception occuring during execution.

        • Author
          Posts
        Viewing 1 reply thread
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.