Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][Oracle JDBC Driver][Oracle]ORA-01722: invalid number

80 : 
81 :             <cfquery name="getConfigId4CMM" datasource="#datasource_odbc#">
82 : 			select config_id from model_pricing where product_line = '#param1#' and manufacturer_code = '#param2#' and product_id = '#param3#' and market_id = '#param5#'
83 : 		</cfquery>
84 :

SQLSTATE	22018
EXCEPTIONS	<small><i>not set</i></small>
DATASOURCE	catp_rac10g
VENDORERRORCODE	1722
SQL	select config_id from model_pricing where product_line = 'TBD' and manufacturer_code = 'RS' and product_id = '1332.4717.31' and market_id = 'product'

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	10.0.120.84
Referrer
Date/Time	29-Jun-26 11:43 AM

Stack Trace

java.sql.SQLDataException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01722: invalid number

	at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1408|:1051)
	at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:976)
	at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:1120)
	at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:455)
	at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:941)
	at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:484)
	at macromedia.jdbc.oracle.OracleImplStatement.cu(|Oracle|6.0.0.1408|:3430)
	at macromedia.jdbc.oracle.base.gs.od(|Oracle|6.0.0.1408|:2505)
	at macromedia.jdbc.oracle.base.gs.nW(|Oracle|6.0.0.1408|:1358)
	at macromedia.jdbc.oracle.base.gs.execute(|Oracle|6.0.0.1408|:4478)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1649)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1391)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1321)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cfunit2ecfm689743438._factor4(D:\wwwroot\testmart-www\estore\unit.cfm:82)
	at cfunit2ecfm689743438.runPage(D:\wwwroot\testmart-www\estore\unit.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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:613)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	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:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
	at java.base/java.lang.Thread.run(Thread.java:842)