struct
Browser Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
DateTime {ts '2024-11-25 23:31:39'}
Diagnostics Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "Y"."YEAR": invalid identifier <br>The error occurred on line 46.
GeneratedContent <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>UC Davis :: SIS </title> <link href="/css/cssWide.css" rel="stylesheet" type="text/css"> <script type="text/javascript" language="javascript"> function formSubmitWithWorkingButton(formID){ var Form = document.getElementById(formID); if( Form != null ){ Form.subButton.value='Working......'; Form.subButton.disabled=true; } } /**/ function SortResults( sortOrder, sortDirection, PreviousSortOrder, PreviousSortDirection, hiddenFieldSortOrder, hiddenFieldSortDirection, formName ){ var HiddenFieldSortOrder = document.getElementById(hiddenFieldSortOrder); var HiddenFieldSortDirection = document.getElementById(hiddenFieldSortDirection); var Form = document.getElementById(formName); if( HiddenFieldSortOrder != null && HiddenFieldSortDirection != null ){ HiddenFieldSortOrder.value = sortOrder; if( PreviousSortOrder == sortOrder && PreviousSortDirection == sortDirection ){ if( sortDirection == "asc" ){ HiddenFieldSortDirection.value = "desc"; }else{ HiddenFieldSortDirection.value = "asc"; } }else{ HiddenFieldSortDirection.value = sortDirection; } if( Form != null ){ formSubmitWithWorkingButton(); Form.submit(); } } } /**/ function ResetSearch( location ){ window.location = location; } </script> <SCRIPT LANGUAGE="JavaScript"> // create a modal pop up window using CFWindow function createModalWin(name, title, url, h, w) { ColdFusion.Window.create(name, title, url, {height:h,width:w,modal:true,closable:true, draggable:true,resizable:true,center:true, initshow:true}); ColdFusion.Window.onHide(name, modalWinOnClose); //document.getElementById(ColdFusion.Window.getWindowObject(name).header.id).className = "windowHdr"; } function modalWinOnClose(){ // stub function so CreateModalWin onHide does not fail. Simply place this function // on your page to make it fire on window close } // Function to open a window function windowOpen(window_url, height, width) { if (height != 0 && width != 0) { var locX = (screen.availWidth - width)/2; var locY = (screen.availHeight - height)/2; var sizeLoc="height="+height+",innerHeight="+height+",width="+width+",innerWidth="+width+",innerWidth="+width+",screenX="+locX+",screenY="+locY+",left="+locX+",top="+locY+" "; } else { var sizeLoc=""; } outsideWin = window.open(window_url,"outsideWin","toolbar=no,status=no,scrollbars=yes,menubar=no,resizable=yes,directories=no,location=no,"+sizeLoc); window.outsideWin.focus(); } function windowOpenWithName(window_url, name, height, width) { if (height != 0 && width != 0) { var locX = (screen.availWidth - width)/2; var locY = (screen.availHeight - height)/2; var sizeLoc="height="+height+",innerHeight="+height+",width="+width+",innerWidth="+width+",innerWidth="+width+",screenX="+locX+",screenY="+locY+",left="+locX+",top="+locY+" "; } else { var sizeLoc=""; } // this took me forever to get right.. opens the window using the name passed in // and then sets the focus to it. BCA eval(name+"= window.open('"+window_url+"','"+name+"','toolbar=no,status=no,scrollbars=yes,menubar=no,resizable=yes,directories=no,location=no,"+sizeLoc+"');"); eval("window."+name+".focus()"); } function windowOpenFull(window_url, height, width) { var locX = (screen.availWidth - width)/2; var locY = (screen.availHeight - height)/2; outsideWin = window.open(window_url,"outsideWin","toolbar=no,status=no,scrollbars=yes,menubar=no,resizable=yes,directories=no,location=no,screenX="+locX+",screenY="+locY+",left="+locX+",top="+locY+" "); window.outsideWin.focus(); } function windowOpenNormal(window_url, height, width) { var locX = (screen.availWidth - width)/2; var locY = (screen.availHeight - height)/2; outsideWinNorm = window.open(window_url,"outsideWinNorm","toolbar=yes,status=yes,scrollbars=yes,menubar=yes,resizable=yes,directories=yes,location=yes,screenX="+locX+",screenY="+locY+",left="+locX+",top="+locY+" "); window.outsideWinNorm.focus(); } function profileWin(sid) { profileInfo = window.open('/secure/profiles/CampusStudentProfile.cfm?sid='+sid, 'profileInfo'+sid,"height=800,width=1200,toolbar=no,status=no,scrollbars=yes,menubar=no,resizable=yes,directories=no,location=no"); window.profileInfo.focus(); } </SCRIPT> </head> <body> <div id="wrapper" align="center"> <div id="ucdavisBar"> <div id="campusLinks" align="right"> <a href="http://www.ucdavis.edu">UC Davis</a> | <a href="http://studentaffairs.ucdavis.edu/tech/support">Contact Us</a> </div> </div> <div id="mainContainer" align="center"> <div id="header"> <a href="/index.cfm"><img src="/images/ucdavis_logo_blue.png" WIDTH="170" alt="UC Davis Logo" border="0" align="left"></a> </div> <div id="navigationBox"> <div id="subNavbar"> </div> </div> <div id="pageContent"> <h1>Student Information System</h1> <script type="text/javascript" src="/includes/nifty.js"></script> <script src='https://www.google.com/recaptcha/api.js'></script> <script type="text/javascript"> window.onload = function() { if (!NiftyCheck()) { return; } Rounded("div#nifty", "#FFFFFF", "#CFD5E5", 15, 15); Rounded("div#nifty2", "#FFFFFF", "#CFD5E5", 15, 15); } </script> <SPAN CLASS="breadCrumb"><a href="https://iet.ucdavis.edu/units/enterprise-iet/enterprise-student-applications">IET Enterprise Student Applications</a> >> <A HREF="https://sis.ucdavis.edu">SIS</A> >> Data Request Form</SPAN> <BR><BR> <h2>Student Data Request Form</H2> <P> Student data is covered by UC Davis Policies <A HREF="https://ucdavispolicy.ellucid.com/documents/view/419/active" TARGET="_blank">320-40</A>, <A HREF="https://ucdavispolicy.ellucid.com/documents/view/397/active/" TARGET="_blank">320-21</A> and <A HREF="https://ucdavispolicy.ellucid.com/documents/view/417/active/" TARGET="_blank">320-35</A> on institutional data usage and <A HREF="https://ucdavispolicy.ellucid.com/documents/view/353/active/" TARGET="_blank">Cybersafety Policy 310-22</A> for the use and storage of personal information. Additionally, <A HREF="https://www2.ed.gov/policy/gen/guid/fpco/ferpa/index.html" TARGET="_blank">Family Educational Rights and Privacy Act</A> (FERPA), and <A HREF="https://oag.ca.gov/privacy/privacy-laws" TARGET="_blank">California Information Practices Act of 1977</A> (CA IPA) regulations must be adhered to where applicable. All requests are reviewed to verify that it meets approved and legitimate needs that meet applicable rules, policies and procedures. FERPA training is required for requestors of student data; training can be found in the <A HREF="https://uc.sumtotal.host/Core/pillarRedirect?relyingParty=LM&url=core%2Factivitydetails%2FViewActivityDetails%3FActivityId%3D201699%26UserMode%3D0" TARGET="_blank">UC Learning Center</A>. Making a request for student data does not imply it will be fulfilled. <H3>Please Complete All Areas of the Form:</H3> <P> <form name="requestDetailsForm" id="requestDetailsForm" action="/dataRequest/index.cfm" method="post" onsubmit="return _CF_checkrequestDetailsForm(this)">
HTTPReferer https://sis-dev.ucdavis.edu/dataRequest
Mailto [empty string]
Message Error Executing Database Query.
QueryString [empty string]
RemoteAddress 3.142.250.86
RootCause
struct
Cause
struct
ErrorCode 904
Message [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "Y"."YEAR": invalid identifier
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "Y"."YEAR": invalid identifier at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1408|:1081) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:976) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:1120) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:455) at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:941) at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:484) at macromedia.jdbc.oracle.OracleImplStatement.cu(|Oracle|6.0.0.1408|:3430) at macromedia.jdbc.oracle.base.gs.od(|Oracle|6.0.0.1408|:2505) at macromedia.jdbc.oracle.base.gs.nW(|Oracle|6.0.0.1408|:1358) at macromedia.jdbc.oracle.base.gs.execute(|Oracle|6.0.0.1408|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1613) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfindex2ecfm9684605.runPage(/opt/web/sis/dataRequest/index.cfm:46) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) 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:97) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) 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.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:482) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) 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:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1081
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1408|:1081)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
2
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 976
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:976)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
3
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 1120
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:1120)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
4
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 455
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:455)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
5
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 941
RAW_TRACE at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:941)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
6
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 484
RAW_TRACE at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:484)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
7
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 3430
RAW_TRACE at macromedia.jdbc.oracle.OracleImplStatement.cu(|Oracle|6.0.0.1408|:3430)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
8
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 2505
RAW_TRACE at macromedia.jdbc.oracle.base.gs.od(|Oracle|6.0.0.1408|:2505)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
9
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.oracle.base.gs.nW(|Oracle|6.0.0.1408|:1358)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
10
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.oracle.base.gs.execute(|Oracle|6.0.0.1408|:4478)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
11
struct
COLUMN 0
ID CFQUERY
LINE 46
RAW_TRACE at cfindex2ecfm9684605.runPage(/opt/web/sis/dataRequest/index.cfm:46)
TEMPLATE /opt/web/sis/dataRequest/index.cfm
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource whyucdavis_dev
Detail [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "Y"."YEAR": invalid identifier
ErrorCode 42S22
Exceptions
array
1
struct
class java.sql.SQLSyntaxErrorException
message [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "Y"."YEAR": invalid identifier
Message Error Executing Database Query.
NativeErrorCode 904
RootCause
struct
ErrorCode 904
Message [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "Y"."YEAR": invalid identifier
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "Y"."YEAR": invalid identifier at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1408|:1081) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:976) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:1120) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:455) at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:941) at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:484) at macromedia.jdbc.oracle.OracleImplStatement.cu(|Oracle|6.0.0.1408|:3430) at macromedia.jdbc.oracle.base.gs.od(|Oracle|6.0.0.1408|:2505) at macromedia.jdbc.oracle.base.gs.nW(|Oracle|6.0.0.1408|:1358) at macromedia.jdbc.oracle.base.gs.execute(|Oracle|6.0.0.1408|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1613) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfindex2ecfm9684605.runPage(/opt/web/sis/dataRequest/index.cfm:46) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) 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:97) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) 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.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:482) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) 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:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1081
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1408|:1081)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
2
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 976
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:976)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
3
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 1120
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:1120)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
4
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 455
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:455)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
5
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 941
RAW_TRACE at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:941)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
6
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 484
RAW_TRACE at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:484)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
7
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 3430
RAW_TRACE at macromedia.jdbc.oracle.OracleImplStatement.cu(|Oracle|6.0.0.1408|:3430)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
8
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 2505
RAW_TRACE at macromedia.jdbc.oracle.base.gs.od(|Oracle|6.0.0.1408|:2505)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
9
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.oracle.base.gs.nW(|Oracle|6.0.0.1408|:1358)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
10
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.oracle.base.gs.execute(|Oracle|6.0.0.1408|:4478)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
11
struct
COLUMN 0
ID CFQUERY
LINE 46
RAW_TRACE at cfindex2ecfm9684605.runPage(/opt/web/sis/dataRequest/index.cfm:46)
TEMPLATE /opt/web/sis/dataRequest/index.cfm
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S22
Sql select x.school_code as code, x.school_name, y.atpcode, y.schcity, y.api_latest as api, y.year from ia_recruit_school x, school_profile y where x.school_code=y.atpcode(+) order by upper(x.school_name)
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfindex2ecfm9684605.runPage(/opt/web/sis/dataRequest/index.cfm:46) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) 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:97) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) 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.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:482) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) 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:834) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "Y"."YEAR": invalid identifier at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1408|:1081) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:976) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:1120) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:455) at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:941) at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:484) at macromedia.jdbc.oracle.OracleImplStatement.cu(|Oracle|6.0.0.1408|:3430) at macromedia.jdbc.oracle.base.gs.od(|Oracle|6.0.0.1408|:2505) at macromedia.jdbc.oracle.base.gs.nW(|Oracle|6.0.0.1408|:1358) at macromedia.jdbc.oracle.base.gs.execute(|Oracle|6.0.0.1408|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1613) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 44 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 46
RAW_TRACE at cfindex2ecfm9684605.runPage(/opt/web/sis/dataRequest/index.cfm:46)
TEMPLATE /opt/web/sis/dataRequest/index.cfm
TYPE CFML
2
struct
COLUMN 0
ID ??
LINE 1081
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1408|:1081)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
3
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 976
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:976)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
4
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 1120
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:1120)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
5
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 455
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:455)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
6
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 941
RAW_TRACE at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:941)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
7
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 484
RAW_TRACE at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:484)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
8
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 3430
RAW_TRACE at macromedia.jdbc.oracle.OracleImplStatement.cu(|Oracle|6.0.0.1408|:3430)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
9
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 2505
RAW_TRACE at macromedia.jdbc.oracle.base.gs.od(|Oracle|6.0.0.1408|:2505)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
10
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.oracle.base.gs.nW(|Oracle|6.0.0.1408|:1358)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
11
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.oracle.base.gs.execute(|Oracle|6.0.0.1408|:4478)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
Type Database
queryError [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "Y"."YEAR": invalid identifier
where [empty string]
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfindex2ecfm9684605.runPage(/opt/web/sis/dataRequest/index.cfm:46) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) 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:97) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) 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.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:482) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) 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:834) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "Y"."YEAR": invalid identifier at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1408|:1081) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:976) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:1120) at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:455) at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:941) at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:484) at macromedia.jdbc.oracle.OracleImplStatement.cu(|Oracle|6.0.0.1408|:3430) at macromedia.jdbc.oracle.base.gs.od(|Oracle|6.0.0.1408|:2505) at macromedia.jdbc.oracle.base.gs.nW(|Oracle|6.0.0.1408|:1358) at macromedia.jdbc.oracle.base.gs.execute(|Oracle|6.0.0.1408|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1613) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 44 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 46
RAW_TRACE at cfindex2ecfm9684605.runPage(/opt/web/sis/dataRequest/index.cfm:46)
TEMPLATE /opt/web/sis/dataRequest/index.cfm
TYPE CFML
2
struct
COLUMN 0
ID ??
LINE 1081
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1408|:1081)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
3
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 976
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:976)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
4
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 1120
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:1120)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
5
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 455
RAW_TRACE at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1408|:455)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
6
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 941
RAW_TRACE at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:941)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
7
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 484
RAW_TRACE at macromedia.jdbc.oracle.OracleImplResultset.a(|Oracle|6.0.0.1408|:484)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
8
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 3430
RAW_TRACE at macromedia.jdbc.oracle.OracleImplStatement.cu(|Oracle|6.0.0.1408|:3430)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
9
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 2505
RAW_TRACE at macromedia.jdbc.oracle.base.gs.od(|Oracle|6.0.0.1408|:2505)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
10
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.oracle.base.gs.nW(|Oracle|6.0.0.1408|:1358)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
11
struct
COLUMN 0
ID CF_|ORACLE|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.oracle.base.gs.execute(|Oracle|6.0.0.1408|:4478)
TEMPLATE |Oracle|6.0.0.1408|
TYPE CFML
Template /dataRequest/index.cfm
Type coldfusion.runtime.CfErrorWrapper