Wednesday, March 7, 2012

error 3926 , server failed to resume transaction

In a high load asp.net environment, I am getting an error.

The transation active in this session has been committed or aborted by another session.

Here is the code , I am getting error.

1object returnObject =null;2 SqlTransaction sqlTrans =null;3try4 {5//Getting new SqlConnection6 comm.Connection = GetConnection();7//Opening connection8 OpenConn(comm.Connection);9//beginning transaction10 sqlTrans = comm.Connection.BeginTransaction( IsolationLevel.ReadCommitted );11//setting transaction to SqlCommand object12 comm.Transaction = sqlTrans;13//executing operation14 returnObject = comm.ExecuteScalar();15//trying to commit.16 sqlTrans.Commit();171819 }20catch (SqlException sex)21 {22if (sqlTrans !=null)23 {24 sqlTrans.Rollback();25 }26 }27finally28 {29 comm.Connection.Close();30 }
Could you please explain , am I doing smthg wrong ?

Check out this link: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2041937&SiteID=17

Good luck.

|||

Hi CS4Ever ,

Thanks for the reply, but as far as I understood , Thona just submitted the situation , not a solution and the 3rd reply belongs to me :)

What could I possibly do ? Submit a bug to Microsoft ?

Thanks in advance.

|||

Still no answers ?

No comments:

Post a Comment