struct

EVENTNAME

onRequest

EXCEPTION

struct

Cause

struct

Cause

struct

ErrorCode

1205

Message

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

SQLState

40001

StackTrace

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 159) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1658) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1415) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4142) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4105) at cfcategory2ecfm1745707752._factor6(C:\websites\stratusecommerce\category.cfm:61) at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:4) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:842)

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1095
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1095)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	1415
RAW_TRACE	at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1415)
TEMPLATE	C:\websites\stratusecommerce\functions\category.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	61
RAW_TRACE	at cfcategory2ecfm1745707752._factor6(C:\websites\stratusecommerce\category.cfm:61)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	4
RAW_TRACE	at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:4)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	1
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

Type

java.sql.SQLTransactionRollbackException

DataSource

koalasql

Detail

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

ErrorCode

40001

Exceptions

array

struct
class	java.sql.SQLTransactionRollbackException
message	[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 159) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Message

Error Executing Database Query.

NativeErrorCode

1205

RootCause

struct

ErrorCode

1205

Message

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

SQLState

40001

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1095
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1095)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	1415
RAW_TRACE	at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1415)
TEMPLATE	C:\websites\stratusecommerce\functions\category.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	61
RAW_TRACE	at cfcategory2ecfm1745707752._factor6(C:\websites\stratusecommerce\category.cfm:61)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	4
RAW_TRACE	at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:4)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	1
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

Type

java.sql.SQLTransactionRollbackException

SQLState

40001

Sql

SELECT DISTINCT style_id , max(webstyle) as webstyle , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage FROM web_all_products WHERE 1=1 --AND pictureid is not null and ltrim(rtrim(dept)) = (param 1) and ltrim(rtrim(typ)) = (param 2) and ltrim(rtrim(subtyp1)) = 'EMPTY' AND ( 1=2 OR upper(brand) like (param 3) OR upper(brand) like (param 4) OR upper(brand) like (param 5) OR upper(brand) like (param 6) OR upper(brand) like (param 7) ) GROUP BY STYLE_ID

StackTrace

coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1415) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4142) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4105) at cfcategory2ecfm1745707752._factor6(C:\websites\stratusecommerce\category.cfm:61) at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:4) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 159) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1658) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869) ... 73 more

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	1415
RAW_TRACE	at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1415)
TEMPLATE	C:\websites\stratusecommerce\functions\category.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	61
RAW_TRACE	at cfcategory2ecfm1745707752._factor6(C:\websites\stratusecommerce\category.cfm:61)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	4
RAW_TRACE	at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:4)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	1
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	1095
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1095)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

Type

Database

queryError

[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 159) 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='Products', sqltype='CF_SQL_VARCHAR'] , (param 2) = [type='IN', class='java.lang.String', value='Fashion', sqltype='CF_SQL_VARCHAR'] , (param 3) = [type='IN', class='java.lang.String', value='%u%s%mulch%ohio%', sqltype='CF_SQL_VARCHAR'] , (param 4) = [type='IN', class='java.lang.String', value='%brighton%leegin%leather%', sqltype='CF_SQL_VARCHAR'] , (param 5) = [type='IN', class='java.lang.String', value='%bright%ideas%', sqltype='CF_SQL_VARCHAR'] , (param 6) = [type='IN', class='java.lang.String', value='%leco%electric%', sqltype='CF_SQL_VARCHAR'] , (param 7) = [type='IN', class='java.lang.String', value='%treska%', sqltype='CF_SQL_VARCHAR']

Detail

An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.

Message

Event handler exception.

RootCause

struct

Cause

struct

ErrorCode

1205

Message

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

SQLState

40001

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1095
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1095)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	1415
RAW_TRACE	at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1415)
TEMPLATE	C:\websites\stratusecommerce\functions\category.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	61
RAW_TRACE	at cfcategory2ecfm1745707752._factor6(C:\websites\stratusecommerce\category.cfm:61)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	4
RAW_TRACE	at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:4)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	1
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

Type

java.sql.SQLTransactionRollbackException

DataSource

koalasql

Detail

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

ErrorCode

40001

Exceptions

array

struct
class	java.sql.SQLTransactionRollbackException
message	[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 159) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Message

Error Executing Database Query.

NativeErrorCode

1205

RootCause

struct

ErrorCode

1205

Message

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

SQLState

40001

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1095
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1095)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	1415
RAW_TRACE	at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1415)
TEMPLATE	C:\websites\stratusecommerce\functions\category.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	61
RAW_TRACE	at cfcategory2ecfm1745707752._factor6(C:\websites\stratusecommerce\category.cfm:61)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	4
RAW_TRACE	at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:4)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	1
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

Type

java.sql.SQLTransactionRollbackException

SQLState

40001

Sql

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	1415
RAW_TRACE	at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1415)
TEMPLATE	C:\websites\stratusecommerce\functions\category.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	61
RAW_TRACE	at cfcategory2ecfm1745707752._factor6(C:\websites\stratusecommerce\category.cfm:61)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	4
RAW_TRACE	at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:4)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	1
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	1095
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1095)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

Type

Database

queryError

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

where

StackTrace

coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1415) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4142) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4105) at cfcategory2ecfm1745707752._factor6(C:\websites\stratusecommerce\category.cfm:61) at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:4) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) ... 39 more Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 159) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1658) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869) ... 73 more

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	1415
RAW_TRACE	at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1415)
TEMPLATE	C:\websites\stratusecommerce\functions\category.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	61
RAW_TRACE	at cfcategory2ecfm1745707752._factor6(C:\websites\stratusecommerce\category.cfm:61)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	4
RAW_TRACE	at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:4)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_CATEGORY
LINE	1
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	1095
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1095)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

Type

Database

name

onRequest