struct
Cause
struct
ErrorCode 0
Message [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
SQLState 08S01
StackTrace java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. 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.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddo.c(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddn.f(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddn.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.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1583) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:72) at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:12477) at cfSQR2ecfm260240602._factor7(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1183) at cfSQR2ecfm260240602._factor14(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1172) at cfSQR2ecfm260240602.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfindex2ecfm199623715._factor5(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:18) at cfindex2ecfm199623715.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfapplication2ecfc1757924483$funcONREQUEST.runFunction(D:\inetpub\wwwroot\ContedWeb\application.cfc:45) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:551) 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.ExceptionFilter.invoke(ExceptionFilter.java:96) 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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 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:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
LINE -1
RAW_TRACE java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
TEMPLATE Server returned
TYPE CFML
2
struct
COLUMN 0
ID CF_CFPAGE
LINE 1183
RAW_TRACE at cfSQR2ecfm260240602._factor7(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1183)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SQR
LINE 1172
RAW_TRACE at cfSQR2ecfm260240602._factor14(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1172)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SQR
LINE 1
RAW_TRACE at cfSQR2ecfm260240602.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 18
RAW_TRACE at cfindex2ecfm199623715._factor5(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:18)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_INDEX
LINE 1
RAW_TRACE at cfindex2ecfm199623715.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:1)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFINCLUDE
LINE 45
RAW_TRACE at cfapplication2ecfc1757924483$funcONREQUEST.runFunction(D:\inetpub\wwwroot\ContedWeb\application.cfc:45)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\application.cfc
TYPE CFML
Type java.sql.SQLNonTransientConnectionException
DataSource CSCE
Detail [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
ErrorCode 08S01
Exceptions
array
1
struct
class java.sql.SQLNonTransientConnectionException
message [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
SQLState 08S01
StackTrace java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. 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.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddo.c(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddn.f(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddn.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.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1583) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:72) at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:12477) at cfSQR2ecfm260240602._factor7(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1183) at cfSQR2ecfm260240602._factor14(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1172) at cfSQR2ecfm260240602.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfindex2ecfm199623715._factor5(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:18) at cfindex2ecfm199623715.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfapplication2ecfc1757924483$funcONREQUEST.runFunction(D:\inetpub\wwwroot\ContedWeb\application.cfc:45) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:551) 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.ExceptionFilter.invoke(ExceptionFilter.java:96) 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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 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:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
LINE -1
RAW_TRACE java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
TEMPLATE Server returned
TYPE CFML
2
struct
COLUMN 0
ID CF_CFPAGE
LINE 1183
RAW_TRACE at cfSQR2ecfm260240602._factor7(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1183)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SQR
LINE 1172
RAW_TRACE at cfSQR2ecfm260240602._factor14(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1172)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SQR
LINE 1
RAW_TRACE at cfSQR2ecfm260240602.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 18
RAW_TRACE at cfindex2ecfm199623715._factor5(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:18)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_INDEX
LINE 1
RAW_TRACE at cfindex2ecfm199623715.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:1)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFINCLUDE
LINE 45
RAW_TRACE at cfapplication2ecfc1757924483$funcONREQUEST.runFunction(D:\inetpub\wwwroot\ContedWeb\application.cfc:45)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\application.cfc
TYPE CFML
Type java.sql.SQLNonTransientConnectionException
SQLState 08S01
Sql SELECT sv.ISISCode,sv.GenEdCode,sv.CourseNumber,sv.SectionNumber,sv.TabCourseName,sv.Status,sv. Day,sv.Time_Offered,sv.WhenOffered,sv.Tuition,sv.Coursecode,sv.OnlineHrs,sv. SectionNotes,sv.Instructor,sv.InstructionModeCode,sv.ModeCodeDescription,sv.SessionCode,sv.OfferedStart,sv.OfferedEnd,sv.SeatsAvailable,sv.CanceledDate,sv.SISTermID,sv.SeatsWaitList,sv.AddedDate ,sv.[Length_Weeks],sv.[Add_Date] ,sv.[Add_Date_Permission] ,sv.[Drop_Date] ,sv.[Withdraw_UG_Date] ,sv.[Withdraw_GR_Date] ,sv.[Registration_Begin_Date],cb.SISSubject FROM [CourseBank].[dbo].[SemestersView] AS sv LEFT JOIN [CourseBank].[dbo].[CourseBank] AS cb ON (cb.CourseNumber = sv.CourseNumber) LEFT JOIN Category ON (sv.Course_Category = Category.Category_ID) LEFT JOIN SISSubjects S ON (cb.SISSubject = S.[Subject]) WHERE sv.TermID = (param 1) AND (PATINDEX('-NE%',sv.SectionNumber)=0) AND (PATINDEX('%.[5,6,7,8]%',sv.CourseNumber)>0) AND ( sv.InstructionModeCode = 'OC' OR ( sv.InstructionModeCode IS NULL AND ( PATINDEX('-09%', sv.SectionNumber) > 0 OR PATINDEX('-SA%', sv.SectionNumber) > 0 ) ) ) AND (PATINDEX( (param 2) , sv.CourseNumber)>0) ORDER BY CAST(sv.CourseNumber+'.'+sv.SectionNumber AS CHAR) COLLATE SQL_EBCDIC037_CP1_CS_AS ASC
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:72) at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:12477) at cfSQR2ecfm260240602._factor7(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1183) at cfSQR2ecfm260240602._factor14(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1172) at cfSQR2ecfm260240602.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfindex2ecfm199623715._factor5(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:18) at cfindex2ecfm199623715.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfapplication2ecfc1757924483$funcONREQUEST.runFunction(D:\inetpub\wwwroot\ContedWeb\application.cfc:45) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:551) 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.ExceptionFilter.invoke(ExceptionFilter.java:96) 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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 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:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. 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.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddo.c(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddn.f(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddn.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.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1583) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) ... 66 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CF_CFPAGE
LINE 1183
RAW_TRACE at cfSQR2ecfm260240602._factor7(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1183)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_SQR
LINE 1172
RAW_TRACE at cfSQR2ecfm260240602._factor14(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1172)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SQR
LINE 1
RAW_TRACE at cfSQR2ecfm260240602.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm:1)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\SQR.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 18
RAW_TRACE at cfindex2ecfm199623715._factor5(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:18)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_INDEX
LINE 1
RAW_TRACE at cfindex2ecfm199623715.runPage(D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm:1)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\catalog\search\index.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 45
RAW_TRACE at cfapplication2ecfc1757924483$funcONREQUEST.runFunction(D:\inetpub\wwwroot\ContedWeb\application.cfc:45)
TEMPLATE D:\inetpub\wwwroot\ContedWeb\application.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_THREAD
LINE -1
RAW_TRACE Caused by: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
TEMPLATE Server returned
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
where (param 1) = [type='IN', class='java.lang.Integer', value='113', sqltype='integer'] , (param 2) = [type='IN', class='java.lang.String', value='mech.3020', sqltype='varchar']