Catch
Entries: 16
additional
Struct (ordered)
Cause
Catch
additional
Struct (ordered)
Detail
string
ErrorCode
number0
Extended_Info
string
ExtendedInfo
string
Message
stringThe TCP/IP connection to the host or-prf1-mssql-db1.cj5wyoimya0c.us-west-2.rds.amazonaws.com, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
SQLState
string08S01
StackTrace
stringlucee.runtime.exp.NativeException: The TCP/IP connection to the host or-prf1-mssql-db1.cj5wyoimya0c.us-west-2.rds.amazonaws.com, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:231) at com.microsoft.sqlserver.jdbc.SQLServerException.convertConnectExceptionToSQLServerException(SQLServerException.java:282) at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2578) at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:719) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3523) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:3172) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:3014) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1836) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1246) at lucee.runtime.db.DataSourceSupport._getConnection(DataSourceSupport.java:135) at lucee.runtime.db.DataSourceSupport.getConnection(DataSourceSupport.java:103) at lucee.runtime.db.DatasourceConnectionPool.loadDatasourceConnection(DatasourceConnectionPool.java:158) at lucee.runtime.db.DatasourceConnectionPool.getDatasourceConnection(DatasourceConnectionPool.java:121) at lucee.runtime.db.DatasourceManagerImpl.getConnection(DatasourceManagerImpl.java:82) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1120) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at system.sharedconfig.cfg_companyqueries_cfm$cf.call(/RootDir/system/sharedconfig/cfg_CompanyQueries.cfm:22) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at system.sharedconfig.cfg_application_cfm$cf.call(/RootDir/system/sharedconfig/cfg_Application.cfm:160) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at __138.system.sharedconfig.udf_applicationmethods_cfm$cf.udfCall(../system/sharedconfig/udf_ApplicationMethods.cfm:295) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:135) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1215) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1161) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.filters.RemoteIpFilter.doFilter(RemoteIpFilter.java:924) at org.apache.catalina.filters.RemoteIpFilter.doFilter(RemoteIpFilter.java:980) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:424) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host or-prf1-mssql-db1.cj5wyoimya0c.us-west-2.rds.amazonaws.com, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". ... 69 more
TagContext
Array
1
Struct
codePrintHTML
string20: FROM COMPANIES<br> 21: WHERE COMPANY_ID=&lt;cfqueryparam value=&quot;#REQUEST.DefaultCompanyID#&quot; CFSQLTYPE=&quot;CF_SQL_BIGINT&quot;&gt;<br> <b>22: &lt;/CFQUERY&gt;</b><br> 23: &lt;/CFIF&gt;<br> 24: <br>
codePrintPlain
string20: FROM COMPANIES 21: WHERE COMPANY_ID=<cfqueryparam value="#REQUEST.DefaultCompanyID#" CFSQLTYPE="CF_SQL_BIGINT"> 22: </CFQUERY> 23: </CFIF> 24:
column
number0
id
string??
line
number22
Raw_Trace
stringsystem.sharedconfig.cfg_companyqueries_cfm$cf.call(/RootDir/system/sharedconfig/cfg_CompanyQueries.cfm:22)
template
string/www/shopdoterra-iact/system/sharedconfig/cfg_CompanyQueries.cfm
type
stringcfml
2
Struct
codePrintHTML
string158: <br> 159: <br> <b>160: &lt;cfinclude template=&quot;cfg_CompanyQueries.cfm&quot;&gt;</b><br> 161: <br> 162: &lt;!--- CF MX 7 fix. CompanyApplication is uniqe to a client, so make sure it pulls from that dir. Linked files include from where the original file's location, not where the link is ---&gt;<br>
codePrintPlain
string158: 159: 160: <cfinclude template="cfg_CompanyQueries.cfm"> 161: 162: <!--- CF MX 7 fix. CompanyApplication is uniqe to a client, so make sure it pulls from that dir. Linked files include from where the original file's location, not where the link is --->
column
number0
id
string??
line
number160
Raw_Trace
stringsystem.sharedconfig.cfg_application_cfm$cf.call(/RootDir/system/sharedconfig/cfg_Application.cfm:160)
template
string/www/shopdoterra-iact/system/sharedconfig/cfg_Application.cfm
type
stringcfml
3
Struct
codePrintHTML
string293: &lt;/cfif&gt;<br> 294: &lt;cfscript&gt;<br> <b>295: include &quot;/RootDir/system/sharedconfig/cfg_Application.cfm&quot;;</b><br> 296: &lt;/cfscript&gt;<br> 297: &lt;cfif StructKeyExists(this,'CustomOnRequestStart')&gt;<br>
codePrintPlain
string293: </cfif> 294: <cfscript> 295: include "/RootDir/system/sharedconfig/cfg_Application.cfm"; 296: </cfscript> 297: <cfif StructKeyExists(this,'CustomOnRequestStart')>
column
number0
id
string??
line
number295
Raw_Trace
string__138.system.sharedconfig.udf_applicationmethods_cfm$cf.udfCall(../system/sharedconfig/udf_ApplicationMethods.cfm:295)
template
string/www/shopdoterra-iact/system/sharedconfig/udf_ApplicationMethods.cfm
type
stringcfml
type
stringcom.microsoft.sqlserver.jdbc.SQLServerException
DataSource
string
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringThe TCP/IP connection to the host or-prf1-mssql-db1.cj5wyoimya0c.us-west-2.rds.amazonaws.com, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
NativeErrorCode
number0
queryError
string
Sql
string
SQLState
string08S01
StackTrace
stringlucee.runtime.exp.DatabaseException: The TCP/IP connection to the host or-prf1-mssql-db1.cj5wyoimya0c.us-west-2.rds.amazonaws.com, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:231) at com.microsoft.sqlserver.jdbc.SQLServerException.convertConnectExceptionToSQLServerException(SQLServerException.java:282) at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2578) at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:719) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3523) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:3172) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:3014) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1836) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1246) at lucee.runtime.db.DataSourceSupport._getConnection(DataSourceSupport.java:135) at lucee.runtime.db.DataSourceSupport.getConnection(DataSourceSupport.java:103) at lucee.runtime.db.DatasourceConnectionPool.loadDatasourceConnection(DatasourceConnectionPool.java:158) at lucee.runtime.db.DatasourceConnectionPool.getDatasourceConnection(DatasourceConnectionPool.java:121) at lucee.runtime.db.DatasourceManagerImpl.getConnection(DatasourceManagerImpl.java:82) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1120) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at system.sharedconfig.cfg_companyqueries_cfm$cf.call(/RootDir/system/sharedconfig/cfg_CompanyQueries.cfm:22) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at system.sharedconfig.cfg_application_cfm$cf.call(/RootDir/system/sharedconfig/cfg_Application.cfm:160) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at __138.system.sharedconfig.udf_applicationmethods_cfm$cf.udfCall(../system/sharedconfig/udf_ApplicationMethods.cfm:295) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:135) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1215) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1161) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.filters.RemoteIpFilter.doFilter(RemoteIpFilter.java:924) at org.apache.catalina.filters.RemoteIpFilter.doFilter(RemoteIpFilter.java:980) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:424) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host or-prf1-mssql-db1.cj5wyoimya0c.us-west-2.rds.amazonaws.com, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". ... 69 more
TagContext
Array
1
Struct
codePrintHTML
string20: FROM COMPANIES<br> 21: WHERE COMPANY_ID=&lt;cfqueryparam value=&quot;#REQUEST.DefaultCompanyID#&quot; CFSQLTYPE=&quot;CF_SQL_BIGINT&quot;&gt;<br> <b>22: &lt;/CFQUERY&gt;</b><br> 23: &lt;/CFIF&gt;<br> 24: <br>
codePrintPlain
string20: FROM COMPANIES 21: WHERE COMPANY_ID=<cfqueryparam value="#REQUEST.DefaultCompanyID#" CFSQLTYPE="CF_SQL_BIGINT"> 22: </CFQUERY> 23: </CFIF> 24:
column
number0
id
string??
line
number22
Raw_Trace
stringsystem.sharedconfig.cfg_companyqueries_cfm$cf.call(/RootDir/system/sharedconfig/cfg_CompanyQueries.cfm:22)
template
string/www/shopdoterra-iact/system/sharedconfig/cfg_CompanyQueries.cfm
type
stringcfml
2
Struct
codePrintHTML
string158: <br> 159: <br> <b>160: &lt;cfinclude template=&quot;cfg_CompanyQueries.cfm&quot;&gt;</b><br> 161: <br> 162: &lt;!--- CF MX 7 fix. CompanyApplication is uniqe to a client, so make sure it pulls from that dir. Linked files include from where the original file's location, not where the link is ---&gt;<br>
codePrintPlain
string158: 159: 160: <cfinclude template="cfg_CompanyQueries.cfm"> 161: 162: <!--- CF MX 7 fix. CompanyApplication is uniqe to a client, so make sure it pulls from that dir. Linked files include from where the original file's location, not where the link is --->
column
number0
id
string??
line
number160
Raw_Trace
stringsystem.sharedconfig.cfg_application_cfm$cf.call(/RootDir/system/sharedconfig/cfg_Application.cfm:160)
template
string/www/shopdoterra-iact/system/sharedconfig/cfg_Application.cfm
type
stringcfml
3
Struct
codePrintHTML
string293: &lt;/cfif&gt;<br> 294: &lt;cfscript&gt;<br> <b>295: include &quot;/RootDir/system/sharedconfig/cfg_Application.cfm&quot;;</b><br> 296: &lt;/cfscript&gt;<br> 297: &lt;cfif StructKeyExists(this,'CustomOnRequestStart')&gt;<br>
codePrintPlain
string293: </cfif> 294: <cfscript> 295: include "/RootDir/system/sharedconfig/cfg_Application.cfm"; 296: </cfscript> 297: <cfif StructKeyExists(this,'CustomOnRequestStart')>
column
number0
id
string??
line
number295
Raw_Trace
string__138.system.sharedconfig.udf_applicationmethods_cfm$cf.udfCall(../system/sharedconfig/udf_ApplicationMethods.cfm:295)
template
string/www/shopdoterra-iact/system/sharedconfig/udf_ApplicationMethods.cfm
type
stringcfml
type
stringdatabase
where
string