HTTP Status 500 – Internal Server Error


Type Exception Report

Message Unable to compile class for JSP:

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

Exception

org.apache.jasper.JasperException: Unable to compile class for JSP: 

An error occurred at line: [144] in the jsp file: [/ciutat/estadistiques/poblacio/padro/taulaedats.jsp]
dataTractar cannot be resolved to a variable
141: "select e.edat, nvl(h.homes, 0) homes, nvl(d.dones, 0) dones from " +
142: 
143: "edats110 e left outer join " +
144: "(select floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425) edat, count(*) homes " +
145: "from genesys5.hab_movhabs where ((datafinal > '"+dataTractar+"') or (datafinal = ' ')) and (datainicial <= '"+dataTractar+"') and " +
146: "(movtip <> 'B' or datagr = '99991231') and perssexe = '1' and (distcod=? or ? is null) " +
147: "group by floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425)) h on (e.edat = h.edat), " +


An error occurred at line: [145] in the jsp file: [/ciutat/estadistiques/poblacio/padro/taulaedats.jsp]
dataTractar cannot be resolved to a variable
142: 
143: "edats110 e left outer join " +
144: "(select floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425) edat, count(*) homes " +
145: "from genesys5.hab_movhabs where ((datafinal > '"+dataTractar+"') or (datafinal = ' ')) and (datainicial <= '"+dataTractar+"') and " +
146: "(movtip <> 'B' or datagr = '99991231') and perssexe = '1' and (distcod=? or ? is null) " +
147: "group by floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425)) h on (e.edat = h.edat), " +
148: 


An error occurred at line: [145] in the jsp file: [/ciutat/estadistiques/poblacio/padro/taulaedats.jsp]
dataTractar cannot be resolved to a variable
142: 
143: "edats110 e left outer join " +
144: "(select floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425) edat, count(*) homes " +
145: "from genesys5.hab_movhabs where ((datafinal > '"+dataTractar+"') or (datafinal = ' ')) and (datainicial <= '"+dataTractar+"') and " +
146: "(movtip <> 'B' or datagr = '99991231') and perssexe = '1' and (distcod=? or ? is null) " +
147: "group by floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425)) h on (e.edat = h.edat), " +
148: 


An error occurred at line: [147] in the jsp file: [/ciutat/estadistiques/poblacio/padro/taulaedats.jsp]
dataTractar cannot be resolved to a variable
144: "(select floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425) edat, count(*) homes " +
145: "from genesys5.hab_movhabs where ((datafinal > '"+dataTractar+"') or (datafinal = ' ')) and (datainicial <= '"+dataTractar+"') and " +
146: "(movtip <> 'B' or datagr = '99991231') and perssexe = '1' and (distcod=? or ? is null) " +
147: "group by floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425)) h on (e.edat = h.edat), " +
148: 
149: 
150: "edats110 e2 left outer join " +


An error occurred at line: [151] in the jsp file: [/ciutat/estadistiques/poblacio/padro/taulaedats.jsp]
dataTractar cannot be resolved to a variable
148: 
149: 
150: "edats110 e2 left outer join " +
151: "(select floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425) edat, count(*) dones " +
152: "from genesys5.hab_movhabs where ((datafinal > '"+dataTractar+"') or (datafinal = ' ')) and (datainicial <= '"+dataTractar+"') and " +
153: "(movtip <> 'B' or datagr = '99991231') and perssexe = '2' and (distcod=? or ? is null) " +
154: "group by floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425)) d on (e2.edat = d.edat) " +


An error occurred at line: [152] in the jsp file: [/ciutat/estadistiques/poblacio/padro/taulaedats.jsp]
dataTractar cannot be resolved to a variable
149: 
150: "edats110 e2 left outer join " +
151: "(select floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425) edat, count(*) dones " +
152: "from genesys5.hab_movhabs where ((datafinal > '"+dataTractar+"') or (datafinal = ' ')) and (datainicial <= '"+dataTractar+"') and " +
153: "(movtip <> 'B' or datagr = '99991231') and perssexe = '2' and (distcod=? or ? is null) " +
154: "group by floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425)) d on (e2.edat = d.edat) " +
155: 


An error occurred at line: [152] in the jsp file: [/ciutat/estadistiques/poblacio/padro/taulaedats.jsp]
dataTractar cannot be resolved to a variable
149: 
150: "edats110 e2 left outer join " +
151: "(select floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425) edat, count(*) dones " +
152: "from genesys5.hab_movhabs where ((datafinal > '"+dataTractar+"') or (datafinal = ' ')) and (datainicial <= '"+dataTractar+"') and " +
153: "(movtip <> 'B' or datagr = '99991231') and perssexe = '2' and (distcod=? or ? is null) " +
154: "group by floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425)) d on (e2.edat = d.edat) " +
155: 


An error occurred at line: [154] in the jsp file: [/ciutat/estadistiques/poblacio/padro/taulaedats.jsp]
dataTractar cannot be resolved to a variable
151: "(select floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425) edat, count(*) dones " +
152: "from genesys5.hab_movhabs where ((datafinal > '"+dataTractar+"') or (datafinal = ' ')) and (datainicial <= '"+dataTractar+"') and " +
153: "(movtip <> 'B' or datagr = '99991231') and perssexe = '2' and (distcod=? or ? is null) " +
154: "group by floor(("+(dataAvui ? "sysdate" : "to_date("+dataTractar+", 'YYYYMMDD')")+" - to_date(persndata, 'YYYYMMDD')) / 365.2425)) d on (e2.edat = d.edat) " +
155: 
156: "where e.edat = e2.edat order by 1", valors);
157:   


Stacktrace:
	org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:102)
	org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:212)
	org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:495)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:378)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:350)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:334)
	org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:595)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:382)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

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


Apache Tomcat/8.5.34