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]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
 
The error occurred in D:\inetpub\wwwroot\Ehealth\commondev\congresses\index.cfm: line 9
7 : c.cgt_name#langcng# from congresses a, countries b, cngtopics c 
8 : where <!--- a.cng_language='#langcng#' and ---> a.cng_country=b.cnt_id and 
9 : a.cng_specialty=c.cgt_id and a.cng_enddate >=#now()# order by a.cng_startdate
10 : </CFQUERY>
11 : 

VENDORERRORCODE   242
SQLSTATE   22007
SQL    select a.cng_id, a.cng_name, a.cng_city, b.cnt_namept, a.cng_startdate, a.cng_enddate, c.cgt_namept from congresses a, countries b, cngtopics c where a.cng_country=b.cnt_id and a.cng_specialty=c.cgt_id and a.cng_enddate >={ts '2024-03-19 05:51:48'} order by a.cng_startdate
DATASOURCE   ehealthcommon
Resources:

Browser   claudebot
Remote Address   34.230.66.177
Referrer  
Date/Time   19-Mar-24 05:51 AM
Stack Trace
at cfindex2ecfm184306671.runPage(D:\inetpub\wwwroot\Ehealth\commondev\congresses\index.cfm:9) at cfindex2ecfm184306671.runPage(D:\inetpub\wwwroot\Ehealth\commondev\congresses\index.cfm:9)

java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
	at macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1229)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
	at coldfusion.sql.Executive.executeQuery(Executive.java:939)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533)
	at cfindex2ecfm184306671.runPage(D:\inetpub\wwwroot\Ehealth\commondev\congresses\index.cfm:9)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:87)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
	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:53)
	at coldfusion.CfmServlet.service(CfmServlet.java:200)
	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$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)