| exception - struct |
|---|
| DataSource |
dbGANew |
| Detail |
[Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error |
| ErrorCode |
08S01 |
| Message |
Error Executing Database Query. |
| NativeErrorCode |
0 |
| RootCause |
| exception - struct |
|---|
| ErrorCode |
0 |
| Message |
[Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error |
| SQLState |
08S01 |
| StackTrace |
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSExecuteRequest.submitRequest(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.execute(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.java:719)
at coldfusion.sql.Executive.executeQuery(Executive.java:652)
at coldfusion.sql.Executive.executeQuery(Executive.java:613)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:694)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495)
at cfcountrySearch2ecfc1780980562$funcGETFASTFINDDATA.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\seo\countrySearch.cfc:226)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:370)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:156)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594)
at cflocation_search2ecfm175388649._factor8(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:237)
at cflocation_search2ecfm175388649._factor12(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:235)
at cflocation_search2ecfm175388649.runPage(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:203)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:168)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| exception - array
|
|---|
| 1 |
| exception - struct |
|---|
| COLUMN |
0 |
| ID |
CFQUERY |
| LINE |
226 |
| RAW_TRACE |
at cfcountrySearch2ecfc1780980562$funcGETFASTFINDDATA.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\seo\countrySearch.cfc:226) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\seo\countrySearch.cfc |
| TYPE |
CFML |
|
| 2 |
| exception - struct |
|---|
| COLUMN |
0 |
| ID |
CF_TEMPLATEPROXY |
| LINE |
237 |
| RAW_TRACE |
at cflocation_search2ecfm175388649._factor8(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:237) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm |
| TYPE |
CFML |
|
| 3 |
| exception - struct |
|---|
| COLUMN |
0 |
| ID |
CF_LOCATION_SEARCH |
| LINE |
235 |
| RAW_TRACE |
at cflocation_search2ecfm175388649._factor12(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:235) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm |
| TYPE |
CFML |
|
| 4 |
| exception - struct |
|---|
| COLUMN |
0 |
| ID |
CF_LOCATION_SEARCH |
| LINE |
1 |
| RAW_TRACE |
at cflocation_search2ecfm175388649.runPage(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:1) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm |
| TYPE |
CFML |
|
|
| Type |
java.sql.SQLException |
|
| SQLState |
08S01 |
| Sql |
SELECT wdFeature.FeatureID as proximity, wdFeature.Feature_str_name, wdAdmin.adminID as stateList, wdAdmin.Admin1_str_name, wdCountry.countryID,
wdCountry.Country_str_name
FROM wdFeature WITH (NOLOCK) INNER JOIN
wdAdmin WITH (NOLOCK) ON wdFeature.adminid = wdAdmin.adminID INNER JOIN
wdCountry WITH (NOLOCK) ON wdFeature.countryid = wdCountry.countryID
WHERE (wdAdmin.Admin1_str_name = 'Zurich') AND (wdFeature.Feature_str_name = 'Adliswil')
ORDER BY wdCountry.Country_str_name, wdAdmin.Admin1_str_name, wdFeature.Feature_str_name
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:579)
at cfcountrySearch2ecfc1780980562$funcGETFASTFINDDATA.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\seo\countrySearch.cfc:226)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:370)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:156)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594)
at cflocation_search2ecfm175388649._factor8(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:237)
at cflocation_search2ecfm175388649._factor12(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:235)
at cflocation_search2ecfm175388649.runPage(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:203)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:168)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| exception - array
|
|---|
| 1 |
| exception - struct |
|---|
| COLUMN |
0 |
| ID |
CFQUERY |
| LINE |
226 |
| RAW_TRACE |
at cfcountrySearch2ecfc1780980562$funcGETFASTFINDDATA.runFunction(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\seo\countrySearch.cfc:226) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\components\seo\countrySearch.cfc |
| TYPE |
CFML |
|
| 2 |
| exception - struct |
|---|
| COLUMN |
0 |
| ID |
CF_TEMPLATEPROXY |
| LINE |
237 |
| RAW_TRACE |
at cflocation_search2ecfm175388649._factor8(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:237) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm |
| TYPE |
CFML |
|
| 3 |
| exception - struct |
|---|
| COLUMN |
0 |
| ID |
CF_LOCATION_SEARCH |
| LINE |
235 |
| RAW_TRACE |
at cflocation_search2ecfm175388649._factor12(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:235) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm |
| TYPE |
CFML |
|
| 4 |
| exception - struct |
|---|
| COLUMN |
0 |
| ID |
CF_LOCATION_SEARCH |
| LINE |
1 |
| RAW_TRACE |
at cflocation_search2ecfm175388649.runPage(C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm:1) |
| TEMPLATE |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm |
| TYPE |
CFML |
|
|
| Type |
Database |
| queryError |
[Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error |
| where |
[empty string] |
[empty string]
| 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 |
[empty string] |
| CERT_SECRETKEYSIZE |
[empty string] |
| CERT_SERIALNUMBER |
[empty string] |
| CERT_SERVER_ISSUER |
[empty string] |
| CERT_SERVER_SUBJECT |
[empty string] |
| CERT_SUBJECT |
[empty string] |
| CF_TEMPLATE_PATH |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm |
| CONTENT_LENGTH |
[empty string] |
| CONTENT_TYPE |
[empty string] |
| CONTEXT_PATH |
[empty string] |
| GATEWAY_INTERFACE |
[empty string] |
| HTTPS |
[empty string] |
| HTTPS_KEYSIZE |
[empty string] |
| HTTPS_SECRETKEYSIZE |
[empty string] |
| HTTPS_SERVER_ISSUER |
[empty string] |
| HTTPS_SERVER_SUBJECT |
[empty string] |
| HTTP_ACCEPT |
text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5 |
| HTTP_ACCEPT_ENCODING |
gzip |
| HTTP_ACCEPT_LANGUAGE |
en-us,en;q=0.5 |
| HTTP_CONNECTION |
Keep-Alive |
| HTTP_COOKIE |
ARPT=MJVXQRSapp25CKIUM; CFID=34570341; CFTOKEN=b83b451182c2ed16-82B7FAF4-B589-C9CE-3BAB24CFFD909F8A; JSESSIONID=56302131551337927924468 |
| HTTP_HOST |
192.168.3.253:8104 |
| HTTP_REFERER |
[empty string] |
| HTTP_USER_AGENT |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| PATH_INFO |
[empty string] |
| PATH_TRANSLATED |
C:\JRun4\servers\APP25\cfusion-ear\cfusion-war\SEO_URL\location_search.cfm |
| QUERY_STRING |
modifier=aupair-nanny-jobs&SEOkeyword=Zurich/Adliswil |
| REMOTE_ADDR |
192.168.3.3 |
| REMOTE_HOST |
phoenix2.intelimark.local |
| REMOTE_USER |
[empty string] |
| REQUEST_METHOD |
GET |
| SCRIPT_NAME |
/SEO_URL/location_search.cfm |
| SERVER_NAME |
192.168.3.253 |
| SERVER_PORT |
8504 |
| SERVER_PORT_SECURE |
0 |
| SERVER_PROTOCOL |
HTTP/1.1 |
| SERVER_SOFTWARE |
[empty string] |
| WEB_SERVER_API |
[empty string] |