[Skip to Content]
dlac | digital leadership academy | 2018-2020

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'agency_region_number'.
 
The error occurred in D:/inetpub/Websites/production/otan/digital-leadership-academy/qry/qry_getparticipants.cfm: line 44
Called from D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm: line 533
Called from D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm: line 532
Called from D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm: line 53
Called from D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm: line 1
Called from D:/inetpub/Websites/production/otan/digital-leadership-academy/qry/qry_getparticipants.cfm: line 44
Called from D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm: line 533
Called from D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm: line 532
Called from D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm: line 53
Called from D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm: line 1
42 : 		<cfcase value="8">agency_county_name DESC, name_last, name_first</cfcase>
43 : 		<cfcase value="9">agency_region_name, name_last, name_first</cfcase>
44 : 		<cfcase value="10">agency_region_name DESC, name_last, name_first</cfcase>
45 : 	</cfswitch>
46 : </cfquery>

VENDORERRORCODE   207
SQLSTATE   42S22
SQL    SELECT DISTINCT userid, title, name_first, name_last, email_primary, agency_name, agency_type, agency_county_code, agency_county_name, agency_region_number, agency_region_name, agency_region_display_number, coachfirst, coachlast FROM view_teamscoaches WHERE appyear = (param 1) ORDER BY name_last, name_first
DATASOURCE   dlac
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.198.170.159
Referrer  
Date/Time   19-Jul-18 04:26 PM
Stack Trace
at cfqry_getparticipants2ecfm837771751.runPage(D:/inetpub/Websites/production/otan/digital-leadership-academy/qry/qry_getparticipants.cfm:44) at cfindex2ecfm1376546092._factor74(D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm:533) at cfindex2ecfm1376546092._factor85(D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm:532) at cfindex2ecfm1376546092._factor86(D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm:53) at cfindex2ecfm1376546092.runPage(D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm:1) at cfqry_getparticipants2ecfm837771751.runPage(D:/inetpub/Websites/production/otan/digital-leadership-academy/qry/qry_getparticipants.cfm:44) at cfindex2ecfm1376546092._factor74(D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm:533) at cfindex2ecfm1376546092._factor85(D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm:532) at cfindex2ecfm1376546092._factor86(D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm:53) at cfindex2ecfm1376546092.runPage(D:/inetpub/Websites/production/otan/digital-leadership-academy/index.cfm:1)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'agency_region_number'.
	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.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.r(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:1495)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1229)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1159)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1185)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:814)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:767)
	at cfqry_getparticipants2ecfm837771751.runPage(D:\inetpub\Websites\production\otan\digital-leadership-academy\qry\qry_getparticipants.cfm:44)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2991)
	at cfindex2ecfm1376546092._factor74(D:\inetpub\Websites\production\otan\digital-leadership-academy\index.cfm:533)
	at cfindex2ecfm1376546092._factor85(D:\inetpub\Websites\production\otan\digital-leadership-academy\index.cfm:532)
	at cfindex2ecfm1376546092._factor86(D:\inetpub\Websites\production\otan\digital-leadership-academy\index.cfm:53)
	at cfindex2ecfm1376546092.runPage(D:\inetpub\Websites\production\otan\digital-leadership-academy\index.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:466)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:142)
	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:58)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	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:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:199)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)