Folks,

We're currently getting the following error whenever someone tries to access the Academics > Class page:

HTTP Status 500 – Internal Server Error

Type Exception Report

Message An exception occurred processing [nFindDClassSearch.jsp] at line [3045]

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: An exception occurred processing [nFindDClassSearch.jsp] at line [3045]

3042: else
3043: {
3044: VmlOperation.SetZeidonSessionAttribute( null, task, "nFindDClassSearch", "nFindD.PostBuildClassSearch" );
3045: nOptRC = nFindD.PostBuildClassSearch( new zVIEW( vKZXMLPGO ) );
3046: if ( nOptRC == 2 )
3047: {
3048: View vView;

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:610)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:499)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:376)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:324)
javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

Root Cause

com.quinsoft.zeidon.ZeidonException: java.sql.SQLSyntaxErrorException: Unknown column 'CLASS.CLASSSTATUS' in 'SELECT'
LodDef = nazsis.mConList
Table = CLASS
EntityDef = nazsis.mConList.Class
SQL => SELECT CLASS.ID, CLASS.CLASSSTARTDATE, CLASS.FACULTYHASSUBMITTEDGRADESFLAG, CLASS.COURSETITLE, CLASS.STATUS, CLASS.SECTION, CLASS.CLASSSTATUS, CLASS.FK_ID_COHORT, CLASS.FK_ID_CAMPUSLOCATION, CLASS.FK_ID_CLASSROOMSTANDARDSCHEDULE, CLASS.FK_ID_COLLEGETERM, CLASS.FK_ID_COURSE, CLASS.FK_ID_COURSETOPIC, CLASS.FK_ID_FACULTY, CLASS.FK_ID_ROOM, CLASS.FK_ID_ROOM02, CLASS.FK_ID_GRADESCALE, COURSE.ID, COURSE.TITLE, COURSE.z_NUMBER, COURSE.FK_ID_COLLEGE, COURSE.FK_ID_COLLEGEYEAR, COURSE.FK_ID_COLLEGEYEAR02, COURSE.FK_ID_COURSE, COURSE.FK_ID_DEPARTMENT, COURSETOPIC.ID, COURSETOPIC.TITLE, COURSETOPIC.z_NUMBER, COURSETOPIC.FK_ID_COURSE, COLLEGETERM.ID, COLLEGETERM.YEARSEMESTER, COLLEGETERM.FK_ID_COLLEGEYEAR, CAMPUSLOCATION.ID, CAMPUSLOCATION.NAME, CAMPUSLOCATION.FK_ID_ADDRESS, CAMPUSLOCATION.DESCRIPTION, COHORT.ID, COHORT.NAME, COHORT.STARTDATE, COHORT.PROJECTEDENDDATE, COHORT.FK_ID_DEGREETRACK, COHORT.FK_ID_GRADUATIONDATE, FACULTY.ID, FACULTY.STATUS, FACULTY.TYPE, FACULTY.SHORTNAME, FACULTY.ADMINISTRATIVEFACULTYFLAG, FACULTY.DEPARTMENTHEADFLAG, FACULTY.DIVISIONCHAIRFLAG, FACULTY.ADJUNCTFLAG, FACULTY.PARTTIMEFLAG, FACULTY.CREATEDDATETIME, FACULTY.MODIFIEDDATETIME, FACULTY.CREATEDBY, FACULTY.LASTMODIFIEDBY, FACULTY.FK_ID_CAMPUSLOCATION, FACULTY.FK_ID_ADMINISTRATIVEDIVISION, FACULTY.FK_ID_PERSON
FROM MM_CONTACTLIST_CONTAINS_CLASS LEFT JOIN
CLASS ON CLASS.ID = MM_CONTACTLIST_CONTAINS_CLASS.FK_ID_CLASS LEFT JOIN
COURSE ON CLASS.FK_ID_COURSE = COURSE.ID LEFT JOIN
COURSETOPIC ON CLASS.FK_ID_COURSETOPIC = COURSETOPIC.ID LEFT JOIN
COLLEGETERM ON CLASS.FK_ID_COLLEGETERM = COLLEGETERM.ID LEFT JOIN
CAMPUSLOCATION ON CLASS.FK_ID_CAMPUSLOCATION = CAMPUSLOCATION.ID LEFT JOIN
COHORT ON CLASS.FK_ID_COHORT = COHORT.ID LEFT JOIN
FACULTY ON CLASS.FK_ID_FACULTY = FACULTY.ID
WHERE MM_CONTACTLIST_CONTAINS_CLASS.FK_ID_CONTACTLIST = ? ;
DB: jdbc:mysql://localhost:3306/gnecsis_ntcm6?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false&useLegacyDatetimeCode=false&serverTimezone=Europe/London&useSSL=false
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)
com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1019)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
com.quinsoft.zeidon.dbhandler.JdbcHandler$EntityLoader.loadEntities(JdbcHandler.java:757)
com.quinsoft.zeidon.dbhandler.JdbcHandler$EntityLoader.access$300(JdbcHandler.java:728)
com.quinsoft.zeidon.dbhandler.JdbcHandler.executeLoad(JdbcHandler.java:384)
com.quinsoft.zeidon.dbhandler.AbstractSqlHandler.loadEntity(AbstractSqlHandler.java:1375)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activateChildren(ActivateOiFromDB.java:254)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.singleActivate(ActivateOiFromDB.java:338)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:167)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:113)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:42)
com.quinsoft.zeidon.standardoe.ActivateObjectInstance.activate(ActivateObjectInstance.java:102)
com.quinsoft.zeidon.standardoe.AbstractTaskQualification.activateObjectInstance(AbstractTaskQualification.java:127)
com.quinsoft.zeidon.vml.zVIEW.activateObjectInstance(zVIEW.java:553)
com.quinsoft.zeidon.vml.VmlOperation.ActivateObjectInstance(VmlOperation.java:5045)
org.nazarene.nazsis.nFindD_Dialog.PostBuildClassSearch(nFindD_Dialog.java:10094)
org.apache.jsp.nFindDClassSearch_jsp._jspService(nFindDClassSearch_jsp.java:3182)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:67)
javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:376)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:324)
javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

Root Cause

java.sql.SQLSyntaxErrorException: Unknown column 'CLASS.CLASSSTATUS' in 'SELECT'
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)
com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1019)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
com.quinsoft.zeidon.dbhandler.JdbcHandler$EntityLoader.loadEntities(JdbcHandler.java:757)
com.quinsoft.zeidon.dbhandler.JdbcHandler$EntityLoader.access$300(JdbcHandler.java:728)
com.quinsoft.zeidon.dbhandler.JdbcHandler.executeLoad(JdbcHandler.java:384)
com.quinsoft.zeidon.dbhandler.AbstractSqlHandler.loadEntity(AbstractSqlHandler.java:1375)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activateChildren(ActivateOiFromDB.java:254)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.singleActivate(ActivateOiFromDB.java:338)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:167)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:113)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:42)
com.quinsoft.zeidon.standardoe.ActivateObjectInstance.activate(ActivateObjectInstance.java:102)
com.quinsoft.zeidon.standardoe.AbstractTaskQualification.activateObjectInstance(AbstractTaskQualification.java:127)
com.quinsoft.zeidon.vml.zVIEW.activateObjectInstance(zVIEW.java:553)
com.quinsoft.zeidon.vml.VmlOperation.ActivateObjectInstance(VmlOperation.java:5045)
org.nazarene.nazsis.nFindD_Dialog.PostBuildClassSearch(nFindD_Dialog.java:10094)
org.apache.jsp.nFindDClassSearch_jsp._jspService(nFindDClassSearch_jsp.java:3182)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:67)
javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:376)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:324)
javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

Note The full stack trace of the root cause is available in the server logs.

Apache Tomcat/9.0.98