transaction abort error

Question

Dear team

I am facing random transaction aborted issue in transaction scope, some times it works and some times throws an exception.
i am facing this issue only on VM environment with Windows server 2012 R2 and SQL 2014 standard version
is that the culprit ?

here is my code

    option.IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted;

    option.Timeout = TimeSpan.FromMinutes(5);

    using (_objTransactionScope = new TransactionScope(TransactionScopeOption.Required, option))
    {
    //..Open Connection
    //..Process the Document
    //..Update Additional information in Table2 about document(Delete/Insert)
    //..Update Location Information in Table3 about document(Delete/Insert)
    //..Delete the Document in Table4 in Differant Database on Differant Server(WCF Service)
    //..Update the Checksum of the Document and Metadata in Table1
    //..Delete Lock Entry From Table5
    //..Commit Transaction Scope
    //..Close Connection
    }

Please suggest

Thanks
Prasad

Answer 1

Please avoid double posts: https://learn.microsoft.com/en-us/answers/questions/626968/transaction-abort-in-transaction-scope.html

here is my code

No, it's not really, I see only some comments.