| struct | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| DataSource | frsRO | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| Detail | [Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| ErrorCode | 08S01 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| Exceptions |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Message | Error Executing Database Query. | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| NativeErrorCode | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| RootCause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQLState | 08S01 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sql | select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup' | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| StackTrace | coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfagpub_client_defines2ecfm1929192588.runPage(D:\inetpub\PublicPages\agpub_client_defines.cfm:162) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851) at cfApplication2ecfm1078442396.runPage(D:\inetpub\PublicPages\Application.cfm:111) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:401) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) 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:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) 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:52) 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:200) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:356) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:544) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddg.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.dda4.h(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) ... 51 more | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| Suppressed |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| TagContext |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Type | Database | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| queryError | [Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| where | [empty string] | ||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Debugging Information
Execution Time
Exceptions 17:53:51.051 - Database Exception - in D:/inetpub/PublicPages/agpub_client_defines.cfm : line 162
Error Executing Database Query. Scope Variables CGI Variables: AUTH_PASSWORD= AUTH_TYPE= AUTH_USER= CERT_COOKIE= CERT_FLAGS= CERT_ISSUER= CERT_KEYSIZE= CERT_SECRETKEYSIZE= CERT_SERIALNUMBER= CERT_SERVER_ISSUER= CERT_SERVER_SUBJECT= CERT_SUBJECT= CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm CONTENT_LENGTH=0 CONTENT_TYPE= CONTEXT_PATH= GATEWAY_INTERFACE=CGI/1.1 HTTPS=off HTTPS_KEYSIZE= HTTPS_SECRETKEYSIZE= HTTPS_SERVER_ISSUER= HTTPS_SERVER_SUBJECT= HTTP_ACCEPT=*/* HTTP_ACCEPT_ENCODING= HTTP_ACCEPT_LANGUAGE= HTTP_CONNECTION=Keep-Alive HTTP_COOKIE= HTTP_HOST=10.20.10.48:8555 HTTP_REFERER= HTTP_URL=//agenda_publish.cfm?id=&mt=ALL&get_month=5&get_year=2019&dsp=min&seq=878 HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) LOCAL_ADDR=10.20.10.48 PATH_INFO= PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm QUERY_STRING=id=&mt=ALL&get_month=5&get_year=2019&dsp=min&seq=878 REMOTE_ADDR=10.20.230.5 REMOTE_HOST=10.20.230.5 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/agenda_publish.cfm SERVER_NAME=10.20.10.48 SERVER_PORT=8555 SERVER_PORT_SECURE=0 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/10.0 WEB_SERVER_API= Client Variables:
cfid=9438311
cftoken=6d4f4b0112af0ce3-23BE1D92-01CD-79BA-77B75D44C1DF4029
hitcount=2
lastvisit={ts '2024-05-01 17:53:51'}
timecreated={ts '2024-05-01 17:53:51'}
urltoken=CFID=9438311&CFTOKEN=6d4f4b0112af0ce3-23BE1D92-01CD-79BA-77B75D44C1DF4029
Cookie Variables: CFID=9438311 CFTOKEN=6d4f4b0112af0ce3-23BE1D92-01CD-79BA-77B75D44C1DF4029 Session Variables: cfid=9438311 cftoken=6d4f4b0112af0ce3-23BE1D92-01CD-79BA-77B75D44C1DF4029 dbtype=SQLSERVER dsn=frsRO extpathprefix=/public/ isexternal=true logfilepath=d:\logs\ loggedin=false sessionid=FASPUBLIC_9438311_6d4f4b0112af0ce3-23BE1D92-01CD-79BA-77B75D44C1DF4029 subdir=/public/ urltoken=CFID=9438311&CFTOKEN=6d4f4b0112af0ce3-23BE1D92-01CD-79BA-77B75D44C1DF4029 URL Parameters: dsp=min get_month=5 get_year=2019 id= mt=ALL seq=878Debug Rendering Time: 15 ms |
||||||||||||||||||||||||||||||||||