Server Error in '/' Application.

Unable to get job list: Transaction (Process ID 122) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. SQL: SELECT post_id, host, job_id, company, url, title, created, city, state, postal, country, substring(description,1,500) as Description, salary, jobtype, category, start_date, end_date, cust_id, fee, priority, archive from tbl_job where host <> 'insiderjobboard' AND (start_date - 1 < GETDATE()) AND (end_date + 1 > GETDATE()) AND ( jobtype like '%Equipment, Logistics and Purchasing%') AND (city LIKE '%') AND (archive = 'False')

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.Exception: Unable to get job list: Transaction (Process ID 122) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. SQL: SELECT post_id, host, job_id, company, url, title, created, city, state, postal, country, substring(description,1,500) as Description, salary, jobtype, category, start_date, end_date, cust_id, fee, priority, archive from tbl_job where host <> 'insiderjobboard' AND (start_date - 1 < GETDATE()) AND (end_date + 1 > GETDATE()) AND ( jobtype like '%Equipment, Logistics and Purchasing%') AND (city LIKE '%') AND (archive = 'False')

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[Exception: Unable to get job list: Transaction (Process ID 122) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. SQL: SELECT post_id, host, job_id, company, url, title, created, city, state, postal, country, substring(description,1,500) as Description, salary, jobtype, category, start_date, end_date, cust_id, fee, priority, archive from tbl_job where host <> 'insiderjobboard' AND (start_date - 1 < GETDATE()) AND (end_date + 1 > GETDATE()) AND ( jobtype like '%Equipment, Logistics and Purchasing%') AND (city LIKE '%') AND (archive = 'False') ]
   IJB_Data.IJBData.tbl.job.getJobList(String keys, String location, String title, String category) +2646
   InsiderJobBoard.results.loadData() +155
   InsiderJobBoard.results.Page_Load(Object sender, EventArgs e) +24
   System.Web.UI.Control.OnLoad(EventArgs e) +95
   System.Web.UI.Control.LoadRecursive() +59
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +678


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