Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Your transaction (process ID #10) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
 
The error occurred in D:\InetPub\wwwroot\repages\web\agentpage.cfm: line 52
Called from D:\InetPub\wwwroot\repages\web\agentpage.cfm: line 1
Called from D:\InetPub\wwwroot\repages\TX\MaryBattaglia.cfm: line 8
Called from D:\InetPub\wwwroot\repages\web\agentpage.cfm: line 52
Called from D:\InetPub\wwwroot\repages\web\agentpage.cfm: line 1
Called from D:\InetPub\wwwroot\repages\TX\MaryBattaglia.cfm: line 8
 
50 : 	SELECT DISTINCT web, priority, natdirdate, avgscore
51 : 	FROM natdir
52 : 	WHERE (nqc = 'US001' or nqc = 'UK0001') and emailverify = 1 and natdirdate <= #CreateODBCDate(Now()- startdate)# and (email <> 'packet@buyersusa.com')
53 : 	ORDER by priority desc,natdirdate DESC
54 : </CFQUERY>
SQL    SELECT DISTINCT web, priority, natdirdate, avgscore FROM natdir WHERE (nqc = 'US001' or nqc = 'UK0001') and emailverify = 1 and natdirdate <= {d '2011-07-07'} and (email <> 'packet@buyersusa.com') ORDER by priority desc,natdirdate DESC
DATASOURCE   natdir
VENDORERRORCODE   1205
SQLSTATE   40001
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.107.179.244
Referrer  
Date/Time   11-Feb-12 11:00 AM
Stack Trace
at cfagentpage2ecfm272860271._factor16(D:\InetPub\wwwroot\repages\web\agentpage.cfm:52) at cfagentpage2ecfm272860271.runPage(D:\InetPub\wwwroot\repages\web\agentpage.cfm:1) at cfMaryBattaglia2ecfm879596129.runPage(D:\InetPub\wwwroot\repages\TX\MaryBattaglia.cfm:8) at cfagentpage2ecfm272860271._factor16(D:\InetPub\wwwroot\repages\web\agentpage.cfm:52) at cfagentpage2ecfm272860271.runPage(D:\InetPub\wwwroot\repages\web\agentpage.cfm:1) at cfMaryBattaglia2ecfm879596129.runPage(D:\InetPub\wwwroot\repages\TX\MaryBattaglia.cfm:8) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Your transaction (process ID #10) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
	at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.getRow(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplResultSet.fetchAtPosition(Unknown Source)
	at macromedia.jdbc.base.BaseImplResultSet.next(Unknown Source)
	at macromedia.jdbc.base.BaseResultSet.next(Unknown Source)
	at coldfusion.sql.QueryTable.populate(QueryTable.java:287)
	at coldfusion.sql.Executive.getRowSet(Executive.java:312)
	at coldfusion.sql.Executive.executeQuery(Executive.java:775)
	at coldfusion.sql.Executive.executeQuery(Executive.java:685)
	at coldfusion.sql.Executive.executeQuery(Executive.java:646)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
	at cfagentpage2ecfm272860271._factor16(D:\InetPub\wwwroot\repages\web\agentpage.cfm:52)
	at cfagentpage2ecfm272860271.runPage(D:\InetPub\wwwroot\repages\web\agentpage.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cfMaryBattaglia2ecfm879596129.runPage(D:\InetPub\wwwroot\repages\TX\MaryBattaglia.cfm:8)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
	at coldfusion.CfmServlet.service(CfmServlet.java:107)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)