Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 112) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Acne quistico en el pecho, Henry Ford Hospital, Detroit, MI: ...

Home

After Hours & Urgent Care

Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 112) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

The error occurred in F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\smt_breadcrumb_custom.cfm: line 24
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\smt_breadcrumb_qualified.cfm: line 2
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm: line 133
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm: line 6
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm: line 1
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\smt_breadcrumb_custom.cfm: line 24
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\smt_breadcrumb_qualified.cfm: line 2
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm: line 133
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm: line 6
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm: line 1

22 : 			SELECT	sectionname, makepublic, makepublicdate, expiredate, parentitemid, pagetemplate
23 : 			FROM	webpages
24 : 			WHERE	itemid = <cfqueryparam value="#currentnode#" cfsqltype="CF_SQL_INTEGER">
25 : 		</cfquery>		
26 : 		<cfif qNode.recordcount>

SQL	SELECT sectionname, makepublic, makepublicdate, expiredate, parentitemid, pagetemplate FROM webpages WHERE itemid = (param 1)
DATASOURCE	henryfordhealth3282958
VENDORERRORCODE	1205
SQLSTATE	40001

Please try the following:

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	Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)
Remote Address	207.71.199.149
Referrer
Date/Time	07-Apr-09 05:47 AM

Stack Trace (click to expand)

at cfsmt_breadcrumb_custom2ecfm1913395923.runPage(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\smt_breadcrumb_custom.cfm:24) at cfsmt_breadcrumb_qualified2ecfm2065500070.runPage(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\smt_breadcrumb_qualified.cfm:2) at cfbody2ecfm394757931._factor4(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm:133) at cfbody2ecfm394757931._factor6(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm:6) at cfbody2ecfm394757931.runPage(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm:1) at cfsmt_breadcrumb_custom2ecfm1913395923.runPage(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\smt_breadcrumb_custom.cfm:24) at cfsmt_breadcrumb_qualified2ecfm2065500070.runPage(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\smt_breadcrumb_qualified.cfm:2) at cfbody2ecfm394757931._factor4(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm:133) at cfbody2ecfm394757931._factor6(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm:6) at cfbody2ecfm394757931.runPage(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm:1)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 112) 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:230)
	at coldfusion.sql.QueryTable.populate(QueryTable.java:159)
	at coldfusion.sql.Executive.getRowSet(Executive.java:505)
	at coldfusion.sql.Executive.executeQuery(Executive.java:979)
	at coldfusion.sql.Executive.executeQuery(Executive.java:886)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
	at cfsmt_breadcrumb_custom2ecfm1913395923.runPage(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\smt_breadcrumb_custom.cfm:24)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:60)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:256)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1886)
	at cfsmt_breadcrumb_qualified2ecfm2065500070.runPage(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\smt_breadcrumb_qualified.cfm:2)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:60)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:256)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1886)
	at cfbody2ecfm394757931._factor4(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm:133)
	at cfbody2ecfm394757931._factor6(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm:6)
	at cfbody2ecfm394757931.runPage(F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:105)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at com.seefusion.Filter.doFilter(Filter.java:49)
	at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1494)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)