Live Scoring for Tournament Golf

* The Prestige at PGA WEST *

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

The error occurred in C:\Inetpub\wwwroot\Clients\golfstatresults.com\www\common\player_round_summary.cfm: line 7
Called from C:\Inetpub\wwwroot\Clients\golfstatresults.com\www\public\leaderboards\player\detail.cfm: line 55
Called from C:\Inetpub\wwwroot\Clients\golfstatresults.com\www\common\player_round_summary.cfm: line 7
Called from C:\Inetpub\wwwroot\Clients\golfstatresults.com\www\public\leaderboards\player\detail.cfm: line 55

5 :    <cfprocresult name="PLAYER">
6 :    <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="tournament_id" value="#tournament_id#" null="No">
7 :    <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="player_id" value="#player_id#" null="No">
8 : </cfstoredproc>
9 : <cfquery name="ROUND" datasource="#dsn#" username=#username# password=#password#>

SQL	{call golfstat1.dbo.PLAYER_ROUND_SUMMARY( (param 1) , (param 2) )}
DATASOURCE	golfstat1
VENDORERRORCODE	1205
SQLSTATE	40001

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	ColdFusion
Remote Address	69.63.138.39
Referrer
Date/Time	16-Oct-07 04:35 PM

Stack Trace

at cfplayer_round_summary2ecfm351615638.runPage(C:\Inetpub\wwwroot\Clients\golfstatresults.com\www\common\player_round_summary.cfm:7) at cfdetail2ecfm1689961078.runPage(C:\Inetpub\wwwroot\Clients\golfstatresults.com\www\public\leaderboards\player\detail.cfm:55) at cfplayer_round_summary2ecfm351615638.runPage(C:\Inetpub\wwwroot\Clients\golfstatresults.com\www\common\player_round_summary.cfm:7) at cfdetail2ecfm1689961078.runPage(C:\Inetpub\wwwroot\Clients\golfstatresults.com\www\public\leaderboards\player\detail.cfm:55)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 126) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the 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.TDSRPCRequest.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.getRowSets(Executive.java:360)
	at coldfusion.sql.Executive.executeCall(Executive.java:600)
	at coldfusion.sql.Executive.executeCall(Executive.java:531)
	at coldfusion.sql.Executive.executeCall(Executive.java:491)
	at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:320)
	at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:193)
	at cfplayer_round_summary2ecfm351615638.runPage(C:\Inetpub\wwwroot\Clients\golfstatresults.com\www\common\player_round_summary.cfm:7)
	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 cfdetail2ecfm1689961078.runPage(C:\Inetpub\wwwroot\Clients\golfstatresults.com\www\public\leaderboards\player\detail.cfm:55)
	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:209)
	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)