[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
NextException
struct
ErrorCode
8180
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
839
RAW_TRACE
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_HEADER
LINE
42
RAW_TRACE
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_HEADER
LINE
1
RAW_TRACE
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
4
RAW_TRACE
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
2
RAW_TRACE
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
1
RAW_TRACE
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
256
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLException
SQLState
42S02
StackTrace
java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
839
RAW_TRACE
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_HEADER
LINE
42
RAW_TRACE
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_HEADER
LINE
1
RAW_TRACE
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
4
RAW_TRACE
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
2
RAW_TRACE
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
1
RAW_TRACE
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
256
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLSyntaxErrorException
DataSource
koalasql
Detail
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
ErrorCode
42S02
Exceptions
array
1
struct
class
java.sql.SQLSyntaxErrorException
message
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
2
struct
class
java.sql.SQLException
message
[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
Message
Error Executing Database Query.
NativeErrorCode
208
RootCause
struct
ErrorCode
208
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
NextException
struct
ErrorCode
8180
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
839
RAW_TRACE
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_HEADER
LINE
42
RAW_TRACE
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_HEADER
LINE
1
RAW_TRACE
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
4
RAW_TRACE
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
2
RAW_TRACE
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
1
RAW_TRACE
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
256
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLException
SQLState
42S02
StackTrace
java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
839
RAW_TRACE
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_HEADER
LINE
42
RAW_TRACE
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_HEADER
LINE
1
RAW_TRACE
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
4
RAW_TRACE
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
2
RAW_TRACE
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
1
RAW_TRACE
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
256
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLSyntaxErrorException
SQLState
42S02
Sql
SELECT a.dept,a.web_url,a.sort_position ,TopSale.sort_position as sort_positionTopSale
FROM tb_web_taxonomy_stratus a
left join topsales TopSale ON TopSale.dept =a.dept and a.typ = 'EMPTY'
WHERE 1=1
AND isNull(active,0) = 1
and len(a.web_url)>0
and typ='EMPTY' and a.sort_position<>'NO'
and site = (param 1)
order by TopSale.sort_position desc
StackTrace
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
... 65 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
839
RAW_TRACE
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_HEADER
LINE
42
RAW_TRACE
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_HEADER
LINE
1
RAW_TRACE
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
4
RAW_TRACE
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
2
RAW_TRACE
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
1
RAW_TRACE
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
256
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
Database
queryError
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
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
208
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
NextException
struct
ErrorCode
8180
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
839
RAW_TRACE
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_HEADER
LINE
42
RAW_TRACE
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_HEADER
LINE
1
RAW_TRACE
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
4
RAW_TRACE
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
2
RAW_TRACE
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
1
RAW_TRACE
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
256
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLException
SQLState
42S02
StackTrace
java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
839
RAW_TRACE
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_HEADER
LINE
42
RAW_TRACE
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_HEADER
LINE
1
RAW_TRACE
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
4
RAW_TRACE
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
2
RAW_TRACE
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
1
RAW_TRACE
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
256
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLSyntaxErrorException
DataSource
koalasql
Detail
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
ErrorCode
42S02
Exceptions
array
1
struct
class
java.sql.SQLSyntaxErrorException
message
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
2
struct
class
java.sql.SQLException
message
[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
Message
Error Executing Database Query.
NativeErrorCode
208
RootCause
struct
ErrorCode
208
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
NextException
struct
ErrorCode
8180
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
839
RAW_TRACE
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_HEADER
LINE
42
RAW_TRACE
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_HEADER
LINE
1
RAW_TRACE
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
4
RAW_TRACE
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
2
RAW_TRACE
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
1
RAW_TRACE
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
256
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLException
SQLState
42S02
StackTrace
java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
839
RAW_TRACE
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_HEADER
LINE
42
RAW_TRACE
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_HEADER
LINE
1
RAW_TRACE
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
4
RAW_TRACE
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
2
RAW_TRACE
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
1
RAW_TRACE
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
256
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLSyntaxErrorException
SQLState
42S02
Sql
SELECT a.dept,a.web_url,a.sort_position ,TopSale.sort_position as sort_positionTopSale
FROM tb_web_taxonomy_stratus a
left join topsales TopSale ON TopSale.dept =a.dept and a.typ = 'EMPTY'
WHERE 1=1
AND isNull(active,0) = 1
and len(a.web_url)>0
and typ='EMPTY' and a.sort_position<>'NO'
and site = (param 1)
order by TopSale.sort_position desc
StackTrace
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
... 65 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
839
RAW_TRACE
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_HEADER
LINE
42
RAW_TRACE
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_HEADER
LINE
1
RAW_TRACE
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
4
RAW_TRACE
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
2
RAW_TRACE
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
1
RAW_TRACE
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
256
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
Database
queryError
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
coldfusion.runtime.EventHandlerException: Event handler exception.
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:315)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
... 38 more
Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'topsales'.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
... 65 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
839
RAW_TRACE
at cfheader2ecfm260908490._factor22(C:\websites\stratusecommerce\includes\header.cfm:839)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_HEADER
LINE
42
RAW_TRACE
at cfheader2ecfm260908490._factor28(C:\websites\stratusecommerce\includes\header.cfm:42)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_HEADER
LINE
1
RAW_TRACE
at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\includes\header.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
4
RAW_TRACE
at cfproducts2ecfm1943077553._factor7(C:\websites\stratusecommerce\products.cfm:4)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
2
RAW_TRACE
at cfproducts2ecfm1943077553._factor9(C:\websites\stratusecommerce\products.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTS
LINE
1
RAW_TRACE
at cfproducts2ecfm1943077553.runPage(C:\websites\stratusecommerce\products.cfm:1)
TEMPLATE
C:\websites\stratusecommerce\products.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
256
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:256)