Oops! Exception Encountered

Application Execution Exception

Error Type: database : 0
Error Messages:
Transaction (Process ID 316) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Tag Context:
ID: ??
LINE: 62
Template: /components/dao/BasicDAO.cfc
ID: ??
LINE: 22
Template: /components/service/NewsService.cfc
ID: ??
LINE: 61
Template: /handlers/NewsManager.cfc
ID: ??
LINE: 756
Template: /coldbox/system/web/Controller.cfc
ID: ??
LINE: 640
Template: /coldbox/system/web/Controller.cfc
ID: ??
LINE: 236
Template: /coldbox/system/Coldbox.cfc
ID: ??
LINE: 156
Template: /Application.cfc
Framework Snapshot
Current Event: NewsManager.getNews
Current Layout: N/A (Module: )
Current View: N/A
Bug Date: 11/27/2014 02:20:13 PM
Coldfusion ID: JSessionID=4e2u097gv9porkz65idmdgb8
Template Path : D:\websites\www.techworld.com\index.cfm
Path Info :
Host & Server: news.techworld.com 507504-WEB03
Query String: event=NewsManager.getNews&id=6165&channelName=operating-systems
Browser: CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address: 127.0.0.1
Database Exception Information:
NativeErrorCode & SQL State:
1205 : 40001
SQL Sent:
SELECT TOP 1 featureId AS id, headline, strapline, summaryParagraph, articleAuthor, n.articleSourceId, articleBody, articleStart, primary_channelid AS channelId, articleAuthorId, isIDGUKSource, articleSource, articleSourceURL, metaTitle, n.metaDescription, metaKeywords, metaAbstract, homePageImage, '' AS sidebarImage, '' AS largeImage, '' AS thumbImage, '' AS smallThumbImage, 4 AS itemTypeId, uploadedBy, uploaderSourceId, isNull(isOriginalIDGUKContent,0) as isOriginalIDGUKContent, originalArticleSourceUrl, isStandout, featureCategory as featureCategoryId, dbo.GetChannelIdsAsCSVForItem(22, n.featureId, 4) as channels_csv FROM TWUK_Features n LEFT OUTER JOIN ArticleSources asl ON n.articleSourceId = asl.articleSourceId WHERE ( n.featureId = 6165 OR (n.oldItemId = 6165 AND oldItemTypeId=2) ) AND n.featureCategory = 1 AND n.online = 1 AND n.articleStart < {ts '2014-11-27 14:20:04'} AND n.articleStop > {ts '2014-11-27 14:20:04'} ORDER BY n.articleStart DESC
Database Driver Error Message:
SELECT TOP 1 featureId AS id, headline, strapline, summaryParagraph, articleAuthor, n.articleSourceId, articleBody, articleStart, primary_channelid AS channelId, articleAuthorId, isIDGUKSource, articleSource, articleSourceURL, metaTitle, n.metaDescription, metaKeywords, metaAbstract, homePageImage, '' AS sidebarImage, '' AS largeImage, '' AS thumbImage, '' AS smallThumbImage, 4 AS itemTypeId, uploadedBy, uploaderSourceId, isNull(isOriginalIDGUKContent,0) as isOriginalIDGUKContent, originalArticleSourceUrl, isStandout, featureCategory as featureCategoryId, dbo.GetChannelIdsAsCSVForItem(22, n.featureId, 4) as channels_csv FROM TWUK_Features n LEFT OUTER JOIN ArticleSources asl ON n.articleSourceId = asl.articleSourceId WHERE ( n.featureId = 6165 OR (n.oldItemId = 6165 AND oldItemTypeId=2) ) AND n.featureCategory = 1 AND n.online = 1 AND n.articleStart < {ts '2014-11-27 14:20:04'} AND n.articleStop > {ts '2014-11-27 14:20:04'} ORDER BY n.articleStart DESC
Name-Value Pairs:
Form variables:
Session Storage:
Cookies:
JSESSIONID: 4e2u097gv9porkz65idmdgb8
Stack Trace:
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197):197
	at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246):246
	at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83):83
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet.(SQLServerResultSet.java:284):284
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1504):1504
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390):390
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340):340
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575):4575
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400):1400
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179):179
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154):154
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322):322
	at com.intergral.fusionreactor.jdbc.PreparedStatementSurrogate.execute(PreparedStatementSurrogate.java:224):224
	at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:127):127
	at railo.runtime.db.driver.state.StatePreparedStatement.execute(StatePreparedStatement.java:117):117
	at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:222):222
	at railo.runtime.type.QueryImpl.(QueryImpl.java:233):233
	at railo.runtime.tag.Query.executeDatasoure(Query.java:687):687
	at railo.runtime.tag.Query.doEndTag(Query.java:531):531
	at components.dao.basicdao_cfc$cf.udfCall1(/components/dao/BasicDAO.cfc:62):62
	at components.dao.basicdao_cfc$cf.udfCall(/components/dao/BasicDAO.cfc):-1
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307
	at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:195):195
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:624):624
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506
	at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1755):1755
	at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:755):755
	at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1560):1560
	at components.service.newsservice_cfc$cf.udfCall(/components/service/NewsService.cfc:22):22
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307
	at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506
	at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738
	at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:724):724
	at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1550):1550
	at handlers.newsmanager_cfc$cf.udfCall1(/handlers/NewsManager.cfc:61):61
	at handlers.newsmanager_cfc$cf.udfCall(/handlers/NewsManager.cfc):-1
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307
	at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:195):195
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:624):624
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506
	at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1751):1751
	at railo.runtime.tag.Invoke.doComponent(Invoke.java:203):203
	at railo.runtime.tag.Invoke.doEndTag(Invoke.java:176):176
	at coldbox.system.web.controller_cfc$cf.udfCall6(/coldbox/system/web/Controller.cfc:756):756
	at coldbox.system.web.controller_cfc$cf.udfCall(/coldbox/system/web/Controller.cfc):-1
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307
	at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208
	at railo.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:748):748
	at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:724):724
	at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1550):1550
	at coldbox.system.web.controller_cfc$cf.udfCall5(/coldbox/system/web/Controller.cfc:640):640
	at coldbox.system.web.controller_cfc$cf.udfCall(/coldbox/system/web/Controller.cfc):-1
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307
	at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:195):195
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:624):624
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506
	at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1755):1755
	at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:755):755
	at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1560):1560
	at coldbox.system.coldbox_cfc$cf.udfCall1(/coldbox/system/Coldbox.cfc:236):236
	at coldbox.system.coldbox_cfc$cf.udfCall(/coldbox/system/Coldbox.cfc):-1
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307
	at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208
	at railo.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:748):748
	at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:724):724
	at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1550):1550
	at application_cfc$cf.udfCall(/Application.cfc:156):156
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307
	at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506
	at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738
	at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:388):388
	at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:114):114
	at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:18):18
	at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2215):2215
	at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2182):2182
	at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:332):332
	at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:848):848
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:476):476
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:312):312
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:192):192
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:507):507
	at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source):-1
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43):43
	at java.lang.reflect.Method.invoke(Method.java:606):606
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticServlet.service(FusionReactorStaticServlet.java:50):50
	at com.intergral.fusionreactor.agent.pointcuts.ServletPointCut$1.invoke(ServletPointCut.java:42):42
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:47):47
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684):684
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:503):503
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137):137
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557):557
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231):231
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086):1086
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429):429
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193):193
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020):1020
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135):135
	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255):255
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154):154
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116):116
	at org.eclipse.jetty.server.Server.handle(Server.java:370):370
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494):494
	at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971):971
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033):1033
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644):644
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235):235
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82):82
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696):696
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53):53
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608):608
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543):543
	at java.lang.Thread.run(Thread.java:745):745
Extra Information Dump
[N/A]