147.243.169.110
3.222.251.91
Application AquaAdminDev has encountered an error at 2/6/23 6:00:44 AM
Server: LAQ-AZ-WEB-01-D
Remote_Addr: 3.222.251.91
Event name: onRequestStart
Message: Event handler exception.
Exception - struct
Cause
Exception - struct
Cause
Exception - struct
ErrorCode 701
Message [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1892) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1601) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:5014) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4994) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4282) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4220) at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:286) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:561) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:460) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Exception - array[empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFQUERY
LINE 636
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CF_APPLICATIONROOT
LINE 546
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 75
RAW_TRACE at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75)
TEMPLATE C:\Websites\LiveAquaria\Application.cfc
TYPE CFML
Type java.sql.SQLException
DataSource AQUALIVE
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query.
ErrorCode HY000
Exceptions
Exception - array
1
Exception - struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query.
Message Error Executing Database Query.
NativeErrorCode 701
RootCause
Exception - struct
ErrorCode 701
Message [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1892) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1601) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:5014) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4994) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4282) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4220) at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:286) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:561) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:460) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Exception - array[empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFQUERY
LINE 636
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CF_APPLICATIONROOT
LINE 546
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 75
RAW_TRACE at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75)
TEMPLATE C:\Websites\LiveAquaria\Application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql UPDATE dbo.customers SET lastvisit = (param 1) WHERE cookieid = (param 2)
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:5014) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4994) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4282) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4220) at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:286) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:561) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:460) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1892) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1601) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 71 more
Suppressed
Exception - array[empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFQUERY
LINE 636
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CF_APPLICATIONROOT
LINE 546
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 75
RAW_TRACE at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75)
TEMPLATE C:\Websites\LiveAquaria\Application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query.
where (param 1) = [type='IN', class='java.sql.Date', value='2023-02-06', sqltype='CF_SQL_DATE'] , (param 2) = [type='IN', class='java.lang.String', value='7513E843-0963-3B7B-EBA7F668EA1AACD4', sqltype='CF_SQL_VARCHAR']
Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequestStart.
Message Event handler exception.
RootCause
Exception - struct
Cause
Exception - struct
ErrorCode 701
Message [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1892) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1601) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:5014) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4994) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4282) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4220) at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:286) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:561) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:460) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Exception - array[empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFQUERY
LINE 636
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CF_APPLICATIONROOT
LINE 546
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 75
RAW_TRACE at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75)
TEMPLATE C:\Websites\LiveAquaria\Application.cfc
TYPE CFML
Type java.sql.SQLException
DataSource AQUALIVE
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query.
ErrorCode HY000
Exceptions
Exception - array
1
Exception - struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query.
Message Error Executing Database Query.
NativeErrorCode 701
RootCause
Exception - struct
ErrorCode 701
Message [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1892) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1601) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:5014) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4994) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4282) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4220) at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:286) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:561) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:460) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Exception - array[empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFQUERY
LINE 636
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CF_APPLICATIONROOT
LINE 546
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 75
RAW_TRACE at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75)
TEMPLATE C:\Websites\LiveAquaria\Application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql UPDATE dbo.customers SET lastvisit = (param 1) WHERE cookieid = (param 2)
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:5014) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4994) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4282) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4220) at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:286) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:561) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:460) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1892) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1601) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 71 more
Suppressed
Exception - array[empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFQUERY
LINE 636
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CF_APPLICATIONROOT
LINE 546
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 75
RAW_TRACE at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75)
TEMPLATE C:\Websites\LiveAquaria\Application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query.
where (param 1) = [type='IN', class='java.sql.Date', value='2023-02-06', sqltype='CF_SQL_DATE'] , (param 2) = [type='IN', class='java.lang.String', value='7513E843-0963-3B7B-EBA7F668EA1AACD4', sqltype='CF_SQL_VARCHAR']
StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:294) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:561) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:460) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636) at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:5014) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4994) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4282) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4220) at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:286) ... 44 more Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1892) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1601) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 71 more
Suppressed
Exception - array[empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFQUERY
LINE 636
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART._factor3(C:\Websites\LiveAquaria\ApplicationRoot.cfc:636)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CF_APPLICATIONROOT
LINE 546
RAW_TRACE at cfApplicationRoot2ecfc1963614693$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\ApplicationRoot.cfc:546)
TEMPLATE C:\Websites\LiveAquaria\ApplicationRoot.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 75
RAW_TRACE at cfApplication2ecfc231576903$funcONREQUESTSTART.runFunction(C:\Websites\LiveAquaria\Application.cfc:75)
TEMPLATE C:\Websites\LiveAquaria\Application.cfc
TYPE CFML
Type Database
name onRequestStart

Request - struct
cfdumpinited true
cfdumpinitedforfunc FALSE
issecure TRUE
pageload_start 1675663242619
remote_addr 3.222.251.91
samesite_value [empty string]
truesiteid 1

Cookie - struct
AQUAEX 0
AQUAID 7513E843-0963-3B7B-EBA7F668EA1AACD4
AQUARM 0
CFID 309827752
CFTOKEN b49cfde52fc438ec-7513E83E-9F99-8FA5-41D5A8C56AFC7219

URL - struct [empty]

CGI - struct
AUTH_PASSWORD [empty string]
AUTH_TYPE [empty string]
AUTH_USER [empty string]
CERT_COOKIE [empty string]
CERT_FLAGS [empty string]
CERT_ISSUER [empty string]
CERT_KEYSIZE 256
CERT_SECRETKEYSIZE 2048
CERT_SERIALNUMBER [empty string]
CERT_SERVER_ISSUER C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
CERT_SERVER_SUBJECT CN=*.liveaquaria.com
CERT_SUBJECT [empty string]
CF_TEMPLATE_PATH C:\Websites\LiveAquaria\login.cfm
CONTENT_LENGTH 0
CONTENT_TYPE [empty string]
CONTEXT_PATH [empty string]
GATEWAY_INTERFACE CGI/1.1
HTTPS on
HTTPS_KEYSIZE 256
HTTPS_SECRETKEYSIZE 2048
HTTPS_SERVER_ISSUER C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECT CN=*.liveaquaria.com
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING br,gzip
HTTP_ACCEPT_LANGUAGE en-US,en;q=0.5
HTTP_CONNECTION [empty string]
HTTP_COOKIE [empty string]
HTTP_HOST dev.liveaquaria.com
HTTP_REFERER [empty string]
HTTP_URL /login.cfm
HTTP_USER_AGENT CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR 10.0.4.4
PATH_INFO [empty string]
PATH_TRANSLATED C:\Websites\LiveAquaria\login.cfm
QUERY_STRING [empty string]
REMOTE_ADDR 147.243.65.138
REMOTE_HOST 147.243.65.138
REMOTE_USER [empty string]
REQUEST_METHOD GET
SCRIPT_NAME /login.cfm
SERVER_NAME dev.liveaquaria.com
SERVER_PORT 443
SERVER_PORT_SECURE 1
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/10.0
WEB_SERVER_API [empty string]

Application - struct [Filtered - 9 of 67 keys hidden]
akamaiver 1803r1a
applicationname AquaAdminDev
bin_number 4227339
bisstoreopen true
blank_attribute_id 1
cardtypeids 1,2,3,4,5,6
cardtypes V,M,D,AX,BL,PP
catalogcodes
Application - query [Filtered - 9 of 67 keys hidden, 9 of 67 keys hidden]
  catalogcode
1 CN
2 DG
ccdkey dfslaetpe2007
cfversion 2021
cisvendor CISVENDORDEV
cisvendor2 CISVENDOR2DEV
cisvendor3 CISVENDOR3DEV
commerce_datasource DFSPROD
company_ip 147.243.169.110
cookiedomain .liveaquaria.com
datasource AQUALIVE
email
Application - struct
ADMINS IMISdept@drsfostersmith.com
ERRORS IMISdept@drsfostersmith.com
fake_promos 11,12
ichpimage /images/category/
importpath admin\QtyDiscountImport\archives
isadmin false
isdev true
isdevadmin false
isproduction false
isstaging false
isstagingadmin false
isuat false
isuatadmin false
lao2ods LAO2ODEV
lawebvendor LAWEBVENDORDEV
newsletterdatasource RESPONSYS
noreplymail No_Reply@liveaquaria.com
objfedex
Application - component CFC.la_Fedex
METHODS
CALLFEDEX
Application - function CallFedex
Arguments:
Name Required Type Default
Body Required any  
useURL Required any  
ReturnType: any
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
FEDEXDISPLAY
Application - function fedexDisplay
Arguments:
Name Required Type Default
objForm Required struct  
objFedex Required struct  
actionPage Required any  
device Optional any  
ReturnType: any
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint:  
Description:  
FEDEXMESSAGE
Application - function FedexMessage
Arguments:
Name Required Type Default
MessageId Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
FORMATFEDEXADDRESSVALIDATIONXML
Application - function FormatFedexAddressValidationXML
Arguments:none
ReturnType: any
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
GETPOSTALDISPLAYNAME
Application - function getPostalDisplayName
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
VALIDATEADDRESS
Application - function validateAddress
Arguments:
Name Required Type Default
Address1 Required string  
Address2 Required string  
city Required string  
state Required string  
zip Required string  
objFedex Required struct  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
VALIDATERESPONSE
Application - function ValidateResponse
Arguments:
Name Required Type Default
Response Required xml  
ReturnType: any
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
objiprodpush
Application - component CFC.la_iprod_codepush
METHODS
CALLFEDEX
Application - function CallFedex
Arguments:
Name Required Type Default
Body Required any  
useURL Required any  
ReturnType: any
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
CHECKSCAN
Application - function checkScan
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: checkScan * Trying to catch those who scan and push multiple instances simultaneously. HRM4010 in LA is worst offender. * First: Is this someone who is monitored? (checked in doScan) * Second: Does session.iProdPush exist? Special session struct for those who are monitored. * Third: Does doPush exists and is it TRUE. Or, is there an active pushID? * For now, sending myself an email with all the info i can send. Eventually, when process is refined, and * well tested, they will receive the commented message below and page execution will abort. * It would be entirely possible for a crash to happen or timeout and for them to wind up in this condition too. * The messaging should cover those times as well. ************************************************************************************************************ * Revision History: **********************************************************************************************************
Description:  
CLEARLOCALFILES
Application - function clearLocalFiles
Arguments:
Name Required Type Default
siteID Required numeric  
ReturnType: void
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
CLEARSESSIONVARS
Application - function clearSessionVars
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: clearSessionVars * Purpose: Wipe out a couple session vars when there is an error or push has finished. ************************************************************************************************************ * Revision History: * PH: 12.03.2012 Changed arg requirement. If not sent now, just clear the vars, no email. Also, deleting * entire iProdPush key instead of individuals. * PH: 12.26.2012 Removed the requirement of the arg strMsg. If arg is passed, it will be available in * the arguments array as Arguments[1] * PH: 08.14.2013 Remove debug mailer and commented code no longer needed **********************************************************************************************************
Description:  
CREATEFILEDIRECTORY
Application - function CreateFileDirectory
Arguments:
Name Required Type Default
path Required string  
ReturnType: Any
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
DISPLAYSTATUS
Application - function DisplayStatus
Arguments:
Name Required Type Default
status Required string  
ReturnType: Any
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint:  
Description:  
DOABORT
Application - function doAbort
Arguments:none
ReturnType: void
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint: Simple cfabort because cf8 doesn't support that, soon in cf10
Description:  
DOSCAN
Application - function doScan
Arguments:
Name Required Type Default
pushTypeID Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: doScan - Kind of like main(): Now that we're getting rid of javascript in the files we * can possibly do more in functions. This was all in push_code_scan.cfm ************************************************************************************************************ * Revision History: * PH: 12.13.2012 New * PH: 08.14.2013 Removed test for my userid if scan is already in progress **********************************************************************************************************
Description:  
FEDEXDISPLAY
Application - function fedexDisplay
Arguments:
Name Required Type Default
objForm Required struct  
objFedex Required struct  
actionPage Required any  
device Optional any  
ReturnType: any
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint:  
Description:  
FEDEXMESSAGE
Application - function FedexMessage
Arguments:
Name Required Type Default
MessageId Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
FORMATFEDEXADDRESSVALIDATIONXML
Application - function FormatFedexAddressValidationXML
Arguments:none
ReturnType: any
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
GETCOMMONSTRDEBUG
Application - function getCommonStrDebug
Arguments:none
ReturnType: string
Roles:  
Access: public
Static: false
Output: TRUE
DisplayName:  
Hint: Gather common info needed in emailers and dumps
Description:  
GETDESTINATIONSERVERS
Application - function getDestinationServers
Arguments:
Name Required Type Default
nSiteID Required numeric  
ReturnType: query
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint: Get destination servers to push files to.
Description:  
GETFILES
Application - function GetFiles
Arguments:
Name Required Type Default
qListing Required query  
fileTypes Required string  
ReturnType: query
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
GETFOLDERS
Application - function getfolders
Arguments:
Name Required Type Default
qlisting Required query  
ReturnType: query
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: Query the directory listing results for directories only.
Description:  
GETPOSTALDISPLAYNAME
Application - function getPostalDisplayName
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
GETPUSHID
Application - function getPushID
Arguments:none
ReturnType: numeric
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint: Insert into imis_cp_pushes and then get the pushid.
Description:  
GETPUSHSTATUS
Application - function getPushStatus
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: getPushStatus * Purpose: Gets status of the push from session.iProdPush.doPush, if defined ************************************************************************************************************ * Revision History: **********************************************************************************************************
Description:  
GETPUSHTYPE
Application - function getPushType
Arguments:
Name Required Type Default
pushTypeID Required numeric  
ReturnType: query
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint: Query to get the push types.
Description:  
GETPUSHTYPEINFO
Application - function getPushTypeInfo
Arguments:
Name Required Type Default
nPushTypeID Required numeric  
ReturnType: query
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint: Query to get the push types.
Description:  
IMGPUSHEMAILER
Application - function imgPushEmailer
Arguments:
Name Required Type Default
anyTypeArg Required any  
ReturnType: void
Roles:  
Access: public
Static: false
Output: TRUE
DisplayName:  
Hint: Emailer sent a dump(query/struct/other) or a status string during image scan and push.
Description:  
INSERTAUTOPUSHFILE
Application - function insertAutoPushFile
Arguments:
Name Required Type Default
path Required string  
lastmodified Required numeric  
siteid Required numeric  
pushid Required numeric  
ReturnType: void
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
INSERTPUSHDIRORFILE
Application - function insertPushDirOrFile
Arguments:
Name Required Type Default
path Required string  
lastmodified Required numeric  
is_directory Required numeric  
siteid Required numeric  
local Required numeric  
pushid Required numeric  
ReturnType: void
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
ISGOODDIR
Application - function isGoodDir
Arguments:
Name Required Type Default
subDir Optional Any  
ignoreDirs Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: isGoodDir * Purpose: This is a rewrite of IsGoodDirs. Not looping over a list, using listContains. * Check to see if a directory is in a list of ignore dirs. If matched, return FALSE, isGoodDir means * a directory we're going to traverse. We don't scan ignored directories. Root arg no longer required, * need only compare with subdir. ************************************************************************************************************ * Revision History: **********************************************************************************************************
Description:  
ISPUSHMONITORED
Application - function isPushMonitored
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: isPushMonitored * Purpose: Users, push types, and push groups to monitor. Return boolean ************************************************************************************************************ * Revision History: * PH: 01.15.2013 Stopped the monitoring of Lin * PH: 08.14.2013 Removed test for my userid **********************************************************************************************************
Description:  
PUSHHOLDIMAGESLIVE
Application - function pushHoldImagesLive
Arguments:
Name Required Type Default
nPushTypeID Required numeric  
nSiteID Required numeric  
bDeleteFiles Optional boolean TRUE
bFlushAkamai Optional boolean TRUE
ReturnType: boolean
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint: The main process for pushing images from the temp holding area live
Description:  
SCANDIRECTORY
Application - function scanDirectory
Arguments:
Name Required Type Default
root Required string  
subDir Required string  
fileTypes Required string  
ignoreDirList Required string  
siteID Required numeric  
startDir Required string  
pushID Required numeric  
ReturnType: boolean
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint:  
Description:  
VALIDATEADDRESS
Application - function validateAddress
Arguments:
Name Required Type Default
Address1 Required string  
Address2 Required string  
city Required string  
state Required string  
zip Required string  
objFedex Required struct  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
VALIDATERESPONSE
Application - function ValidateResponse
Arguments:
Name Required Type Default
Response Required xml  
ReturnType: any
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
WRITETASKDIARY
Application - function writeTaskDiary
Arguments:
Name Required Type Default
sUserName Required string  
sStartDir Required string  
lstServers Required string  
lstFiles Required string  
nTaskID Optional numeric 3
ReturnType: boolean
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint: The main process for pushing images from the temp holding area live
Description:  
paytypes
Application - struct
loyaltyReward RWD
primaryadminservername LAQ-AZ-WEB-02-D
purgebearertoken [empty string]
purgebearertokenexpireon [empty string]
rewardspercentage 0.05
rootdirpath C:\Websites\liveaquaria\
rootdrive C
rootimagepath C:\Websites\liveaquaria\images/
rootwebpath https://dev.liveaquaria.com
rootwebpathsecure https://dev.liveaquaria.com
searchcollection aqua
searchexception_list 1~89360
searchexeption_time {ts '2023-02-06 05:52:54'}
servername LAQ-AZ-WEB-01-D
siteidentifier LA
subtotal_promos 1,2,5,8
testccnums 4444444444444448,4444424444444440,4444414444444441,4055011111111111,5500005555555559,5555555555555557,5454545454545454,5555515555555551,5405222222222226,5478050000000007,371449635398431,343434343434343,6011000995500000,6500000000000002,4112344112344113,4110144110144115,4114360123456785,4061724061724061,5111005111051128,5112345112345114,5115915115915118,5116601234567894,371144371144376,341134113411347,6011016011016011,6559906559906557,2221000000000000,2321000000000008,2421000000000007,2521000000000006,2621000000000005,2720990000000007,341134113411347,3528000000000000,3528000000000007,36110361103612,4112344112344110,4112344112344113,4257021111111116,5112345112345110,5112345112345114,5193911111111110,5193911111111112,6011016011016010,6011016011016011,6559906559906550,6559906559906557,4788250000028291,4159280000000009,4485536666666663,5132850000000008,5567356006664742,373953192351004,6011212100000087,6011020000045098,6011260000004923,6011740000227905,6011780000241118,6011869900245897,6499999900149475,36438999960016,3059990000000022,3095000000000018,36259600000012,3899990000000026,3566002020140006,3566007770019573,9999999800002773,9799012345678,8268261234567890,9309301234567890,6048860001284072,6064690002287454,5892971305421622591,4536055022727704,4536055022923204,5892971305421622591,5007660674462513,5007660674462521
topsdata TOPSDATAPROD
topsjsonendpoint http://172.18.196.215:9193/TEST/subroutine/
total_promos 3,4,6,7,9,10
urlhelper
Application - component CFC.la_url_helper
METHODS
ARTICLEURL
Application - function articleURL
Arguments:
Name Required Type Default
articleTitle Optional Any  
articleId Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
BASECATEGORYURL
Application - function baseCategoryURL
Arguments:
Name Required Type Default
categoryName Optional Any  
categoryId Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
CALLFEDEX
Application - function CallFedex
Arguments:
Name Required Type Default
Body Required any  
useURL Required any  
ReturnType: any
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
CATEGORYURL
Application - function categoryURL
Arguments:
Name Required Type Default
categoryName Optional Any  
categoryIds Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
CHECKSCAN
Application - function checkScan
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: checkScan * Trying to catch those who scan and push multiple instances simultaneously. HRM4010 in LA is worst offender. * First: Is this someone who is monitored? (checked in doScan) * Second: Does session.iProdPush exist? Special session struct for those who are monitored. * Third: Does doPush exists and is it TRUE. Or, is there an active pushID? * For now, sending myself an email with all the info i can send. Eventually, when process is refined, and * well tested, they will receive the commented message below and page execution will abort. * It would be entirely possible for a crash to happen or timeout and for them to wind up in this condition too. * The messaging should cover those times as well. ************************************************************************************************************ * Revision History: **********************************************************************************************************
Description:  
CLEARLOCALFILES
Application - function clearLocalFiles
Arguments:
Name Required Type Default
siteID Required numeric  
ReturnType: void
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
CLEARSESSIONVARS
Application - function clearSessionVars
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: clearSessionVars * Purpose: Wipe out a couple session vars when there is an error or push has finished. ************************************************************************************************************ * Revision History: * PH: 12.03.2012 Changed arg requirement. If not sent now, just clear the vars, no email. Also, deleting * entire iProdPush key instead of individuals. * PH: 12.26.2012 Removed the requirement of the arg strMsg. If arg is passed, it will be available in * the arguments array as Arguments[1] * PH: 08.14.2013 Remove debug mailer and commented code no longer needed **********************************************************************************************************
Description:  
COLLECTORSCORNERURL
Application - function collectorsCornerURL
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
CREATEFILEDIRECTORY
Application - function CreateFileDirectory
Arguments:
Name Required Type Default
path Required string  
ReturnType: Any
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
DISPLAYSTATUS
Application - function DisplayStatus
Arguments:
Name Required Type Default
status Required string  
ReturnType: Any
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint:  
Description:  
DIVERSDENCATEGORYURL
Application - function diversDenCategoryURL
Arguments:
Name Required Type Default
categoryName Optional Any  
categoryId Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
DIVERSDENINDEXURL
Application - function diversDenIndexURL
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
DIVERSDENPRODUCTURL
Application - function diversDenProductURL
Arguments:
Name Required Type Default
productName Optional Any  
productId Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
DOABORT
Application - function doAbort
Arguments:none
ReturnType: void
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint: Simple cfabort because cf8 doesn't support that, soon in cf10
Description:  
DOSCAN
Application - function doScan
Arguments:
Name Required Type Default
pushTypeID Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: doScan - Kind of like main(): Now that we're getting rid of javascript in the files we * can possibly do more in functions. This was all in push_code_scan.cfm ************************************************************************************************************ * Revision History: * PH: 12.13.2012 New * PH: 08.14.2013 Removed test for my userid if scan is already in progress **********************************************************************************************************
Description:  
FEDEXDISPLAY
Application - function fedexDisplay
Arguments:
Name Required Type Default
objForm Required struct  
objFedex Required struct  
actionPage Required any  
device Optional any  
ReturnType: any
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint:  
Description:  
FEDEXMESSAGE
Application - function FedexMessage
Arguments:
Name Required Type Default
MessageId Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
FORMATFEDEXADDRESSVALIDATIONXML
Application - function FormatFedexAddressValidationXML
Arguments:none
ReturnType: any
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
GETCOMMONSTRDEBUG
Application - function getCommonStrDebug
Arguments:none
ReturnType: string
Roles:  
Access: public
Static: false
Output: TRUE
DisplayName:  
Hint: Gather common info needed in emailers and dumps
Description:  
GETDESTINATIONSERVERS
Application - function getDestinationServers
Arguments:
Name Required Type Default
nSiteID Required numeric  
ReturnType: query
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint: Get destination servers to push files to.
Description:  
GETFILES
Application - function GetFiles
Arguments:
Name Required Type Default
qListing Required query  
fileTypes Required string  
ReturnType: query
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
GETFOLDERS
Application - function getfolders
Arguments:
Name Required Type Default
qlisting Required query  
ReturnType: query
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: Query the directory listing results for directories only.
Description:  
GETPOSTALDISPLAYNAME
Application - function getPostalDisplayName
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
GETPUSHID
Application - function getPushID
Arguments:none
ReturnType: numeric
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint: Insert into imis_cp_pushes and then get the pushid.
Description:  
GETPUSHSTATUS
Application - function getPushStatus
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: getPushStatus * Purpose: Gets status of the push from session.iProdPush.doPush, if defined ************************************************************************************************************ * Revision History: **********************************************************************************************************
Description:  
GETPUSHTYPE
Application - function getPushType
Arguments:
Name Required Type Default
pushTypeID Required numeric  
ReturnType: query
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint: Query to get the push types.
Description:  
GETPUSHTYPEINFO
Application - function getPushTypeInfo
Arguments:
Name Required Type Default
nPushTypeID Required numeric  
ReturnType: query
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint: Query to get the push types.
Description:  
IMGPUSHEMAILER
Application - function imgPushEmailer
Arguments:
Name Required Type Default
anyTypeArg Required any  
ReturnType: void
Roles:  
Access: public
Static: false
Output: TRUE
DisplayName:  
Hint: Emailer sent a dump(query/struct/other) or a status string during image scan and push.
Description:  
INSERTAUTOPUSHFILE
Application - function insertAutoPushFile
Arguments:
Name Required Type Default
path Required string  
lastmodified Required numeric  
siteid Required numeric  
pushid Required numeric  
ReturnType: void
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
INSERTPUSHDIRORFILE
Application - function insertPushDirOrFile
Arguments:
Name Required Type Default
path Required string  
lastmodified Required numeric  
is_directory Required numeric  
siteid Required numeric  
local Required numeric  
pushid Required numeric  
ReturnType: void
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
ISGOODDIR
Application - function isGoodDir
Arguments:
Name Required Type Default
subDir Optional Any  
ignoreDirs Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: isGoodDir * Purpose: This is a rewrite of IsGoodDirs. Not looping over a list, using listContains. * Check to see if a directory is in a list of ignore dirs. If matched, return FALSE, isGoodDir means * a directory we're going to traverse. We don't scan ignored directories. Root arg no longer required, * need only compare with subdir. ************************************************************************************************************ * Revision History: **********************************************************************************************************
Description:  
ISPUSHMONITORED
Application - function isPushMonitored
Arguments:none
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint: ********************************************************************************************************* * Function: isPushMonitored * Purpose: Users, push types, and push groups to monitor. Return boolean ************************************************************************************************************ * Revision History: * PH: 01.15.2013 Stopped the monitoring of Lin * PH: 08.14.2013 Removed test for my userid **********************************************************************************************************
Description:  
PRODUCTURL
Application - function productURL
Arguments:
Name Required Type Default
productName Optional Any  
productId Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
PUSHHOLDIMAGESLIVE
Application - function pushHoldImagesLive
Arguments:
Name Required Type Default
nPushTypeID Required numeric  
nSiteID Required numeric  
bDeleteFiles Optional boolean TRUE
bFlushAkamai Optional boolean TRUE
ReturnType: boolean
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint: The main process for pushing images from the temp holding area live
Description:  
SCANDIRECTORY
Application - function scanDirectory
Arguments:
Name Required Type Default
root Required string  
subDir Required string  
fileTypes Required string  
ignoreDirList Required string  
siteID Required numeric  
startDir Required string  
pushID Required numeric  
ReturnType: boolean
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint:  
Description:  
SLUGIFY
Application - function slugify
Arguments:
Name Required Type Default
str Optional Any  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
VALIDATEADDRESS
Application - function validateAddress
Arguments:
Name Required Type Default
Address1 Required string  
Address2 Required string  
city Required string  
state Required string  
zip Required string  
objFedex Required struct  
ReturnType: Any
Roles:  
Access: public
Static: false
Output:  
DisplayName:  
Hint:  
Description:  
VALIDATERESPONSE
Application - function ValidateResponse
Arguments:
Name Required Type Default
Response Required xml  
ReturnType: any
Roles:  
Access: public
Static: false
Output: false
DisplayName:  
Hint:  
Description:  
WRITETASKDIARY
Application - function writeTaskDiary
Arguments:
Name Required Type Default
sUserName Required string  
sStartDir Required string  
lstServers Required string  
lstFiles Required string  
nTaskID Optional numeric 3
ReturnType: boolean
Roles:  
Access: public
Static: false
Output: true
DisplayName:  
Hint: The main process for pushing images from the temp holding area live
Description:  
widecart true
xmlserverip 172.18.195.103