skip navigation
Left Navigation Links

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 int to data type numeric.
 
The error occurred in E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm: line 97
Called from E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm: line 5
Called from E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm: line 1
Called from E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm: line 97
Called from E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm: line 5
Called from E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm: line 1
95 : 	
96 : 	<!--- Top ranked --->
97 :     	<cfquery datasource="lessonPlansPublic" name="topRanked">
98 :             select top 5
99 :             lesson_rating.lessonID,

VENDORERRORCODE   8115
SQLSTATE   22001
SQL    select top 5 lesson_rating.lessonID, lessons.title, ( (lesson_rating.oneCount) + (2*lesson_rating.twoCount) + (3*lesson_rating.threeCount) + (4*lesson_rating.fourCount) + (5*lesson_rating.fiveCount) ) /convert(decimal(4,2), voteTalley) as weightedAverage from lesson_rating inner join lessons on lesson_rating.lessonID = lessons.id order by weightedAverage desc
DATASOURCE   lessonPlansPublic
Resources:

Browser   Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
Remote Address   10.102.82.121
Referrer   http://oeisint03:81/kids/teachers/siteInformation/
Date/Time   04-Sep-16 10:41 AM
Stack Trace
at cf4042ecfm1798309823._factor7(E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm:97) at cf4042ecfm1798309823._factor8(E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm:5) at cf4042ecfm1798309823.runPage(E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm:1) at cf4042ecfm1798309823._factor7(E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm:97) at cf4042ecfm1798309823._factor8(E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm:5) at cf4042ecfm1798309823.runPage(E:/usmint/website/OMSII/kids/teachers/lessonPlans/404.cfm:1)

java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting int to data type numeric.
	at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.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.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.l(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1364)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1127)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1058)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cf4042ecfm1798309823._factor7(E:\usmint\website\OMSII\kids\teachers\lessonPlans\404.cfm:97)
	at cf4042ecfm1798309823._factor8(E:\usmint\website\OMSII\kids\teachers\lessonPlans\404.cfm:5)
	at cf4042ecfm1798309823.runPage(E:\usmint\website\OMSII\kids\teachers\lessonPlans\404.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:399)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	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:201)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)