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

www.punjabtribune.com



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






Transaction (Process ID 284) 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 284) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Source Error:






Line 210:        If OPENCN(JMD) Then
Line 211:            SQLCM = New SqlCommand("UPDATE OXARTICLE SET HITS=HITS+1 WHERE ARTICLECODE=" & NEWSCODE.ToString, JMD)
Line 212:            SQLCM.ExecuteNonQuery()
Line 213:            CLOSECN(JMD)
Line 214:        End If







Source File: G:PleskVhostspunjabtribune.comhttpdocsnewsmainpage.aspx.vb    Line: 212

Stack Trace:






[SqlException (0x80131904): Transaction (Process ID 284) 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) +109
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +57
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +207
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2443
   System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +191
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +256
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +132
   _default.COUNTHITS() in G:PleskVhostspunjabtribune.comhttpdocsnewsmainpage.aspx.vb:212
   _default.GETDATA() in G:PleskVhostspunjabtribune.comhttpdocsnewsmainpage.aspx.vb:185
   _default.Page_Load(Object sender, EventArgs e) in G:PleskVhostspunjabtribune.comhttpdocsnewsmainpage.aspx.vb:29
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2602









Version Information: Microsoft .NET Framework Version:2.0.50727.8810; ASP.NET Version:2.0.50727.8762





Source link

Latest Govt Job & Exam Updates:

View Full List ...