| exception - struct |
| DataSource |
dbGANew |
| Detail |
[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting date and/or time from character string. |
| ErrorCode |
22007 |
| Message |
Error Executing Database Query. |
| NativeErrorCode |
241 |
| RootCause |
| exception - struct |
| ErrorCode |
241 |
| Message |
[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting date and/or time from character string. |
| SQLState |
22007 |
| StackTrace |
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting date and/or time from character string.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.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.tds.TDSRequest.getRow(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplResultSet.fetchAtPosition(Unknown Source)
at macromedia.jdbc.base.BaseImplResultSet.next(Unknown Source)
at macromedia.jdbc.base.BaseResultSet.next(Unknown Source)
at coldfusion.sql.QueryTable.populate(QueryTable.java:287)
at coldfusion.sql.QueryTable.populate(QueryTable.java:216)
at coldfusion.sql.Executive.getRowSet(Executive.java:310)
at coldfusion.sql.Executive.executeQuery(Executive.java:719)
at coldfusion.sql.Executive.executeQuery(Executive.java:652)
at coldfusion.sql.Executive.executeQuery(Executive.java:613)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:694)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495)
at cfUtils2ecfc1374729316$funcCHECKUSERBLOCKS.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\Utils.cfc:927)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:370)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:156)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594)
at cfApplication2ecfc259910724$funcONREQUESTSTART.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\Application.cfc:116)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:173)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:192)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:145)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:74)
at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:162)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:194)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:168)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| exception - array
|
| 1 |
| exception - struct |
| COLUMN |
0 |
| ID |
CFQUERY |
| LINE |
927 |
| RAW_TRACE |
at cfUtils2ecfc1374729316$funcCHECKUSERBLOCKS.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\Utils.cfc:927) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\Utils.cfc |
| TYPE |
CFML |
|
| 2 |
| exception - struct |
| COLUMN |
0 |
| ID |
CF_TEMPLATEPROXY |
| LINE |
116 |
| RAW_TRACE |
at cfApplication2ecfc259910724$funcONREQUESTSTART.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\Application.cfc:116) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\Application.cfc |
| TYPE |
CFML |
|
|
| Type |
java.sql.SQLException |
|
| SQLState |
22007 |
| Sql |
SELECT emailAddress, MemberID, DateAdded
FROM EmailBlock
WHERE DateAdded > '
02/02/2012'
order by dateadded desc
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:579)
at cfUtils2ecfc1374729316$funcCHECKUSERBLOCKS.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\Utils.cfc:927)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:370)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:156)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594)
at cfApplication2ecfc259910724$funcONREQUESTSTART.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\Application.cfc:116)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:173)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:192)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:145)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:74)
at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:162)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:194)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:168)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| exception - array
|
| 1 |
| exception - struct |
| COLUMN |
0 |
| ID |
CFQUERY |
| LINE |
927 |
| RAW_TRACE |
at cfUtils2ecfc1374729316$funcCHECKUSERBLOCKS.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\Utils.cfc:927) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\Utils.cfc |
| TYPE |
CFML |
|
| 2 |
| exception - struct |
| COLUMN |
0 |
| ID |
CF_TEMPLATEPROXY |
| LINE |
116 |
| RAW_TRACE |
at cfApplication2ecfc259910724$funcONREQUESTSTART.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\Application.cfc:116) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\Application.cfc |
| TYPE |
CFML |
|
|
| Type |
Database |
| queryError |
[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting date and/or time from character string. |
| where |
[empty string] |