Exception in onRequest

The action home:events.detail failed.

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver]The DBMS returned an unspecified error. The command code was 224. (Application)

Exception - struct
Detail [Macromedia][SQLServer JDBC Driver]The DBMS returned an unspecified error. The command code was 224.
ErrorCode [empty string]
ExtendedInfo SELECT [pages].[id] , [pages].[parentID] , [pages].[siteID] , [pages].[pageContainerID] , [pages].[refCode] , [pages].[legacyID] , [pages].[orderBy] , [pages].[isActive] , [pages].[createdAt] , [pages].[createdBy] , [pages].[isMenuItem] , [pages].[isDisplay] , [pages].[isChildAllowed] , [pages].[isDeleted] , [pages].[isGrid] , [pages].[keywords] , ( SELECT TOP 1 a.name FROM pageDetails a WHERE a.pageID = pages.id AND a.isPublished=1 ORDER BY createdAt DESC ) AS [name] , ( SELECT TOP 1 a.url FROM aliases a WHERE a.parentID = pages.id AND tableName='pages' ORDER BY createdAt DESC ) AS [aliasURL] , ( SELECT MAX(a.createdAt) FROM pageDetails a WHERE a.pageID = pages.id ) AS [updatedAt] , ( SELECT CASE WHEN isPublished = 0 THEN 'Draft' ELSE 'Published' END FROM pageDetails WHERE isDeleted = 0 AND id = (SELECT MIN(id) FROM pageDetails WHERE isDeleted = 0 AND pageID = pages.id AND propertyHash = (SELECT TOP 1 propertyHash FROM pageDetails WHERE isDeleted = 0 AND pageID=pages.id ORDER BY createdAt DESC)) ) AS [status] FROM [pages] WHERE 1 = 1 AND ([pages].[isDeleted] = 0 OR [pages].[isDeleted] IS NULL)
Message Error Executing Database Query.
StackTrace coldfusion.runtime.CustomException: Error Executing Database Query. at coldfusion.tagext.lang.ThrowTag.doStartTag(ThrowTag.java:142) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795) at cfDataMgrEngine_cf82ecfc1562024856$funcRUNSQLARRAY.runFunction(C:\home\mayfieldvillage.com\htdocs\includes\com\dataMgr\DataMgrEngine_cf8.cfc:99) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2620) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:488) at cf_DataMgr2ecfc2028342270$funcGETRECORDS.runFunction(C:\home\mayfieldvillage.com\htdocs\includes\com\dataMgr\_DataMgr.cfc:1102) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369) at cfobjectFactory2ecfc771050769$funcLIST.runFunction(C:\home\mayfieldvillage.com\htdocs\model\objectFactory.cfc:79) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369) at cfevents2ecfc127299084$funcBEFORE.runFunction(C:\home\mayfieldvillage.com\htdocs\home\controllers\events.cfc:9) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:402) at cffw12ecfc24284635$funcDOCONTROLLER.runFunction(C:\home\mayfieldvillage.com\htdocs\includes\com\fw1\fw1.cfc:1335) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655) at cffw12ecfc24284635$funcONREQUEST.runFunction(C:\home\mayfieldvillage.com\htdocs\includes\com\fw1\fw1.cfc:516) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:300) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:426) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) 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 sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:764) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:801) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) 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.valves.AccessLogValve.invoke(AccessLogValve.java:962) 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(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
Exception - array [empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFTHROW
LINE 99
RAW_TRACE at cfDataMgrEngine_cf82ecfc1562024856$funcRUNSQLARRAY.runFunction(C:\home\mayfieldvillage.com\htdocs\includes\com\dataMgr\DataMgrEngine_cf8.cfc:99)
TEMPLATE C:\home\mayfieldvillage.com\htdocs\includes\com\dataMgr\DataMgrEngine_cf8.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CFINVOKE
LINE 1102
RAW_TRACE at cf_DataMgr2ecfc2028342270$funcGETRECORDS.runFunction(C:\home\mayfieldvillage.com\htdocs\includes\com\dataMgr\_DataMgr.cfc:1102)
TEMPLATE C:\home\mayfieldvillage.com\htdocs\includes\com\dataMgr\_DataMgr.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 79
RAW_TRACE at cfobjectFactory2ecfc771050769$funcLIST.runFunction(C:\home\mayfieldvillage.com\htdocs\model\objectFactory.cfc:79)
TEMPLATE C:\home\mayfieldvillage.com\htdocs\model\objectFactory.cfc
TYPE CFML
4
Exception - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 9
RAW_TRACE at cfevents2ecfc127299084$funcBEFORE.runFunction(C:\home\mayfieldvillage.com\htdocs\home\controllers\events.cfc:9)
TEMPLATE C:\home\mayfieldvillage.com\htdocs\home\controllers\events.cfc
TYPE CFML
5
Exception - struct
COLUMN 0
ID CFINVOKE
LINE 1335
RAW_TRACE at cffw12ecfc24284635$funcDOCONTROLLER.runFunction(C:\home\mayfieldvillage.com\htdocs\includes\com\fw1\fw1.cfc:1335)
TEMPLATE C:\home\mayfieldvillage.com\htdocs\includes\com\fw1\fw1.cfc
TYPE CFML
6
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 516
RAW_TRACE at cffw12ecfc24284635$funcONREQUEST.runFunction(C:\home\mayfieldvillage.com\htdocs\includes\com\fw1\fw1.cfc:516)
TEMPLATE C:\home\mayfieldvillage.com\htdocs\includes\com\fw1\fw1.cfc
TYPE CFML
Type Application
code [empty string]
extended_info SELECT [pages].[id] , [pages].[parentID] , [pages].[siteID] , [pages].[pageContainerID] , [pages].[refCode] , [pages].[legacyID] , [pages].[orderBy] , [pages].[isActive] , [pages].[createdAt] , [pages].[createdBy] , [pages].[isMenuItem] , [pages].[isDisplay] , [pages].[isChildAllowed] , [pages].[isDeleted] , [pages].[isGrid] , [pages].[keywords] , ( SELECT TOP 1 a.name FROM pageDetails a WHERE a.pageID = pages.id AND a.isPublished=1 ORDER BY createdAt DESC ) AS [name] , ( SELECT TOP 1 a.url FROM aliases a WHERE a.parentID = pages.id AND tableName='pages' ORDER BY createdAt DESC ) AS [aliasURL] , ( SELECT MAX(a.createdAt) FROM pageDetails a WHERE a.pageID = pages.id ) AS [updatedAt] , ( SELECT CASE WHEN isPublished = 0 THEN 'Draft' ELSE 'Published' END FROM pageDetails WHERE isDeleted = 0 AND id = (SELECT MIN(id) FROM pageDetails WHERE isDeleted = 0 AND pageID = pages.id AND propertyHash = (SELECT TOP 1 propertyHash FROM pageDetails WHERE isDeleted = 0 AND pageID=pages.id ORDER BY createdAt DESC)) ) AS [status] FROM [pages] WHERE 1 = 1 AND ([pages].[isDeleted] = 0 OR [pages].[isDeleted] IS NULL)