Free ground shipping on purchases over $100 shipped within the U.S.

 

 
struct
Cause
struct
ErrorCode 208
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'web_all_products'.
SQLState 42S02
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'web_all_products'. 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.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1485) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc2086082739$funcGETSALEPRICES.runFunction(D:\websites\functions\itemDetails.cfc:179) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfthumbnails2ecfm2079453397.runPage(D:\websites\includes\views\thumbnails.cfm:71) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfclientCustomizations2ecfc998708050$funcWERECOMMEND._factor0(D:\websites\functions\clientCustomizations.cfc:197) at cfclientCustomizations2ecfc998708050$funcWERECOMMEND.runFunction(D:\websites\functions\clientCustomizations.cfc:141) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:651) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:460) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2430) at cfproducts2ecfm507695861._factor12(D:\websites\defaultWebsite\products.cfm:71) at cfproducts2ecfm507695861._factor13(D:\websites\defaultWebsite\products.cfm:2) at cfproducts2ecfm507695861.runPage(D:\websites\defaultWebsite\products.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc1527249034$funcONREQUEST.runFunction(D:\websites\application.cfc:186) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) 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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 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:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 179
RAW_TRACE at cfitemDetails2ecfc2086082739$funcGETSALEPRICES.runFunction(D:\websites\functions\itemDetails.cfc:179)
TEMPLATE D:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 71
RAW_TRACE at cfthumbnails2ecfm2079453397.runPage(D:\websites\includes\views\thumbnails.cfm:71)
TEMPLATE D:\websites\includes\views\thumbnails.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 197
RAW_TRACE at cfclientCustomizations2ecfc998708050$funcWERECOMMEND._factor0(D:\websites\functions\clientCustomizations.cfc:197)
TEMPLATE D:\websites\functions\clientCustomizations.cfc
TYPE CFML
4
struct
COLUMN 0
ID CF_CLIENTCUSTOMIZATIONS
LINE 141
RAW_TRACE at cfclientCustomizations2ecfc998708050$funcWERECOMMEND.runFunction(D:\websites\functions\clientCustomizations.cfc:141)
TEMPLATE D:\websites\functions\clientCustomizations.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 71
RAW_TRACE at cfproducts2ecfm507695861._factor12(D:\websites\defaultWebsite\products.cfm:71)
TEMPLATE D:\websites\defaultWebsite\products.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_PRODUCTS
LINE 2
RAW_TRACE at cfproducts2ecfm507695861._factor13(D:\websites\defaultWebsite\products.cfm:2)
TEMPLATE D:\websites\defaultWebsite\products.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_PRODUCTS
LINE 1
RAW_TRACE at cfproducts2ecfm507695861.runPage(D:\websites\defaultWebsite\products.cfm:1)
TEMPLATE D:\websites\defaultWebsite\products.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 186
RAW_TRACE at cfapplication2ecfc1527249034$funcONREQUEST.runFunction(D:\websites\application.cfc:186)
TEMPLATE D:\websites\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource celerantSQL
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'web_all_products'.
ErrorCode 42S02
Exceptions
array
1
struct
class java.sql.SQLSyntaxErrorException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'web_all_products'.
Message Error Executing Database Query.
NativeErrorCode 208
RootCause
struct
ErrorCode 208
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'web_all_products'.
SQLState 42S02
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'web_all_products'. 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.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1485) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc2086082739$funcGETSALEPRICES.runFunction(D:\websites\functions\itemDetails.cfc:179) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfthumbnails2ecfm2079453397.runPage(D:\websites\includes\views\thumbnails.cfm:71) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfclientCustomizations2ecfc998708050$funcWERECOMMEND._factor0(D:\websites\functions\clientCustomizations.cfc:197) at cfclientCustomizations2ecfc998708050$funcWERECOMMEND.runFunction(D:\websites\functions\clientCustomizations.cfc:141) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:651) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:460) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2430) at cfproducts2ecfm507695861._factor12(D:\websites\defaultWebsite\products.cfm:71) at cfproducts2ecfm507695861._factor13(D:\websites\defaultWebsite\products.cfm:2) at cfproducts2ecfm507695861.runPage(D:\websites\defaultWebsite\products.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc1527249034$funcONREQUEST.runFunction(D:\websites\application.cfc:186) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) 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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 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:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 179
RAW_TRACE at cfitemDetails2ecfc2086082739$funcGETSALEPRICES.runFunction(D:\websites\functions\itemDetails.cfc:179)
TEMPLATE D:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 71
RAW_TRACE at cfthumbnails2ecfm2079453397.runPage(D:\websites\includes\views\thumbnails.cfm:71)
TEMPLATE D:\websites\includes\views\thumbnails.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 197
RAW_TRACE at cfclientCustomizations2ecfc998708050$funcWERECOMMEND._factor0(D:\websites\functions\clientCustomizations.cfc:197)
TEMPLATE D:\websites\functions\clientCustomizations.cfc
TYPE CFML
4
struct
COLUMN 0
ID CF_CLIENTCUSTOMIZATIONS
LINE 141
RAW_TRACE at cfclientCustomizations2ecfc998708050$funcWERECOMMEND.runFunction(D:\websites\functions\clientCustomizations.cfc:141)
TEMPLATE D:\websites\functions\clientCustomizations.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 71
RAW_TRACE at cfproducts2ecfm507695861._factor12(D:\websites\defaultWebsite\products.cfm:71)
TEMPLATE D:\websites\defaultWebsite\products.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_PRODUCTS
LINE 2
RAW_TRACE at cfproducts2ecfm507695861._factor13(D:\websites\defaultWebsite\products.cfm:2)
TEMPLATE D:\websites\defaultWebsite\products.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_PRODUCTS
LINE 1
RAW_TRACE at cfproducts2ecfm507695861.runPage(D:\websites\defaultWebsite\products.cfm:1)
TEMPLATE D:\websites\defaultWebsite\products.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 186
RAW_TRACE at cfapplication2ecfc1527249034$funcONREQUEST.runFunction(D:\websites\application.cfc:186)
TEMPLATE D:\websites\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S02
Sql SELECT SUM(c2.qoh) as totalQOH, max(a.style_id) as style_id, max(c.price) as maxprice, min(c.price) as minprice, min(c.store_price) as store_price, max(c.dlu) as dlu, b.sku_id, b.ATTR1_ENTRY_ID FROM web_all_products a left JOIN tb_skus b with (nolock) ON a.style_id = b.style_id left JOIN tb_sku_buckets c with (nolock) ON b.sku_id = c.sku_id AND c.STORE_ID = 6 left JOIN tb_sku_buckets c2 with (nolock) ON b.sku_id = c2.sku_id WHERE a.style_id = 84182 and c.price <> '' and c2.store_id in(1,2,3,5) GROUP BY b.sku_id, b.ATTR1_ENTRY_ID HAVING sum(c2.qoh) > 0
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc2086082739$funcGETSALEPRICES.runFunction(D:\websites\functions\itemDetails.cfc:179) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfthumbnails2ecfm2079453397.runPage(D:\websites\includes\views\thumbnails.cfm:71) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfclientCustomizations2ecfc998708050$funcWERECOMMEND._factor0(D:\websites\functions\clientCustomizations.cfc:197) at cfclientCustomizations2ecfc998708050$funcWERECOMMEND.runFunction(D:\websites\functions\clientCustomizations.cfc:141) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:651) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:460) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2430) at cfproducts2ecfm507695861._factor12(D:\websites\defaultWebsite\products.cfm:71) at cfproducts2ecfm507695861._factor13(D:\websites\defaultWebsite\products.cfm:2) at cfproducts2ecfm507695861.runPage(D:\websites\defaultWebsite\products.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc1527249034$funcONREQUEST.runFunction(D:\websites\application.cfc:186) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) 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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 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:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'web_all_products'. 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.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1485) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) ... 79 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 179
RAW_TRACE at cfitemDetails2ecfc2086082739$funcGETSALEPRICES.runFunction(D:\websites\functions\itemDetails.cfc:179)
TEMPLATE D:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 71
RAW_TRACE at cfthumbnails2ecfm2079453397.runPage(D:\websites\includes\views\thumbnails.cfm:71)
TEMPLATE D:\websites\includes\views\thumbnails.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 197
RAW_TRACE at cfclientCustomizations2ecfc998708050$funcWERECOMMEND._factor0(D:\websites\functions\clientCustomizations.cfc:197)
TEMPLATE D:\websites\functions\clientCustomizations.cfc
TYPE CFML
4
struct
COLUMN 0
ID CF_CLIENTCUSTOMIZATIONS
LINE 141
RAW_TRACE at cfclientCustomizations2ecfc998708050$funcWERECOMMEND.runFunction(D:\websites\functions\clientCustomizations.cfc:141)
TEMPLATE D:\websites\functions\clientCustomizations.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 71
RAW_TRACE at cfproducts2ecfm507695861._factor12(D:\websites\defaultWebsite\products.cfm:71)
TEMPLATE D:\websites\defaultWebsite\products.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_PRODUCTS
LINE 2
RAW_TRACE at cfproducts2ecfm507695861._factor13(D:\websites\defaultWebsite\products.cfm:2)
TEMPLATE D:\websites\defaultWebsite\products.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_PRODUCTS
LINE 1
RAW_TRACE at cfproducts2ecfm507695861.runPage(D:\websites\defaultWebsite\products.cfm:1)
TEMPLATE D:\websites\defaultWebsite\products.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 186
RAW_TRACE at cfapplication2ecfc1527249034$funcONREQUEST.runFunction(D:\websites\application.cfc:186)
TEMPLATE D:\websites\application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'web_all_products'.
where [empty string]