MONTGOMERY COUNTY BOARDS AND COMMISSIONS

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][Oracle JDBC Driver][Oracle]ORA-01722: invalid number
 
The error occurred in D:/WebSites/mcohio/government/elected_officials/board_of_county_commissioners/boards_commissions_details.cfm: line 214
212 : CONT_PHONE, CONT_EMAIL, TERM, COMPOSITION, ocrcode   
213 :  from bcc_comm
214 :  where SEQ_COMM_ID = '#url.id#'
215 :  
216 :  </cfquery>

SQLSTATE   22018
DATASOURCE   bcc
VENDORERRORCODE   1722
SQL    select rowid, SEQ_COMM_ID, COMMITTEE, STAUTE, FUNCTION, MEETING, CONT_NAME, CONT_ADDR1, CONT_CITY||', '||CONT_STATE||' '||CONT_ZIP as address_CSZ, CONT_PHONE, CONT_EMAIL, TERM, COMPOSITION, ocrcode from bcc_comm where SEQ_COMM_ID = '14,14'
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.82.119.116
Referrer  
Date/Time   25-Apr-19 11:52 AM
Stack Trace
at cfboards_commissions_details2ecfm1234151981.runPage(D:/WebSites/mcohio/government/elected_officials/board_of_county_commissioners/boards_commissions_details.cfm:214) at cfboards_commissions_details2ecfm1234151981.runPage(D:/WebSites/mcohio/government/elected_officials/board_of_county_commissioners/boards_commissions_details.cfm:214)

java.sql.SQLDataException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01722: invalid number

	at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source)
	at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source)
	at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source)
	at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source)
	at macromedia.jdbc.oracle.ddal.a(Unknown Source)
	at macromedia.jdbc.oracle.ddal.a(Unknown Source)
	at macromedia.jdbc.oracle.ddam.t(Unknown Source)
	at macromedia.jdbc.oraclebase.dde3.y(Unknown Source)
	at macromedia.jdbc.oraclebase.dde3.u(Unknown Source)
	at macromedia.jdbc.oraclebase.dde3.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)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
	at cfboards_commissions_details2ecfm1234151981.runPage(D:\WebSites\mcohio\government\elected_officials\board_of_county_commissioners\boards_commissions_details.cfm:214)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
	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:199)
	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:140)
	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:355)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
	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)