Powered by MacRAE'S
Company /  Product/Service
  • Search

Error on Canadian Trade Index

We're sorry - unexpected error happened on Canadian Trade Index web site. Administrator has been notified.

Please type in the product or company you're looking for in the search box in the top right-hand corner of this page or click here to go to our home page

Error

Error object. - struct
Browser CCBot/2.0 (https://commoncrawl.org/faq/)
DateTime {ts '2021-09-28 09:57:27'}
Diagnostics Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function 'sp_RFQ_SelectCoByProd_IP' expects parameter '@prodcode', which was not supplied. <br>The error occurred on line 82.
GeneratedContent [empty string]
HTTPReferer [empty string]
Mailto [empty string]
Message Error Executing Database Query.
QueryString prod_code=5708300
RemoteAddress 44.197.197.23
RootCause
Error object. - struct
Cause
Error object. - struct
ErrorCode 201
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function 'sp_RFQ_SelectCoByProd_IP' expects parameter '@prodcode', which was not supplied.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function 'sp_RFQ_SelectCoByProd_IP' expects parameter '@prodcode', which was not supplied. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeCall(Executive.java:1179) at coldfusion.sql.Executive.executeCall(Executive.java:1052) at coldfusion.sql.Executive.executeCall(Executive.java:1002) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:559) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:357) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:300) at cfrfq_form2ecfm716772073._factor1(D:\devservers\www_corona\search\rfq\rfq_form.cfm:82) at cfrfq_form2ecfm716772073._factor7(D:\devservers\www_corona\search\rfq\rfq_form.cfm:74) at cfrfq_form2ecfm716772073._factor9(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1) at cfrfq_form2ecfm716772073.runPage(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Error object. - array[empty]
TagContext
Error object. - array
1
Error object. - struct
COLUMN 0
ID CFSTOREDPROC
LINE 82
RAW_TRACE at cfrfq_form2ecfm716772073._factor1(D:\devservers\www_corona\search\rfq\rfq_form.cfm:82)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
2
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 74
RAW_TRACE at cfrfq_form2ecfm716772073._factor7(D:\devservers\www_corona\search\rfq\rfq_form.cfm:74)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
3
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 1
RAW_TRACE at cfrfq_form2ecfm716772073._factor9(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
4
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 1
RAW_TRACE at cfrfq_form2ecfm716772073.runPage(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
Type java.sql.SQLException
DataSource CTINS
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function 'sp_RFQ_SelectCoByProd_IP' expects parameter '@prodcode', which was not supplied.
ErrorCode HY000
Exceptions
Error object. - array
1
Error object. - struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function 'sp_RFQ_SelectCoByProd_IP' expects parameter '@prodcode', which was not supplied.
Message Error Executing Database Query.
NativeErrorCode 201
RootCause
Error object. - struct
ErrorCode 201
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function 'sp_RFQ_SelectCoByProd_IP' expects parameter '@prodcode', which was not supplied.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function 'sp_RFQ_SelectCoByProd_IP' expects parameter '@prodcode', which was not supplied. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeCall(Executive.java:1179) at coldfusion.sql.Executive.executeCall(Executive.java:1052) at coldfusion.sql.Executive.executeCall(Executive.java:1002) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:559) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:357) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:300) at cfrfq_form2ecfm716772073._factor1(D:\devservers\www_corona\search\rfq\rfq_form.cfm:82) at cfrfq_form2ecfm716772073._factor7(D:\devservers\www_corona\search\rfq\rfq_form.cfm:74) at cfrfq_form2ecfm716772073._factor9(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1) at cfrfq_form2ecfm716772073.runPage(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Error object. - array[empty]
TagContext
Error object. - array
1
Error object. - struct
COLUMN 0
ID CFSTOREDPROC
LINE 82
RAW_TRACE at cfrfq_form2ecfm716772073._factor1(D:\devservers\www_corona\search\rfq\rfq_form.cfm:82)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
2
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 74
RAW_TRACE at cfrfq_form2ecfm716772073._factor7(D:\devservers\www_corona\search\rfq\rfq_form.cfm:74)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
3
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 1
RAW_TRACE at cfrfq_form2ecfm716772073._factor9(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
4
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 1
RAW_TRACE at cfrfq_form2ecfm716772073.runPage(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql { (param 1) = call sp_RFQ_SelectCoByProd_IP(@prod_code = (param 2) , @St = (param 3) , @CoNumCur = (param 4) , @UserIP = (param 5) , @UserLocationFound = (param 6) )}
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:312) at cfrfq_form2ecfm716772073._factor1(D:\devservers\www_corona\search\rfq\rfq_form.cfm:82) at cfrfq_form2ecfm716772073._factor7(D:\devservers\www_corona\search\rfq\rfq_form.cfm:74) at cfrfq_form2ecfm716772073._factor9(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1) at cfrfq_form2ecfm716772073.runPage(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function 'sp_RFQ_SelectCoByProd_IP' expects parameter '@prodcode', which was not supplied. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeCall(Executive.java:1179) at coldfusion.sql.Executive.executeCall(Executive.java:1052) at coldfusion.sql.Executive.executeCall(Executive.java:1002) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:559) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:357) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:300) ... 48 more
Suppressed
Error object. - array[empty]
TagContext
Error object. - array
1
Error object. - struct
COLUMN 0
ID CFSTOREDPROC
LINE 82
RAW_TRACE at cfrfq_form2ecfm716772073._factor1(D:\devservers\www_corona\search\rfq\rfq_form.cfm:82)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
2
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 74
RAW_TRACE at cfrfq_form2ecfm716772073._factor7(D:\devservers\www_corona\search\rfq\rfq_form.cfm:74)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
3
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 1
RAW_TRACE at cfrfq_form2ecfm716772073._factor9(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
4
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 1
RAW_TRACE at cfrfq_form2ecfm716772073.runPage(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function 'sp_RFQ_SelectCoByProd_IP' expects parameter '@prodcode', which was not supplied.
where (param 1) = [type='OUT', sqltype='CF_SQL_INTEGER'] , (param 2) = [type='IN', class='java.lang.Integer', value='5708300', sqltype='cf_sql_integer'] , (param 3) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] , (param 4) = [type='IN', class='java.lang.Integer', value='0', sqltype='cf_sql_integer'] , (param 5) = [type='IN', class='java.lang.Long', value='751158551', sqltype='cf_sql_bigint'] , (param 6) = [type='OUT', sqltype='cf_sql_integer']
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:312) at cfrfq_form2ecfm716772073._factor1(D:\devservers\www_corona\search\rfq\rfq_form.cfm:82) at cfrfq_form2ecfm716772073._factor7(D:\devservers\www_corona\search\rfq\rfq_form.cfm:74) at cfrfq_form2ecfm716772073._factor9(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1) at cfrfq_form2ecfm716772073.runPage(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function 'sp_RFQ_SelectCoByProd_IP' expects parameter '@prodcode', which was not supplied. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeCall(Executive.java:1179) at coldfusion.sql.Executive.executeCall(Executive.java:1052) at coldfusion.sql.Executive.executeCall(Executive.java:1002) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:559) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:357) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:300) ... 48 more
Suppressed
Error object. - array[empty]
TagContext
Error object. - array
1
Error object. - struct
COLUMN 0
ID CFSTOREDPROC
LINE 82
RAW_TRACE at cfrfq_form2ecfm716772073._factor1(D:\devservers\www_corona\search\rfq\rfq_form.cfm:82)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
2
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 74
RAW_TRACE at cfrfq_form2ecfm716772073._factor7(D:\devservers\www_corona\search\rfq\rfq_form.cfm:74)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
3
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 1
RAW_TRACE at cfrfq_form2ecfm716772073._factor9(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
4
Error object. - struct
COLUMN 0
ID CF_RFQ_FORM
LINE 1
RAW_TRACE at cfrfq_form2ecfm716772073.runPage(D:\devservers\www_corona\search\rfq\rfq_form.cfm:1)
TEMPLATE D:\devservers\www_corona\search\rfq\rfq_form.cfm
TYPE CFML
Template /search/rfq/rfq_form.cfm
Type coldfusion.runtime.CfErrorWrapper

CGI

CGI object - struct
AUTH_PASSWORD [empty string]
AUTH_TYPE [empty string]
AUTH_USER [empty string]
CERT_COOKIE [empty string]
CERT_FLAGS [empty string]
CERT_ISSUER [empty string]
CERT_KEYSIZE 256
CERT_SECRETKEYSIZE 2048
CERT_SERIALNUMBER [empty string]
CERT_SERVER_ISSUER C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
CERT_SERVER_SUBJECT CN=www.macraesbluebook.com
CERT_SUBJECT [empty string]
CF_TEMPLATE_PATH D:\devservers\www_corona\search\rfq\rfq_form.cfm
CONTENT_LENGTH 0
CONTENT_TYPE [empty string]
CONTEXT_PATH [empty string]
GATEWAY_INTERFACE CGI/1.1
HTTPS on
HTTPS_KEYSIZE 256
HTTPS_SECRETKEYSIZE 2048
HTTPS_SERVER_ISSUER C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECT CN=www.macraesbluebook.com
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING br,gzip
HTTP_ACCEPT_LANGUAGE en-US,en;q=0.5
HTTP_CONNECTION Keep-Alive
HTTP_COOKIE [empty string]
HTTP_HOST www.ctidirectory.com
HTTP_REFERER [empty string]
HTTP_URL /search/rfq/rfq_form.cfm?prod_code=5708300
HTTP_USER_AGENT CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR 10.12.27.92
PATH_INFO [empty string]
PATH_TRANSLATED D:\devservers\www_corona\search\rfq\rfq_form.cfm
QUERY_STRING prod_code=5708300
REMOTE_ADDR 44.197.197.23
REMOTE_HOST 44.197.197.23
REMOTE_USER [empty string]
REQUEST_METHOD GET
SCRIPT_NAME /search/rfq/rfq_form.cfm
SERVER_NAME www.ctidirectory.com
SERVER_PORT 443
SERVER_PORT_SECURE 1
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/10.0
WEB_SERVER_API [empty string]

REQUEST

REQUEST object - struct
cfdumpinited true
cfdumpinitedforfunc FALSE
form
REQUEST object - struct [empty]
samesite_value [empty string]

FORM

FORM object - struct [empty]

URL

URL object - struct
prod_code 5708300

SESSION

SESSION object - struct
cfid 3928733
cftoken 3bdef869dd287642-BEF5E8A9-F2DD-EBEA-A8D4B0FC66ACF465
sessionid CTI_3928733_3bdef869dd287642-BEF5E8A9-F2DD-EBEA-A8D4B0FC66ACF465
urltoken CFID=3928733&CFTOKEN=3bdef869dd287642-BEF5E8A9-F2DD-EBEA-A8D4B0FC66ACF465

Cookie Variables

Cookie object - struct
CFID 3928733
CFTOKEN 3bdef869dd287642-BEF5E8A9-F2DD-EBEA-A8D4B0FC66ACF465
LANGUAGE en
 
Browse by Company:   0-9  A  B  C  D-E  F-G  H-J  K-L  M  N-O  P  Q-R  S  T-U  V-Z                    Browse by Heading:   A-C   D-K   L-R   S-Z
  • © 2021 MacRAE'S. All rights reserved
  • Like us -
  • |
  • Join us -
  • |
  • Follow us -