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 rtrim(unit.flat) flat, nvl(rtrim(unit.floor), ' ') floor, unit.unit_id, nvl(unit.gross_area, 0) gross_area, round(nvl(unit.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, 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, decode(mkt_type, '1', '1', '2') mkt_type , transaction_type from unit, floor_order, tmp_unit_color, (select ( select ps.consideration from pis.mdb_pis_unit_tx_mapping ps inner join unit u1 on pis_unit_id = u1.unit_id where p.delivery_date = ps.delivery_date and p.unit_id = ps.pis_unit_id and rownum = 1 and ps.deleted = 'N' and ps.consideration > 10 and ps.noof_unit = 1 and (display_net_area > 0 or mkt_type = '1') and ( ps.instrument_id in ( select inst_id from mltest.pt_inst_type pi where (pi.inst_type in ('ASP', 'SSP','PRE')) or ( ps.delivery_date >= to_date('2023-01-01','YYYY-MM-DD') and ps.delivery_date <= to_date('2023-06-23','YYYY-MM-DD') and pi.inst_type = 'ASS' ) ) or ps.memo_no in ('23030801210058','23032701740111') ) ) as consideration, p.*, ( select distinct p3.consideration from pis.mdb_pis_unit_tx_mapping p3 inner join unit u3 on pis_unit_id = u3.unit_id where rownum =1 and p3.deleted = 'N' and p3.consideration > 10 and p3.noof_unit = 1 and (display_net_area > 0 or mkt_type = '1') and p3.instrument_id in ( select inst_id from mltest.pt_inst_type where inst_type in ('ASP', 'SSP','PRE') ) and p3.pis_unit_id = p.unit_id and p3.delivery_date = ( select max(delivery_date) from pis.mdb_pis_unit_tx_mapping p2 inner join unit u2 on pis_unit_id = u2.unit_id where p2.pis_unit_id = p.unit_id and p2.delivery_date < p.delivery_date and p2.deleted = 'N' and p2.consideration > 10 and p2.noof_unit = 1 and (display_net_area > 0 or mkt_type = '1') and ( p2.instrument_id in ( select inst_id from mltest.pt_inst_type pi where ( pi.inst_type in ('ASP', 'SSP','PRE') or ( p3.delivery_date >= to_date('2023-01-01','YYYY-MM-DD') and p3.delivery_date <= to_date('2023-06-23','YYYY-MM-DD') and pi.inst_type = 'ASS' ) ) ) or p3.memo_no in ('23030801210058','23032701740111') ) ) ) as consideration2 from ( select a.unit_id, a.no_of_tx, a.latest_tx, a.delivery_date, a.mkt_type, b.transaction_type from ( select a.pis_unit_id unit_id, count(0) as no_of_tx, case when trunc(sysdate) - trunc(MAX(a.delivery_date)) < 30 then 1 when trunc(sysdate) - trunc(MAX(a.delivery_date)) < 90 then 2 when trunc(sysdate) - trunc(MAX(a.delivery_date)) < 365 then 3 else 4 end as latest_Tx, trunc(MAX(a.delivery_date)) AS delivery_date, MAX(nvl(to_char(a.mkt_type),'2')) mkt_type from pis.mdb_pis_unit_tx_mapping a inner join unit u on a.pis_unit_id = u.unit_id where ( a.pis_bldg_id = ? and a.pis_unit_id is not null and a.consideration > 10 and a.noof_unit = 1 and (u.display_net_area > 0 or a.mkt_type = '1') and a.deleted = 'N' and a.instrument_id in ( select inst_id from mltest.pt_inst_type pi where ( pi.inst_type in ('ASP', 'SSP','PRE') or ( a.delivery_date >= to_date('2023-01-01','YYYY-MM-DD') and a.delivery_date <= to_date('2023-06-23','YYYY-MM-DD') and pi.inst_type = 'ASS' ) ) ) or memo_no in ('23030801210058','23032701740111') ) group by a.pis_unit_id ) a left join ( select pis_unit_id, delivery_date, deleted, transaction_type, ROW_NUMBER() OVER (PARTITION BY pis_unit_id,delivery_date,deleted ORDER BY instrument_date DESC) as rn from pis.mdb_pis_unit_tx_mapping where deleted = 'N' and pis_bldg_id = ? ) b on b.pis_unit_id = a.unit_id and b.delivery_date = a.delivery_date and b.deleted = 'N' and b.rn = 1 group by a.unit_id, a.no_of_tx, a.latest_tx, a.delivery_date, a.mkt_type, b.transaction_type ) p ) tx where unit.bldg_id = ? and unit.bldg_id = floor_order.bldg_id and nvl(unit.floor, ' ') = nvl(floor_order.floor, ' ') and nvl(unit.room, 0) = tmp_unit_color.room and unit.unit_id = tx.unit_id(+) and trim(unit.unit_type) != 'NON-DOME' order by floor_order.order_seq desc, lpad(rtrim(unit.flat), 5, '0') : 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 rtrim(unit.flat) flat, nvl(rtrim(unit.floor), ' ') floor, unit.unit_id, nvl(unit.gross_area, 0) gross_area, round(nvl(unit.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, 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, decode(mkt_type, '1', '1', '2') mkt_type , transaction_type from unit, floor_order, tmp_unit_color, (select ( select ps.consideration from pis.mdb_pis_unit_tx_mapping ps inner join unit u1 on pis_unit_id = u1.unit_id where p.delivery_date = ps.delivery_date and p.unit_id = ps.pis_unit_id and rownum = 1 and ps.deleted = 'N' and ps.consideration > 10 and ps.noof_unit = 1 and (display_net_area > 0 or mkt_type = '1') and ( ps.instrument_id in ( select inst_id from mltest.pt_inst_type pi where (pi.inst_type in ('ASP', 'SSP','PRE')) or ( ps.delivery_date >= to_date('2023-01-01','YYYY-MM-DD') and ps.delivery_date <= to_date('2023-06-23','YYYY-MM-DD') and pi.inst_type = 'ASS' ) ) or ps.memo_no in ('23030801210058','23032701740111') ) ) as consideration, p.*, ( select distinct p3.consideration from pis.mdb_pis_unit_tx_mapping p3 inner join unit u3 on pis_unit_id = u3.unit_id where rownum =1 and p3.deleted = 'N' and p3.consideration > 10 and p3.noof_unit = 1 and (display_net_area > 0 or mkt_type = '1') and p3.instrument_id in ( select inst_id from mltest.pt_inst_type where inst_type in ('ASP', 'SSP','PRE') ) and p3.pis_unit_id = p.unit_id and p3.delivery_date = ( select max(delivery_date) from pis.mdb_pis_unit_tx_mapping p2 inner join unit u2 on pis_unit_id = u2.unit_id where p2.pis_unit_id = p.unit_id and p2.delivery_date < p.delivery_date and p2.deleted = 'N' and p2.consideration > 10 and p2.noof_unit = 1 and (display_net_area > 0 or mkt_type = '1') and ( p2.instrument_id in ( select inst_id from mltest.pt_inst_type pi where ( pi.inst_type in ('ASP', 'SSP','PRE') or ( p3.delivery_date >= to_date('2023-01-01','YYYY-MM-DD') and p3.delivery_date <= to_date('2023-06-23','YYYY-MM-DD') and pi.inst_type = 'ASS' ) ) ) or p3.memo_no in ('23030801210058','23032701740111') ) ) ) as consideration2 from ( select a.unit_id, a.no_of_tx, a.latest_tx, a.delivery_date, a.mkt_type, b.transaction_type from ( select a.pis_unit_id unit_id, count(0) as no_of_tx, case when trunc(sysdate) - trunc(MAX(a.delivery_date)) < 30 then 1 when trunc(sysdate) - trunc(MAX(a.delivery_date)) < 90 then 2 when trunc(sysdate) - trunc(MAX(a.delivery_date)) < 365 then 3 else 4 end as latest_Tx, trunc(MAX(a.delivery_date)) AS delivery_date, MAX(nvl(to_char(a.mkt_type),'2')) mkt_type from pis.mdb_pis_unit_tx_mapping a inner join unit u on a.pis_unit_id = u.unit_id where ( a.pis_bldg_id = ? and a.pis_unit_id is not null and a.consideration > 10 and a.noof_unit = 1 and (u.display_net_area > 0 or a.mkt_type = '1') and a.deleted = 'N' and a.instrument_id in ( select inst_id from mltest.pt_inst_type pi where ( pi.inst_type in ('ASP', 'SSP','PRE') or ( a.delivery_date >= to_date('2023-01-01','YYYY-MM-DD') and a.delivery_date <= to_date('2023-06-23','YYYY-MM-DD') and pi.inst_type = 'ASS' ) ) ) or memo_no in ('23030801210058','23032701740111') ) group by a.pis_unit_id ) a left join ( select pis_unit_id, delivery_date, deleted, transaction_type, ROW_NUMBER() OVER (PARTITION BY pis_unit_id,delivery_date,deleted ORDER BY instrument_date DESC) as rn from pis.mdb_pis_unit_tx_mapping where deleted = 'N' and pis_bldg_id = ? ) b on b.pis_unit_id = a.unit_id and b.delivery_date = a.delivery_date and b.deleted = 'N' and b.rn = 1 group by a.unit_id, a.no_of_tx, a.latest_tx, a.delivery_date, a.mkt_type, b.transaction_type ) p ) tx where unit.bldg_id = ? and unit.bldg_id = floor_order.bldg_id and nvl(unit.floor, ' ') = nvl(floor_order.floor, ' ') and nvl(unit.room, 0) = tmp_unit_color.room and unit.unit_id = tx.unit_id(+) and trim(unit.unit_type) != 'NON-DOME' order by floor_order.order_seq desc, lpad(rtrim(unit.flat), 5, '0') : 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 rtrim(unit.flat) flat, nvl(rtrim(unit.floor), ' ') floor, unit.unit_id, nvl(unit.gross_area, 0) gross_area, round(nvl(unit.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, 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, decode(mkt_type, '1', '1', '2') mkt_type , transaction_type from unit, floor_order, tmp_unit_color, (select ( select ps.consideration from pis.mdb_pis_unit_tx_mapping ps inner join unit u1 on pis_unit_id = u1.unit_id where p.delivery_date = ps.delivery_date and p.unit_id = ps.pis_unit_id and rownum = 1 and ps.deleted = 'N' and ps.consideration > 10 and ps.noof_unit = 1 and (display_net_area > 0 or mkt_type = '1') and ( ps.instrument_id in ( select inst_id from mltest.pt_inst_type pi where (pi.inst_type in ('ASP', 'SSP','PRE')) or ( ps.delivery_date >= to_date('2023-01-01','YYYY-MM-DD') and ps.delivery_date <= to_date('2023-06-23','YYYY-MM-DD') and pi.inst_type = 'ASS' ) ) or ps.memo_no in ('23030801210058','23032701740111') ) ) as consideration, p.*, ( select distinct p3.consideration from pis.mdb_pis_unit_tx_mapping p3 inner join unit u3 on pis_unit_id = u3.unit_id where rownum =1 and p3.deleted = 'N' and p3.consideration > 10 and p3.noof_unit = 1 and (display_net_area > 0 or mkt_type = '1') and p3.instrument_id in ( select inst_id from mltest.pt_inst_type where inst_type in ('ASP', 'SSP','PRE') ) and p3.pis_unit_id = p.unit_id and p3.delivery_date = ( select max(delivery_date) from pis.mdb_pis_unit_tx_mapping p2 inner join unit u2 on pis_unit_id = u2.unit_id where p2.pis_unit_id = p.unit_id and p2.delivery_date < p.delivery_date and p2.deleted = 'N' and p2.consideration > 10 and p2.noof_unit = 1 and (display_net_area > 0 or mkt_type = '1') and ( p2.instrument_id in ( select inst_id from mltest.pt_inst_type pi where ( pi.inst_type in ('ASP', 'SSP','PRE') or ( p3.delivery_date >= to_date('2023-01-01','YYYY-MM-DD') and p3.delivery_date <= to_date('2023-06-23','YYYY-MM-DD') and pi.inst_type = 'ASS' ) ) ) or p3.memo_no in ('23030801210058','23032701740111') ) ) ) as consideration2 from ( select a.unit_id, a.no_of_tx, a.latest_tx, a.delivery_date, a.mkt_type, b.transaction_type from ( select a.pis_unit_id unit_id, count(0) as no_of_tx, case when trunc(sysdate) - trunc(MAX(a.delivery_date)) < 30 then 1 when trunc(sysdate) - trunc(MAX(a.delivery_date)) < 90 then 2 when trunc(sysdate) - trunc(MAX(a.delivery_date)) < 365 then 3 else 4 end as latest_Tx, trunc(MAX(a.delivery_date)) AS delivery_date, MAX(nvl(to_char(a.mkt_type),'2')) mkt_type from pis.mdb_pis_unit_tx_mapping a inner join unit u on a.pis_unit_id = u.unit_id where ( a.pis_bldg_id = ? and a.pis_unit_id is not null and a.consideration > 10 and a.noof_unit = 1 and (u.display_net_area > 0 or a.mkt_type = '1') and a.deleted = 'N' and a.instrument_id in ( select inst_id from mltest.pt_inst_type pi where ( pi.inst_type in ('ASP', 'SSP','PRE') or ( a.delivery_date >= to_date('2023-01-01','YYYY-MM-DD') and a.delivery_date <= to_date('2023-06-23','YYYY-MM-DD') and pi.inst_type = 'ASS' ) ) ) or memo_no in ('23030801210058','23032701740111') ) group by a.pis_unit_id ) a left join ( select pis_unit_id, delivery_date, deleted, transaction_type, ROW_NUMBER() OVER (PARTITION BY pis_unit_id,delivery_date,deleted ORDER BY instrument_date DESC) as rn from pis.mdb_pis_unit_tx_mapping where deleted = 'N' and pis_bldg_id = ? ) b on b.pis_unit_id = a.unit_id and b.delivery_date = a.delivery_date and b.deleted = 'N' and b.rn = 1 group by a.unit_id, a.no_of_tx, a.latest_tx, a.delivery_date, a.mkt_type, b.transaction_type ) p ) tx where unit.bldg_id = ? and unit.bldg_id = floor_order.bldg_id and nvl(unit.floor, ' ') = nvl(floor_order.floor, ' ') and nvl(unit.room, 0) = tmp_unit_color.room and unit.unit_id = tx.unit_id(+) and trim(unit.unit_type) != 'NON-DOME' order by floor_order.order_seq desc, lpad(rtrim(unit.flat), 5, '0') : 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_005f11(index_005fexecute_jsp.java:6535) org.apache.jsp.index_005fexecute_jsp._jspService(index_005fexecute_jsp.java:423) 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.