HTTP Status 500 – Internal Server Error


Type Exception Report

Message javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.ServletException: javax.servlet.jsp.JspException:

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

Exception

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.ServletException: javax.servlet.jsp.JspException: 
        SELECT lvl.edulevelid, lvl.edulevel 
        FROM edulevel lvl
        where lvl.seqno >0 
        and exists (select * from program p, openprogram op 
        where lvl.edulevelid = p.edulevelid 
        and p.campusid=
        and op.programid=p.programid)
        order by lvl.seqno
    : ORA-00936: ไม่มีเอ็กซ์เพรสชัน

	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:639)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:500)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Root Cause

javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.ServletException: javax.servlet.jsp.JspException: 
        SELECT lvl.edulevelid, lvl.edulevel 
        FROM edulevel lvl
        where lvl.seqno >0 
        and exists (select * from program p, openprogram op 
        where lvl.edulevelid = p.edulevelid 
        and p.campusid=
        and op.programid=p.programid)
        order by lvl.seqno
    : ORA-00936: ไม่มีเอ็กซ์เพรสชัน

	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:663)
	org.apache.jsp.applicant.expend_jsp._jspService(expend_jsp.java:179)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Root Cause

javax.servlet.ServletException: javax.servlet.jsp.JspException: 
        SELECT lvl.edulevelid, lvl.edulevel 
        FROM edulevel lvl
        where lvl.seqno >0 
        and exists (select * from program p, openprogram op 
        where lvl.edulevelid = p.edulevelid 
        and p.campusid=
        and op.programid=p.programid)
        order by lvl.seqno
    : ORA-00936: ไม่มีเอ็กซ์เพรสชัน

	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:663)
	org.apache.jsp.applicant.expend_frm_jsp._jspService(expend_frm_jsp.java:173)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.taglibs.standard.tag.common.core.ImportSupport.acquireString(ImportSupport.java:296)
	org.apache.taglibs.standard.tag.common.core.ImportSupport.doEndTag(ImportSupport.java:158)
	org.apache.jsp.applicant.expend_jsp._jspx_meth_c_005fimport_005f2(expend_jsp.java:459)
	org.apache.jsp.applicant.expend_jsp._jspService(expend_jsp.java:162)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Root Cause

java.sql.SQLSyntaxErrorException: ORA-00936: ไม่มีเอ็กซ์เพรสชัน

	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
	oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
	oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
	oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
	oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
	oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
	oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
	oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
	oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
	oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
	oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
	org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
	org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
	org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:215)
	org.apache.jsp.applicant.expend_frm_jsp._jspx_meth_sql_005fquery_005f0(expend_frm_jsp.java:258)
	org.apache.jsp.applicant.expend_frm_jsp._jspService(expend_frm_jsp.java:154)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.taglibs.standard.tag.common.core.ImportSupport.acquireString(ImportSupport.java:296)
	org.apache.taglibs.standard.tag.common.core.ImportSupport.doEndTag(ImportSupport.java:158)
	org.apache.jsp.applicant.expend_jsp._jspx_meth_c_005fimport_005f2(expend_jsp.java:459)
	org.apache.jsp.applicant.expend_jsp._jspService(expend_jsp.java:162)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

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


Apache Tomcat/9.0.41