Skip Links

 
Always Learning
 
 
 
 
Pre K-12 EDUCATION
 
 
 
 
 
 
CA State Page
Welcome California!

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-00942: table or view does not exist
 
The error occurred in /usr2/webroot/k12/statepage/ps_statepage_index.cfm: line 79
77 : 		from tbl_state_event a
78 : 		where Upper(a.cmpy_cd) = '#Ucase(trim(url.cmpy_cd))#'
79 : 		and Upper(a.state_id) = '#Ucase(trim(url.state))#'
80 : 		order by a.display_seq, a.event_name
81 : 		</CFQUERY>

VENDORERRORCODE   942
SQLSTATE   42S02
SQL    select a.* from tbl_state_event a where Upper(a.cmpy_cd) = 'PH' and Upper(a.state_id) = 'CA' order by a.display_seq, a.event_name
DATASOURCE   k12schl
Resources:

Browser   ColdFusion
Remote Address   165.193.122.146
Referrer  
Date/Time   24-Jul-14 12:08 AM
Stack Trace
at cfps_statepage_index2ecfm853722062.runPage(/usr2/webroot/k12/statepage/ps_statepage_index.cfm:79) at cfps_statepage_index2ecfm853722062.runPage(/usr2/webroot/k12/statepage/ps_statepage_index.cfm:79)

java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

	at macromedia.jdbc.oraclebase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source)
	at macromedia.jdbc.oraclebase.BaseExceptions40.createSQLException(Unknown Source)
	at macromedia.jdbc.oraclebase.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.oraclebase.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
	at macromedia.jdbc.oraclebase.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.oraclebase.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.oraclebase.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1229)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
	at coldfusion.sql.Executive.executeQuery(Executive.java:939)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533)
	at cfps_statepage_index2ecfm853722062.runPage(/usr2/webroot/k12/statepage/ps_statepage_index.cfm:79)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:87)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53)
	at coldfusion.CfmServlet.service(CfmServlet.java:200)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
 
 
 
 
Copyright © 2014 Pearson Education, Inc. or its affiliate(s). All rights reserved.
 
  • Teachability
  • Twitter
  • Facebook