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][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting expression to data type int.
 
The error occurred in C:/websites/functions/coupon.cfc: line 619
Called from C:/websites/Application.cfm: line 109
Called from C:/websites/Application.cfm: line 1
Called from C:/websites/functions/coupon.cfc: line 619
Called from C:/websites/Application.cfm: line 109
Called from C:/websites/Application.cfm: line 1
617 : 					ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) AS [RandomNumber]
618 : 			  FROM	tb_coupon_serial WITH (NOLOCK)
619 : 			 WHERE	coupon_id = #arguments.couponValue#
620 : 			   AND	date_redeemded is null
621 : 		  ORDER BY	2

SQLSTATE   22001
DATASOURCE   celerantSQL
VENDORERRORCODE   8115
SQL    SELECT TOP 1 serial_lookup, ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) AS [RandomNumber] FROM tb_coupon_serial WITH (NOLOCK) WHERE coupon_id = 598803 AND date_redeemded is null ORDER BY 2
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   172.16.1.1
Referrer  
Date/Time   21-Sep-18 06:59 AM
Stack Trace
at cfcoupon2ecfc831390934$funcSETCOUPONCOOKIE.runFunction(C:/websites/functions/coupon.cfc:619) at cfApplication2ecfm1804277692._factor84(C:/websites/Application.cfm:109) at cfApplication2ecfm1804277692.runPage(C:/websites/Application.cfm:1) at cfcoupon2ecfc831390934$funcSETCOUPONCOOKIE.runFunction(C:/websites/functions/coupon.cfc:619) at cfApplication2ecfm1804277692._factor84(C:/websites/Application.cfm:109) at cfApplication2ecfm1804277692.runPage(C:/websites/Application.cfm:1)

java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting expression to data type int.
	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 cfcoupon2ecfc831390934$funcSETCOUPONCOOKIE.runFunction(C:\websites\functions\coupon.cfc:619)
	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:643)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483)
	at cfApplication2ecfm1804277692._factor84(C:\websites\Application.cfm:109)
	at cfApplication2ecfm1804277692.runPage(C:\websites\Application.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:391)
	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:218)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	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)