Login | Join | Feedback
Serving Waldo County Maine

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 52) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 
The error occurred in \\vsweb\wwwroot\vslive\midcoast\waldo\news\include\querybizorgbriefs1.cfm: line 9
Called from \\vsweb\wwwroot\vslive\midcoast\waldo\news\include\bizorgbriefs.cfm: line 1
Called from \\vsweb\wwwroot\vslive\midcoast\waldo\news\include\bizorgbriefs.cfm: line 1
Called from \\vsweb\wwwroot\vslive\midcoast\waldo\Application.cfc: line 49
Called from \\vsweb\wwwroot\vslive\midcoast\waldo\news\include\querybizorgbriefs1.cfm: line 9
Called from \\vsweb\wwwroot\vslive\midcoast\waldo\news\include\bizorgbriefs.cfm: line 1
Called from \\vsweb\wwwroot\vslive\midcoast\waldo\news\include\bizorgbriefs.cfm: line 1
Called from \\vsweb\wwwroot\vslive\midcoast\waldo\Application.cfc: line 49
7 : WHERE sm.mediagroupid in (1,5) AND S.Active = 1  
8 : and sm.webstartdate <= #CreateODBCDateTime(Now())# and sm.webenddate >= #CreateODBCDateTime(Now())# 
9 : and storytypeid in (#storyTypeids#) and (s.display is NULL or s.display > 1) and sectionname <> 'Religion'
10 : group by s.storyid, headline, location,byline, inclet,incimg, sectionpage, s.compid, webstartdate, s.storytypeid
11 : Order By sm.webstartdate DESC, s.storyid DESC</CFQUERY>

SQL   SELECT distinct(S.StoryID) as storyid, S.headline, S.Location, S.ByLine, S.IncLet, S.IncImg, Sect.sectionpage, s.compid, sm.webstartdate, s.storytypeid FRom Stories S Inner Join storytomedia sm on s.StoryID = sm.StoryID Inner Join storytosection ss on S.storyid = ss.storyid inner join Sections Sect on Sect.sectionid = ss.sectionid WHERE sm.mediagroupid in (1,5) AND S.Active = 1 and sm.webstartdate <= {ts '2008-08-28 19:03:00'} and sm.webenddate >= {ts '2008-08-28 19:03:00'} and storytypeid in (4,5,6) and (s.display is NULL or s.display > 1) and sectionname <> 'Religion' group by s.storyid, headline, location,byline, inclet,incimg, sectionpage, s.compid, webstartdate, s.storytypeid Order By sm.webstartdate DESC, s.storyid DESC
DATASOURCE   vslive
VENDORERRORCODE   1205
SQLSTATE   40001
Resources:

Browser   ColdFusion
Remote Address   172.16.15.41
Referrer  
Date/Time   28-Aug-08 07:03 PM
Stack Trace
at cfquerybizorgbriefs12ecfm1351102216.runPage(\\vsweb\wwwroot\vslive\midcoast\waldo\news\include\querybizorgbriefs1.cfm:9) at cfbizorgbriefs2ecfm1476774719._factor10(\\vsweb\wwwroot\vslive\midcoast\waldo\news\include\bizorgbriefs.cfm:1) at cfbizorgbriefs2ecfm1476774719.runPage(\\vsweb\wwwroot\vslive\midcoast\waldo\news\include\bizorgbriefs.cfm:1) at cfApplication2ecfc1208215934$funcONREQUEST.runFunction(\\vsweb\wwwroot\vslive\midcoast\waldo\Application.cfc:49) at cfquerybizorgbriefs12ecfm1351102216.runPage(\\vsweb\wwwroot\vslive\midcoast\waldo\news\include\querybizorgbriefs1.cfm:9) at cfbizorgbriefs2ecfm1476774719._factor10(\\vsweb\wwwroot\vslive\midcoast\waldo\news\include\bizorgbriefs.cfm:1) at cfbizorgbriefs2ecfm1476774719.runPage(\\vsweb\wwwroot\vslive\midcoast\waldo\news\include\bizorgbriefs.cfm:1) at cfApplication2ecfc1208215934$funcONREQUEST.runFunction(\\vsweb\wwwroot\vslive\midcoast\waldo\Application.cfc:49)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 52) was deadlocked on lock | communication buffer 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.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.QueryTable.populate(QueryTable.java:216)
	at coldfusion.sql.Executive.getRowSet(Executive.java:311)
	at coldfusion.sql.Executive.executeQuery(Executive.java:753)
	at coldfusion.sql.Executive.executeQuery(Executive.java:675)
	at coldfusion.sql.Executive.executeQuery(Executive.java:636)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
	at cfquerybizorgbriefs12ecfm1351102216.runPage(\\vsweb\wwwroot\vslive\midcoast\waldo\news\include\querybizorgbriefs1.cfm:9)
	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 cfbizorgbriefs2ecfm1476774719._factor10(\\vsweb\wwwroot\vslive\midcoast\waldo\news\include\bizorgbriefs.cfm:1)
	at cfbizorgbriefs2ecfm1476774719.runPage(\\vsweb\wwwroot\vslive\midcoast\waldo\news\include\bizorgbriefs.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 cfApplication2ecfc1208215934$funcONREQUEST.runFunction(\\vsweb\wwwroot\vslive\midcoast\waldo\Application.cfc:49)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:72)
	at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:178)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:215)
	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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
	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)

Currently there are no polls available.


CNB - Roots You Can Bank On

Unity Raceway - Maine's Toughest Oval

http://www.villagesoup.com/dutch
Dutch Chevy--Buick-Pontiac
6 Belmont Avenue
Belfast, ME, 04915
Phone: 207-338-1470 or 1-800-339-2468

bizSearch