type Exception report
message javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.ServletException: javax.servlet.jsp.JspException:
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.ServletException: javax.servlet.jsp.JspException: select ' ' flat, Initcap(CASE WHEN ? IN ('en', 'eng') then rtrim(b.eng_name) else rtrim(b.chi_name) end) floor, u.unit_id, nvl(u.gross_area, 0) as gross_area, round(nvl(u.display_net_area, 0), 0) net_area, case when color = '#E7FEFD' then '#EBF4F8' when color = '#F7EEFF' then '#fff6e8' when color = '#EBCDFA' then '#e7f8d1' else color end as color, nvl(no_of_tx, 0) no_of_tx, rtrim(ps.chi_name) prop_style, latest_Tx,case when not consideration is null then CASE when ? = 10000 then round(consideration / 10000,0) else round(consideration / 1000000,2) end else null end as consideration, case when not consideration2 is null then CASE when ? = 10000 then round(consideration2 / 10000,0) else round(consideration2 / 1000000,2) end else null end as consideration2, CASE WHEN ? IN ('en', 'eng') then TO_CHAR(delivery_date, 'YYYY') else TO_CHAR(delivery_date, 'YY') end as instrument_date, case when consideration2 =0 then 0 else round( consideration *100 / consideration2 -100,2) end as perc, nvl(to_char(mkt_type),'2') mkt_type , transaction_type from unit u, building b, prop_style ps, tmp_unit_color, (select (select ps.consideration from pis.mdb_pis_unit_tx_mapping ps where p.delivery_date = ps.delivery_date and p.unit_id = ps.pis_unit_id and rownum = 1) as consideration, p.*, ( select distinct p3.consideration from pis.mdb_pis_unit_tx_mapping p3 where rownum =1 and p3.pis_unit_id = p.unit_id and p3.delivery_date = (select max(delivery_date) from pis.mdb_pis_unit_tx_mapping p2 where p2.pis_unit_id = p.unit_id and p2.delivery_date < p.delivery_date) ) as consideration2 from ( select p.*, case when b.transaction_type is not null then transaction_type else null end transaction_type from ( select pis_unit_id unit_id, count(0) no_of_tx, case when trunc(sysdate) - trunc(MAX(delivery_date)) < 30 then 1 when trunc(sysdate) - trunc(MAX(delivery_date)) < 90 then 2 when trunc(sysdate) - trunc(MAX(delivery_date)) < 365 then 3 else 4 end as latest_Tx, trunc(MAX(delivery_date)) AS delivery_date, MAX(nvl(to_char(mkt_type),'2')) mkt_type from mdb_pis_unit_tx_mapping su, building sb where su.pis_bldg_id = sb.bldg_id and sb.est_id = rpad(?, 10, ' ') and sb.street_id = rpad(?, 10, ' ') and (sb.deleted is null or sb.deleted = 'N') and (su.deleted is null or su.deleted = 'N') and pis_unit_id is not null and consideration > 0 and exists (select 1 from mltest.pt_inst_type where inst_type in ('ASP', 'SSP') and inst_id = instrument_id) group by pis_unit_id ) p left join pis.mdb_pis_unit_tx_mapping b on b.pis_unit_id = p.unit_id and b.delivery_date = p.delivery_date and b.deleted = 'N' ) p ) tx where u.bldg_id = b.bldg_id and b.prop_style_id = ps.style_id(+) and b.bldg_type = 'HOUSE' and b.est_id = rpad(?, 10, ' ') and b.street_id = rpad(?, 10, ' ') and (b.deleted is null or b.deleted = 'N') and rtrim(b.chi_name) is not null and nvl(u.room, 0) = tmp_unit_color.room and u.unit_id = tx.unit_id(+) and trim(u.unit_type) != 'NON-DOME' order by replace(translate(b.chi_name, '0123456789', ' '),' ',''), replace(translate(b.chi_name, translate(b.chi_name, '0123456789', 'k'), ' '),' ','') + 1 : Closed Statement: getMetaData org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:561) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:462) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) com.midland.commons.filters.CORSFilter.doFilter(CORSFilter.java:32) org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88) filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
root cause
javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.ServletException: javax.servlet.jsp.JspException: select ' ' flat, Initcap(CASE WHEN ? IN ('en', 'eng') then rtrim(b.eng_name) else rtrim(b.chi_name) end) floor, u.unit_id, nvl(u.gross_area, 0) as gross_area, round(nvl(u.display_net_area, 0), 0) net_area, case when color = '#E7FEFD' then '#EBF4F8' when color = '#F7EEFF' then '#fff6e8' when color = '#EBCDFA' then '#e7f8d1' else color end as color, nvl(no_of_tx, 0) no_of_tx, rtrim(ps.chi_name) prop_style, latest_Tx,case when not consideration is null then CASE when ? = 10000 then round(consideration / 10000,0) else round(consideration / 1000000,2) end else null end as consideration, case when not consideration2 is null then CASE when ? = 10000 then round(consideration2 / 10000,0) else round(consideration2 / 1000000,2) end else null end as consideration2, CASE WHEN ? IN ('en', 'eng') then TO_CHAR(delivery_date, 'YYYY') else TO_CHAR(delivery_date, 'YY') end as instrument_date, case when consideration2 =0 then 0 else round( consideration *100 / consideration2 -100,2) end as perc, nvl(to_char(mkt_type),'2') mkt_type , transaction_type from unit u, building b, prop_style ps, tmp_unit_color, (select (select ps.consideration from pis.mdb_pis_unit_tx_mapping ps where p.delivery_date = ps.delivery_date and p.unit_id = ps.pis_unit_id and rownum = 1) as consideration, p.*, ( select distinct p3.consideration from pis.mdb_pis_unit_tx_mapping p3 where rownum =1 and p3.pis_unit_id = p.unit_id and p3.delivery_date = (select max(delivery_date) from pis.mdb_pis_unit_tx_mapping p2 where p2.pis_unit_id = p.unit_id and p2.delivery_date < p.delivery_date) ) as consideration2 from ( select p.*, case when b.transaction_type is not null then transaction_type else null end transaction_type from ( select pis_unit_id unit_id, count(0) no_of_tx, case when trunc(sysdate) - trunc(MAX(delivery_date)) < 30 then 1 when trunc(sysdate) - trunc(MAX(delivery_date)) < 90 then 2 when trunc(sysdate) - trunc(MAX(delivery_date)) < 365 then 3 else 4 end as latest_Tx, trunc(MAX(delivery_date)) AS delivery_date, MAX(nvl(to_char(mkt_type),'2')) mkt_type from mdb_pis_unit_tx_mapping su, building sb where su.pis_bldg_id = sb.bldg_id and sb.est_id = rpad(?, 10, ' ') and sb.street_id = rpad(?, 10, ' ') and (sb.deleted is null or sb.deleted = 'N') and (su.deleted is null or su.deleted = 'N') and pis_unit_id is not null and consideration > 0 and exists (select 1 from mltest.pt_inst_type where inst_type in ('ASP', 'SSP') and inst_id = instrument_id) group by pis_unit_id ) p left join pis.mdb_pis_unit_tx_mapping b on b.pis_unit_id = p.unit_id and b.delivery_date = p.delivery_date and b.deleted = 'N' ) p ) tx where u.bldg_id = b.bldg_id and b.prop_style_id = ps.style_id(+) and b.bldg_type = 'HOUSE' and b.est_id = rpad(?, 10, ' ') and b.street_id = rpad(?, 10, ' ') and (b.deleted is null or b.deleted = 'N') and rtrim(b.chi_name) is not null and nvl(u.room, 0) = tmp_unit_color.room and u.unit_id = tx.unit_id(+) and trim(u.unit_type) != 'NON-DOME' order by replace(translate(b.chi_name, '0123456789', ' '),' ',''), replace(translate(b.chi_name, translate(b.chi_name, '0123456789', 'k'), ' '),' ','') + 1 : Closed Statement: getMetaData org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:912) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845) org.apache.jsp.index_jsp._jspService(index_jsp.java:189) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) com.midland.commons.filters.CORSFilter.doFilter(CORSFilter.java:32) org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88) filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
root cause
javax.servlet.ServletException: javax.servlet.jsp.JspException: select ' ' flat, Initcap(CASE WHEN ? IN ('en', 'eng') then rtrim(b.eng_name) else rtrim(b.chi_name) end) floor, u.unit_id, nvl(u.gross_area, 0) as gross_area, round(nvl(u.display_net_area, 0), 0) net_area, case when color = '#E7FEFD' then '#EBF4F8' when color = '#F7EEFF' then '#fff6e8' when color = '#EBCDFA' then '#e7f8d1' else color end as color, nvl(no_of_tx, 0) no_of_tx, rtrim(ps.chi_name) prop_style, latest_Tx,case when not consideration is null then CASE when ? = 10000 then round(consideration / 10000,0) else round(consideration / 1000000,2) end else null end as consideration, case when not consideration2 is null then CASE when ? = 10000 then round(consideration2 / 10000,0) else round(consideration2 / 1000000,2) end else null end as consideration2, CASE WHEN ? IN ('en', 'eng') then TO_CHAR(delivery_date, 'YYYY') else TO_CHAR(delivery_date, 'YY') end as instrument_date, case when consideration2 =0 then 0 else round( consideration *100 / consideration2 -100,2) end as perc, nvl(to_char(mkt_type),'2') mkt_type , transaction_type from unit u, building b, prop_style ps, tmp_unit_color, (select (select ps.consideration from pis.mdb_pis_unit_tx_mapping ps where p.delivery_date = ps.delivery_date and p.unit_id = ps.pis_unit_id and rownum = 1) as consideration, p.*, ( select distinct p3.consideration from pis.mdb_pis_unit_tx_mapping p3 where rownum =1 and p3.pis_unit_id = p.unit_id and p3.delivery_date = (select max(delivery_date) from pis.mdb_pis_unit_tx_mapping p2 where p2.pis_unit_id = p.unit_id and p2.delivery_date < p.delivery_date) ) as consideration2 from ( select p.*, case when b.transaction_type is not null then transaction_type else null end transaction_type from ( select pis_unit_id unit_id, count(0) no_of_tx, case when trunc(sysdate) - trunc(MAX(delivery_date)) < 30 then 1 when trunc(sysdate) - trunc(MAX(delivery_date)) < 90 then 2 when trunc(sysdate) - trunc(MAX(delivery_date)) < 365 then 3 else 4 end as latest_Tx, trunc(MAX(delivery_date)) AS delivery_date, MAX(nvl(to_char(mkt_type),'2')) mkt_type from mdb_pis_unit_tx_mapping su, building sb where su.pis_bldg_id = sb.bldg_id and sb.est_id = rpad(?, 10, ' ') and sb.street_id = rpad(?, 10, ' ') and (sb.deleted is null or sb.deleted = 'N') and (su.deleted is null or su.deleted = 'N') and pis_unit_id is not null and consideration > 0 and exists (select 1 from mltest.pt_inst_type where inst_type in ('ASP', 'SSP') and inst_id = instrument_id) group by pis_unit_id ) p left join pis.mdb_pis_unit_tx_mapping b on b.pis_unit_id = p.unit_id and b.delivery_date = p.delivery_date and b.deleted = 'N' ) p ) tx where u.bldg_id = b.bldg_id and b.prop_style_id = ps.style_id(+) and b.bldg_type = 'HOUSE' and b.est_id = rpad(?, 10, ' ') and b.street_id = rpad(?, 10, ' ') and (b.deleted is null or b.deleted = 'N') and rtrim(b.chi_name) is not null and nvl(u.room, 0) = tmp_unit_color.room and u.unit_id = tx.unit_id(+) and trim(u.unit_type) != 'NON-DOME' order by replace(translate(b.chi_name, '0123456789', ' '),' ',''), replace(translate(b.chi_name, translate(b.chi_name, '0123456789', 'k'), ' '),' ','') + 1 : Closed Statement: getMetaData org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:912) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845) org.apache.jsp.index_005fexecute_jsp._jspService(index_005fexecute_jsp.java:1552) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.taglibs.standard.tag.common.core.ImportSupport.acquireString(ImportSupport.java:296) org.apache.taglibs.standard.tag.common.core.ImportSupport.doEndTag(ImportSupport.java:161) org.apache.jsp.index_jsp._jspx_meth_c_005fimport_005f0(index_jsp.java:622) org.apache.jsp.index_jsp._jspx_meth_c_005fset_005f3(index_jsp.java:587) org.apache.jsp.index_jsp._jspService(index_jsp.java:155) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) com.midland.commons.filters.CORSFilter.doFilter(CORSFilter.java:32) org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88) filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
root cause
java.sql.SQLException: Closed Statement: getMetaData oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:128) org.apache.taglibs.standard.tag.common.sql.ResultImpl.<init>(ResultImpl.java:64) org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:217) org.apache.jsp.index_005fexecute_jsp._jspx_meth_sql_005fquery_005f17(index_005fexecute_jsp.java:8012) org.apache.jsp.index_005fexecute_jsp._jspService(index_005fexecute_jsp.java:573) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.taglibs.standard.tag.common.core.ImportSupport.acquireString(ImportSupport.java:296) org.apache.taglibs.standard.tag.common.core.ImportSupport.doEndTag(ImportSupport.java:161) org.apache.jsp.index_jsp._jspx_meth_c_005fimport_005f0(index_jsp.java:622) org.apache.jsp.index_jsp._jspx_meth_c_005fset_005f3(index_jsp.java:587) org.apache.jsp.index_jsp._jspService(index_jsp.java:155) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) com.midland.commons.filters.CORSFilter.doFilter(CORSFilter.java:32) org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88) filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.73 logs.