The operation is not valid for the state of the transaction

Question

I have a TransactionScope() block. It always gets stuck in an insert statement. It appears in the Activity Monitor as a Blocking Task, so it blocks the SQL server, and after the timeout, I get this error:

The operation is not valid for the state of the transaction.

What’s going wrong?

const TransactionScopeOption opt = new TransactionScopeOption();
TimeSpan span = new TimeSpan(0, 0, 1, 30);

try
{
    using (TransactionScope scope01 = new TransactionScope(opt, span))
    {
        using (var sqlcon = new SqlConnection(sSqlCon))
        {
            //select,insert , update statements
        }
    }
}
catch (Exception ex)
{
}

Do you have a full stracktrace and an inner exception? – ken2k Nov 18 '13 at 15:56 — ken2k, Nov 18 '13 at 15:56
I have only an inner exception – Bill Brown Nov 19 '13 at 06:06 — Bill Brown, Nov 19 '13 at 06:06

score 2 · Answer 1 · answered Dec 17 '13 at 09:04

It probably means it aborted. Did you call transaction complete within transaction bracket?

try
{
    using (TransactionScope scope01 = new TransactionScope(opt, span))
    {
        using (var sqlcon = new SqlConnection(sSqlCon))
        {
            //select,insert , update statements
        }

        scope01.Complete();
    }
}

If it doesn't call the Complete, it will automatically rollback.

score 0 · Answer 2 · answered May 16 '20 at 19:19

0

The transaction might have been timed out. check the maching.config for the default time out

<configuration> 
  <system.transactions>
    <machinesettings maxtimeout="00:30:00" />
  </system.transactions>
</configuration>

answered May 16 '20 at 19:19

Chinthaka Fernando

744
8
12

The operation is not valid for the state of the transaction

2 Answers2

Linked