struct
DataSource MuraDB_LIVE
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 250) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
ErrorCode 40001
Message Error Executing Database Query.
NativeErrorCode 1205
RootCause
struct
ErrorCode 1205
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 250) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQLState 40001
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 250) 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.QueryTable.populate(QueryTable.java:216) at coldfusion.sql.Executive.getRowSet(Executive.java:311) at coldfusion.sql.Executive.executeQuery(Executive.java:756) 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 cf_transition2ecfc1798446172$funcGETALLNEWSEVENTS.runFunction(D:\webroot\substance\extensions\components\toolkit\_transition.cfc:128) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) 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:366) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1772) at cf_transition2ecfc1798446172$funcDISPLAYEVENTS.runFunction(D:\webroot\substance\extensions\components\toolkit\_transition.cfc:287) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) 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.CfJspPage._invoke(CfJspPage.java:1634) at cfRedirectUrls2ecfc457001330$funcREDIRECT.runFunction(D:\webroot\substance\extensions\components\redirect\RedirectUrls.cfc:194) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) 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.CfJspPage._invoke(CfJspPage.java:1634) at cfindex2ecfm1763067309.runPage(D:\webroot\substance\webroot\error\index.cfm:12) 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:225) 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.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) 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:259) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 128
RAW_TRACE at cf_transition2ecfc1798446172$funcGETALLNEWSEVENTS.runFunction(D:\webroot\substance\extensions\components\toolkit\_transition.cfc:128)
TEMPLATE D:\webroot\substance\extensions\components\toolkit\_transition.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 287
RAW_TRACE at cf_transition2ecfc1798446172$funcDISPLAYEVENTS.runFunction(D:\webroot\substance\extensions\components\toolkit\_transition.cfc:287)
TEMPLATE D:\webroot\substance\extensions\components\toolkit\_transition.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 194
RAW_TRACE at cfRedirectUrls2ecfc457001330$funcREDIRECT.runFunction(D:\webroot\substance\extensions\components\redirect\RedirectUrls.cfc:194)
TEMPLATE D:\webroot\substance\extensions\components\redirect\RedirectUrls.cfc
TYPE CFML
4
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 12
RAW_TRACE at cfindex2ecfm1763067309.runPage(D:\webroot\substance\webroot\error\index.cfm:12)
TEMPLATE D:\webroot\substance\webroot\error\index.cfm
TYPE CFML
Type java.sql.SQLException
SQLState 40001
Sql select tc.contentid, tc.contentHistId, tc.title, tc.urltitle, tc.body, tc.isFeature, tc.releaseDate, tc.displayStart, tc.displayStop, '' as imageLink, tced.attributeValue, '' as categoryList, tced2.attributeValue as location, tc2.title as groupName from tcontentcategoryassign tcca inner join tcontent tc on tcca.contentHistid = tc.contentHistid inner join tcontentcategories tcc on tcca.categoryid = tcc.categoryid left outer join tclassextend tce on (tc.type = tce.type and tc.subtype = tce.subtype) left outer join tclassextendsets tces on (tce.subTypeID = tces.subTypeID) left outer join tclassextendattributes tcea on (tces.extendSetID = tcea.extendSetID) left outer join tclassextenddata tced on (tced.attributeID = tcea.attributeID and tc.ContentHistID = tced.baseID) left outer join tcontent tc2 on (tc.ParentID = tc2.contentid and tc2.Active=1) left outer join tclassextendsets tces2 on (tce.subTypeID = tces2.subTypeID) left outer join tclassextendattributes tcea2 on (tces2.extendSetID = tcea2.extendSetID) left outer join tclassextenddata tced2 on (tced2.attributeID = tcea2.attributeID and tc.ContentHistID = tced2.baseID) where tcc.categoryid = (param 1) and tc.active = (param 2) and tc.type = (param 3) and tc.subtype = (param 4) and tces.name = (param 5) and tcea.name = (param 6) and tc.subtype = (param 7) and tces2.name = (param 8) and tcea2.name = (param 9) order by tc.displayStart asc
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cf_transition2ecfc1798446172$funcGETALLNEWSEVENTS.runFunction(D:\webroot\substance\extensions\components\toolkit\_transition.cfc:128) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) 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:366) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1772) at cf_transition2ecfc1798446172$funcDISPLAYEVENTS.runFunction(D:\webroot\substance\extensions\components\toolkit\_transition.cfc:287) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) 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.CfJspPage._invoke(CfJspPage.java:1634) at cfRedirectUrls2ecfc457001330$funcREDIRECT.runFunction(D:\webroot\substance\extensions\components\redirect\RedirectUrls.cfc:194) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) 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.CfJspPage._invoke(CfJspPage.java:1634) at cfindex2ecfm1763067309.runPage(D:\webroot\substance\webroot\error\index.cfm:12) 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:225) 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.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) 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:259) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 128
RAW_TRACE at cf_transition2ecfc1798446172$funcGETALLNEWSEVENTS.runFunction(D:\webroot\substance\extensions\components\toolkit\_transition.cfc:128)
TEMPLATE D:\webroot\substance\extensions\components\toolkit\_transition.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 287
RAW_TRACE at cf_transition2ecfc1798446172$funcDISPLAYEVENTS.runFunction(D:\webroot\substance\extensions\components\toolkit\_transition.cfc:287)
TEMPLATE D:\webroot\substance\extensions\components\toolkit\_transition.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 194
RAW_TRACE at cfRedirectUrls2ecfc457001330$funcREDIRECT.runFunction(D:\webroot\substance\extensions\components\redirect\RedirectUrls.cfc:194)
TEMPLATE D:\webroot\substance\extensions\components\redirect\RedirectUrls.cfc
TYPE CFML
4
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 12
RAW_TRACE at cfindex2ecfm1763067309.runPage(D:\webroot\substance\webroot\error\index.cfm:12)
TEMPLATE D:\webroot\substance\webroot\error\index.cfm
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 250) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
where (param 1) = [type='IN', class='java.lang.String', value='129D1182-E89D-05D5-084C4D03ADE75CDE', sqltype='cf_sql_varchar'] , (param 2) = [type='IN', class='java.lang.Integer', value='1', sqltype='cf_sql_tinyint'] , (param 3) = [type='IN', class='java.lang.String', value='Page', sqltype='cf_sql_varchar'] , (param 4) = [type='IN', class='java.lang.String', value='Calendar', sqltype='cf_sql_varchar'] , (param 5) = [type='IN', class='java.lang.String', value='Article Details', sqltype='cf_sql_varchar'] , (param 6) = [type='IN', class='java.lang.String', value='photo1', sqltype='cf_sql_varchar'] , (param 7) = [type='IN', class='java.lang.String', value='Calendar', sqltype='cf_sql_varchar'] , (param 8) = [type='IN', class='java.lang.String', value='User Entered', sqltype='cf_sql_varchar'] , (param 9) = [type='IN', class='java.lang.String', value='eventLocation', sqltype='cf_sql_varchar']