ESAB 7018-1 Prime 1/8x14in. VP
55043230G0
struct
Cause
struct
ErrorCode
512
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
SQLState
21000
StackTrace
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
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.dda3.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.$fr$execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.$fr$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:1547)
at coldfusion.sql.Executive.executeQuery(Executive.java:1281)
at coldfusion.sql.Executive.executeQuery(Executive.java:1211)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfProductRefresh_Controller2ecfm1761293616$funcISAVAILABLEINSPIDER.runFunction(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:406)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522)
at cfProductRefresh_main_Content2ecfm1551041316._factor147(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5524)
at cfProductRefresh_main_Content2ecfm1551041316._factor148(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5512)
at cfProductRefresh_main_Content2ecfm1551041316._factor151(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5486)
at cfProductRefresh_main_Content2ecfm1551041316._factor154(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5457)
at cfProductRefresh_main_Content2ecfm1551041316._factor158(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5331)
at cfProductRefresh_main_Content2ecfm1551041316._factor159(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:2)
at cfProductRefresh_main_Content2ecfm1551041316._factor160(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
at cfProductRefresh_main_Content2ecfm1551041316.runPage(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3696)
at cfProductRefresh_Controller2ecfm1761293616._factor1(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:190)
at cfProductRefresh_Controller2ecfm1761293616._factor3(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:177)
at cfProductRefresh_Controller2ecfm1761293616._factor4(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:151)
at cfProductRefresh_Controller2ecfm1761293616._factor6(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:90)
at cfProductRefresh_Controller2ecfm1761293616._factor8(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:16)
at cfProductRefresh_Controller2ecfm1761293616._factor10(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:11)
at cfProductRefresh_Controller2ecfm1761293616._factor11(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:10)
at cfProductRefresh_Controller2ecfm1761293616.runPage(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:755)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:792)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
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
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
406
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616$funcISAVAILABLEINSPIDER.runFunction(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:406)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_UDFMETHOD
LINE
5524
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor147(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5524)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5512
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor148(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5512)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5486
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor151(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5486)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5457
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor154(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5457)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5331
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor158(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5331)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
2
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor159(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:2)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
8
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
1
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor160(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
9
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
1
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316.runPage(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
10
struct
COLUMN
0
ID
CFINCLUDE
LINE
190
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor1(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:190)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
11
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
177
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor3(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:177)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
12
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
151
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor4(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:151)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
13
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
90
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor6(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:90)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
14
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
16
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor8(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:16)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
15
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
11
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor10(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:11)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
16
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
10
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor11(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:10)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
17
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
1
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616.runPage(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:1)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
Type
java.sql.SQLException
DataSource
ESABPIM
Detail
[Macromedia][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
ErrorCode
21000
Exceptions
array
1
struct
class
java.sql.SQLException
message
[Macromedia][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Message
Error Executing Database Query.
NativeErrorCode
512
RootCause
struct
ErrorCode
512
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
SQLState
21000
StackTrace
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
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.dda3.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.$fr$execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.$fr$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:1547)
at coldfusion.sql.Executive.executeQuery(Executive.java:1281)
at coldfusion.sql.Executive.executeQuery(Executive.java:1211)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfProductRefresh_Controller2ecfm1761293616$funcISAVAILABLEINSPIDER.runFunction(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:406)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522)
at cfProductRefresh_main_Content2ecfm1551041316._factor147(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5524)
at cfProductRefresh_main_Content2ecfm1551041316._factor148(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5512)
at cfProductRefresh_main_Content2ecfm1551041316._factor151(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5486)
at cfProductRefresh_main_Content2ecfm1551041316._factor154(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5457)
at cfProductRefresh_main_Content2ecfm1551041316._factor158(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5331)
at cfProductRefresh_main_Content2ecfm1551041316._factor159(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:2)
at cfProductRefresh_main_Content2ecfm1551041316._factor160(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
at cfProductRefresh_main_Content2ecfm1551041316.runPage(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3696)
at cfProductRefresh_Controller2ecfm1761293616._factor1(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:190)
at cfProductRefresh_Controller2ecfm1761293616._factor3(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:177)
at cfProductRefresh_Controller2ecfm1761293616._factor4(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:151)
at cfProductRefresh_Controller2ecfm1761293616._factor6(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:90)
at cfProductRefresh_Controller2ecfm1761293616._factor8(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:16)
at cfProductRefresh_Controller2ecfm1761293616._factor10(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:11)
at cfProductRefresh_Controller2ecfm1761293616._factor11(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:10)
at cfProductRefresh_Controller2ecfm1761293616.runPage(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:755)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:792)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
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
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
406
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616$funcISAVAILABLEINSPIDER.runFunction(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:406)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_UDFMETHOD
LINE
5524
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor147(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5524)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5512
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor148(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5512)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5486
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor151(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5486)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5457
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor154(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5457)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5331
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor158(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5331)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
2
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor159(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:2)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
8
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
1
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor160(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
9
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
1
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316.runPage(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
10
struct
COLUMN
0
ID
CFINCLUDE
LINE
190
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor1(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:190)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
11
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
177
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor3(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:177)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
12
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
151
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor4(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:151)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
13
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
90
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor6(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:90)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
14
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
16
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor8(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:16)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
15
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
11
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor10(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:11)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
16
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
10
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor11(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:10)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
17
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
1
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616.runPage(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:1)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
Type
java.sql.SQLException
SQLState
21000
Sql
select Count(*) As isAvailable from tb_ComponentAttrVal tc
where FK_Attribute =(select PK_Attribute from tb_Attribute where ShortName = 'WhereToBuy')
and FK_CNode = (select da.FK_CNode from tb_ComponentAttrVal da, tb_CNode c where FK_Attribute = (select PK_Attribute from tb_Attribute where ShortName = 'EntityNumber')
and da.AttrVal = c.ShortName and da.FK_CNode = c.PK_CNode
and da.AttrVal = (param 1) )
and tc.AttrVal = (select id from tblk_Country where Site_Region = (param 2) )
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 cfProductRefresh_Controller2ecfm1761293616$funcISAVAILABLEINSPIDER.runFunction(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:406)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522)
at cfProductRefresh_main_Content2ecfm1551041316._factor147(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5524)
at cfProductRefresh_main_Content2ecfm1551041316._factor148(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5512)
at cfProductRefresh_main_Content2ecfm1551041316._factor151(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5486)
at cfProductRefresh_main_Content2ecfm1551041316._factor154(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5457)
at cfProductRefresh_main_Content2ecfm1551041316._factor158(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5331)
at cfProductRefresh_main_Content2ecfm1551041316._factor159(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:2)
at cfProductRefresh_main_Content2ecfm1551041316._factor160(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
at cfProductRefresh_main_Content2ecfm1551041316.runPage(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3696)
at cfProductRefresh_Controller2ecfm1761293616._factor1(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:190)
at cfProductRefresh_Controller2ecfm1761293616._factor3(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:177)
at cfProductRefresh_Controller2ecfm1761293616._factor4(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:151)
at cfProductRefresh_Controller2ecfm1761293616._factor6(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:90)
at cfProductRefresh_Controller2ecfm1761293616._factor8(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:16)
at cfProductRefresh_Controller2ecfm1761293616._factor10(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:11)
at cfProductRefresh_Controller2ecfm1761293616._factor11(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:10)
at cfProductRefresh_Controller2ecfm1761293616.runPage(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:755)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:792)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
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.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
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.dda3.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.$fr$execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.$fr$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:1547)
at coldfusion.sql.Executive.executeQuery(Executive.java:1281)
at coldfusion.sql.Executive.executeQuery(Executive.java:1211)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815)
... 97 more
Suppressed
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
406
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616$funcISAVAILABLEINSPIDER.runFunction(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:406)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
2
struct
COLUMN
0
ID
CF_UDFMETHOD
LINE
5524
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor147(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5524)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5512
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor148(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5512)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5486
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor151(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5486)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5457
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor154(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5457)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
5331
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor158(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:5331)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
2
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor159(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:2)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
8
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
1
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316._factor160(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
9
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_MAIN_CONTENT
LINE
1
RAW_TRACE
at cfProductRefresh_main_Content2ecfm1551041316.runPage(C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm:1)
TEMPLATE
C:\inetpub\wwwroot\clients\esab2013\customcf\catalog\ProductRefresh_main_Content.cfm
TYPE
CFML
10
struct
COLUMN
0
ID
CFINCLUDE
LINE
190
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor1(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:190)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
11
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
177
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor3(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:177)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
12
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
151
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor4(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:151)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
13
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
90
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor6(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:90)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
14
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
16
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor8(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:16)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
15
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
11
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor10(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:11)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
16
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
10
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616._factor11(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:10)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
17
struct
COLUMN
0
ID
CF_PRODUCTREFRESH_CONTROLLER
LINE
1
RAW_TRACE
at cfProductRefresh_Controller2ecfm1761293616.runPage(C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm:1)
TEMPLATE
C:\inetpub\wwwroot\Clients\esab2013\customcf\catalog\ProductRefresh_Controller.cfm
TYPE
CFML
Type
Database
queryError
[Macromedia][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
where
(param 1) = [type='IN', class='java.lang.String', value='55043230G0', sqltype='CF_SQL_VARCHAR'] , (param 2) = [type='IN', class='java.lang.String', value='us', sqltype='CF_SQL_VARCHAR']