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.