Server Error in '/' Application.

Transaction (Process ID 2698) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Transaction (Process ID 2698) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Source Error:


Line 229:            Dim RN As New Random
Line 230:            SQLCM = New SqlCommand("UPDATE OXARTICLE SET HITS=HITS+" & RN.Next(1, 5).ToString() & " WHERE ARTICLECODE=" & NEWSCODE, CN2)
Line 231:            SQLCM.ExecuteNonQuery()
Line 232:            SQLCM.Dispose()
Line 233:            DR.Close()

Source File: G:\PleskVhosts\bainsfamily.com\punjabnewsline\news\details.aspx.vb    Line: 231

Stack Trace:


[SqlException (0x80131904): Transaction (Process ID 2698) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2586154
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6039978
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +297
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4477
   System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) +997
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +314
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +297
   article_details.GETHITS() in G:\PleskVhosts\bainsfamily.com\punjabnewsline\news\details.aspx.vb:231
   article_details.Page_Load(Object sender, EventArgs e) in G:\PleskVhosts\bainsfamily.com\punjabnewsline\news\details.aspx.vb:25
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0