Oops! exception Encountered

Application Execution Exception

Error Type: database : 0
Error Messages:
Transaction (Process ID 66) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Tag Context:
ID: ??
LINE: 81
Template: /components/dao/BasicDAO.cfc
ID: ??
LINE: 22
Template: /components/service/NewsService.cfc
ID: ??
LINE: 137
Template: /handlers/NewsManager.cfc
ID: ??
LINE: 764
Template: /coldbox/system/web/Controller.cfc
ID: ??
LINE: 648
Template: /coldbox/system/web/Controller.cfc
ID: ??
LINE: 236
Template: /coldbox/system/coldbox.cfc
ID: ??
LINE: 134
Template: /Application.cfc
Framework Snapshot
Current Event: NewsManager.getNews
Current Layout: N/A (Module: )
Current View: N/A
Bug Date: 05/25/2015 06:17:13 AM
Coldfusion ID: JSessionID=hok4yrb6d7jt1npbfapr50d5u
Template Path : D:\websites\www.computerworlduk.com\index.cfm
Path Info :
Host & Server: www.computerworlduk.com 507504-WEB03
Query String: event=NewsManager.getNews&id=3256400
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, articleAuthorId, n.articleSourceId, featureCategory AS featureCategoryId, articleBody, articleStart, primary_channelid AS channelId, articleSource, articleSourceURL, isIDGUKSource, metaTitle, metaDescription, metaKeywords, metaAbstract, homePageImage, '' AS sidebarImage, '' AS largeImage, '' AS thumbImage, '' AS smallThumbImage, c.id AS companyId, companyName, originalArticleSourceUrl, uploadedBy, isOriginalIDGUKContent, n.articleSourceId, uploaderSourceId, 4 AS itemTypeId, dbo.GetChannelIdsAsCSVForItem(32, n.featureId, 4) as channels_csv , n.urlTitle FROM CWUK_Features n LEFT OUTER JOIN ArticleSources asl ON n.articleSourceId = asl.articleSourceId LEFT OUTER JOIN CWUK_Admin_Art_Com aac ON n.featureId = aac.articleId LEFT OUTER JOIN Companies c ON aac.companyId = c.id WHERE ( ( n.featureId = 3495557 AND n.featureId = ISNULL(n.OldItemId, n.featureId) ) OR ( n.featureId = 3495557 AND n.featureId <> ISNULL(n.OldItemId, n.featureId) ) OR ( n.OldItemId = 3495557 AND n.OldItemTypeId = 2 ) ) AND n.online = 1 AND FeatureCategory = 4 AND ( aac.articleType = 'features' OR aac.articleType IS NULL ) AND n.articleStart < {ts '2015-05-25 06:17:11'} AND n.articleStop > {ts '2015-05-25 06:17:11'} ORDER BY n.articleStart DESC
Database Driver Error Message:
SELECT TOP 1 featureId AS id, headline, strapline, summaryParagraph, articleAuthor, articleAuthorId, n.articleSourceId, featureCategory AS featureCategoryId, articleBody, articleStart, primary_channelid AS channelId, articleSource, articleSourceURL, isIDGUKSource, metaTitle, metaDescription, metaKeywords, metaAbstract, homePageImage, '' AS sidebarImage, '' AS largeImage, '' AS thumbImage, '' AS smallThumbImage, c.id AS companyId, companyName, originalArticleSourceUrl, uploadedBy, isOriginalIDGUKContent, n.articleSourceId, uploaderSourceId, 4 AS itemTypeId, dbo.GetChannelIdsAsCSVForItem(32, n.featureId, 4) as channels_csv , n.urlTitle FROM CWUK_Features n LEFT OUTER JOIN ArticleSources asl ON n.articleSourceId = asl.articleSourceId LEFT OUTER JOIN CWUK_Admin_Art_Com aac ON n.featureId = aac.articleId LEFT OUTER JOIN Companies c ON aac.companyId = c.id WHERE ( ( n.featureId = 3495557 AND n.featureId = ISNULL(n.OldItemId, n.featureId) ) OR ( n.featureId = 3495557 AND n.featureId <> ISNULL(n.OldItemId, n.featureId) ) OR ( n.OldItemId = 3495557 AND n.OldItemTypeId = 2 ) ) AND n.online = 1 AND FeatureCategory = 4 AND ( aac.articleType = 'features' OR aac.articleType IS NULL ) AND n.articleStart < {ts '2015-05-25 06:17:11'} AND n.articleStop > {ts '2015-05-25 06:17:11'} ORDER BY n.articleStart DESC
Name-Value Pairs:
Form variables:
Session Storage:
Cookies:
JSESSIONID: hok4yrb6d7jt1npbfapr50d5u
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:81):81
	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.udfCall(/handlers/NewsManager.cfc:137):137
	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:764):764
	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:648):648
	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:134):134
	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.GeneratedMethodAccessor34.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]