金會員：20年或以上

HTTP Status 500 - javax.servlet.ServletException: javax.servlet.jsp.JspException:

type Exception report

message 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: 
    select initcap(e.nickname) as nickname, 
       initcap(e.ENG_SURNAME) as eng_surname,
       initcap(e.eng_other_name) as eng_other_name,
       case when d.org_code = 'HKP' 
            then ht.chi_title
            when d.org_code = 'MR' and d.market_type in ('I', 'S', 'O')
            then it.chi_title
            else t.chi_title 
         end as chi_title,
       d.ALT_CHI_NAME,
       e.join_date,
       case when d.org_code = 'MR' and d.dept_type ='S' and d.market_type = 'R' and d.region_id in ('HK', 'KLN', 'NT') then '美聯住宅'
       		when d.org_code = 'HKP' and d.dept_type ='S' and d.market_type = 'R' and d.region_id in ('HK', 'KLN', 'NT')
       		then '港罝住宅'
       		when d.dept_type ='S' and d.market_type in ('I', 'S', 'O') and substr(dept_code, 0, 3) not in ('ICB', 'ICH', 'ICO', 'ICM') and region_id is null
       		then '美聯工商舖'
       		when d.dept_type ='S' and d.market_type in ('I', 'S', 'O') and substr(dept_code, 0, 3) in ('ICB', 'ICH', 'ICO', 'ICM') and region_id is null
       		then '港罝工商舖'
       		when d.dept_type = 'B' and region_id is null
       		then '中央專業部門'
       		else '其他'
       	end as sbu
  from employee e
 inner join department d on e.dept_id = d.dept_id
 left join title t on e.title_id = t.title_id and d.org_code = 'MR'
 left join hkp_title ht on e.title_id = ht.title_id and d.org_code = 'HKP'
 left join ics_title it on e.title_id = it.title_id and d.org_code = 'MR' and d.market_type in ('I', 'S', 'O')
 where (trunc(e.join_date) > add_months(trunc(sysdate), ?))
   and (trunc(e.join_date) <= add_months(trunc(sysdate), ?))
   and d.status = 'N'
   and e.term_date is null
   and dept_type <> 'M'
   
	   
	   
	   
	   
	   
	   
	   
	   		and (
	   			( region_id is null and dept_type = 'B') 
	   		 OR ( d.dept_code = 'MICS' )
	   		 OR ( d.dept_code LIKE 'C_OS3%')
	   		 OR ( d.org_code = 'MR' and d.dept_type ='S' and d.market_type = 'R' and d.region_id in ('HK', 'KLN', 'NT'))
	   		 OR ( d.org_code = 'HKP' and d.dept_type ='S' and d.market_type = 'R' and d.region_id in ('HK', 'KLN', 'NT'))
			 OR ( d.dept_type ='S' and d.market_type in ('I', 'S', 'O') and substr(dept_code, 0, 3) not in ('ICB', 'ICH', 'ICO', 'ICM') and region_id is null)
			 OR ( d.dept_type ='S' and d.market_type in ('I', 'S', 'O') and substr(dept_code, 0, 3) in ('ICB', 'ICH', 'ICO', 'ICM') and region_id is null))

	   
   
 order by nickname
 
 
: ORA-01013: user requested cancel of current operation

	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.midland.commons.filters.EnvironmentFilter.doFilter(EnvironmentFilter.java:23)
	org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
	org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
	com.midland.commons.filters.CORSFilter.doFilter(CORSFilter.java:32)

root cause

javax.servlet.ServletException: javax.servlet.jsp.JspException: 
    select initcap(e.nickname) as nickname, 
       initcap(e.ENG_SURNAME) as eng_surname,
       initcap(e.eng_other_name) as eng_other_name,
       case when d.org_code = 'HKP' 
            then ht.chi_title
            when d.org_code = 'MR' and d.market_type in ('I', 'S', 'O')
            then it.chi_title
            else t.chi_title 
         end as chi_title,
       d.ALT_CHI_NAME,
       e.join_date,
       case when d.org_code = 'MR' and d.dept_type ='S' and d.market_type = 'R' and d.region_id in ('HK', 'KLN', 'NT') then '美聯住宅'
       		when d.org_code = 'HKP' and d.dept_type ='S' and d.market_type = 'R' and d.region_id in ('HK', 'KLN', 'NT')
       		then '港罝住宅'
       		when d.dept_type ='S' and d.market_type in ('I', 'S', 'O') and substr(dept_code, 0, 3) not in ('ICB', 'ICH', 'ICO', 'ICM') and region_id is null
       		then '美聯工商舖'
       		when d.dept_type ='S' and d.market_type in ('I', 'S', 'O') and substr(dept_code, 0, 3) in ('ICB', 'ICH', 'ICO', 'ICM') and region_id is null
       		then '港罝工商舖'
       		when d.dept_type = 'B' and region_id is null
       		then '中央專業部門'
       		else '其他'
       	end as sbu
  from employee e
 inner join department d on e.dept_id = d.dept_id
 left join title t on e.title_id = t.title_id and d.org_code = 'MR'
 left join hkp_title ht on e.title_id = ht.title_id and d.org_code = 'HKP'
 left join ics_title it on e.title_id = it.title_id and d.org_code = 'MR' and d.market_type in ('I', 'S', 'O')
 where (trunc(e.join_date) > add_months(trunc(sysdate), ?))
   and (trunc(e.join_date) <= add_months(trunc(sysdate), ?))
   and d.status = 'N'
   and e.term_date is null
   and dept_type <> 'M'
   
	   
	   
	   
	   
	   
	   
	   
	   		and (
	   			( region_id is null and dept_type = 'B') 
	   		 OR ( d.dept_code = 'MICS' )
	   		 OR ( d.dept_code LIKE 'C_OS3%')
	   		 OR ( d.org_code = 'MR' and d.dept_type ='S' and d.market_type = 'R' and d.region_id in ('HK', 'KLN', 'NT'))
	   		 OR ( d.org_code = 'HKP' and d.dept_type ='S' and d.market_type = 'R' and d.region_id in ('HK', 'KLN', 'NT'))
			 OR ( d.dept_type ='S' and d.market_type in ('I', 'S', 'O') and substr(dept_code, 0, 3) not in ('ICB', 'ICH', 'ICO', 'ICM') and region_id is null)
			 OR ( d.dept_type ='S' and d.market_type in ('I', 'S', 'O') and substr(dept_code, 0, 3) in ('ICB', 'ICH', 'ICO', 'ICM') and region_id is null))

	   
   
 order by nickname
 
 
: ORA-01013: user requested cancel of current operation

	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:901)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:834)
	org.apache.jsp.get_005femployee_jsp._jspService(get_005femployee_jsp.java:208)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.midland.commons.filters.EnvironmentFilter.doFilter(EnvironmentFilter.java:23)
	org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
	org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
	com.midland.commons.filters.CORSFilter.doFilter(CORSFilter.java:32)

root cause

java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
	oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
	oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
	oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
	oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
	oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
	oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:957)
	oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1104)
	oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
	oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
	oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
	sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:483)
	org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:233)
	com.sun.proxy.$Proxy169.executeQuery(Unknown Source)
	sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:483)
	org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:233)
	com.sun.proxy.$Proxy169.executeQuery(Unknown Source)
	sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:483)
	org.apache.tomcat.jdbc.pool.interceptor.StatementDecoratorInterceptor$StatementProxy.invoke(StatementDecoratorInterceptor.java:249)
	com.sun.proxy.$Proxy169.executeQuery(Unknown Source)
	org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:224)
	org.apache.jsp.get_005femployee_jsp._jspx_meth_sql_005fquery_005f0(get_005femployee_jsp.java:294)
	org.apache.jsp.get_005femployee_jsp._jspService(get_005femployee_jsp.java:128)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.midland.commons.filters.EnvironmentFilter.doFilter(EnvironmentFilter.java:23)
	org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
	org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
	com.midland.commons.filters.CORSFilter.doFilter(CORSFilter.java:32)

note The full stack trace of the root cause is available in the Apache Tomcat/8.0.14 logs.

Apache Tomcat/8.0.14