HTTP Status 500 – Internal Server Error


Type Exception Report

Message javax.servlet.ServletException: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

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

Exception

org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:582)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:488)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:583)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:203)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:181)
	org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:333)
	org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:155)

Root Cause

javax.servlet.ServletException: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:907)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:833)
	org.apache.jsp.dashboard.statewisedwdb_005fclaim_jsp._jspService(statewisedwdb_005fclaim_jsp.java:458)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:583)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:465)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:583)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:203)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:181)
	org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:333)
	org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:155)

Root Cause

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
	oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
	oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
	oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
	oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498)
	oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
	sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
	com.sun.proxy.$Proxy8.executeQuery(Unknown Source)
	pkgPmegpNew.DBCon.execSQL(DBCon.java:63)
	org.apache.jsp.dashboard.statewisedwdb_005fclaim_jsp._jspService(statewisedwdb_005fclaim_jsp.java:334)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:583)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:465)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:583)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:203)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:181)
	org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:333)
	org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:155)

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


Apache Tomcat/8.5.98