Invalid column name 'TpAlvara'. SELECT al.NroAlvara,al.Exercicio,al.DtEmissao,al.DtValidade,al.TpAlvara,al.Chave, IdCcmCadastroPrevio,cc.CnpjCpf,Inscricao,cc.Nome, SUBSTRING(RTRIM(cc.Cep)+' - '+LTRIM(ISNULL(RTRIM(cc.TpLogradouro)+' ',''))+ LTRIM(ISNULL(RTRIM(cc.Titulo)+' ',''))+RTRIM(ISNULL(cc.Logradouro,'')),1,100) AS Endereco, cc.Bairro,cc.Cidade,cc.Estado,cc.Numero,cc.Complemento DtInicioAtividade,AtividadeLivre, cn.CodCnae,cn.DescrCnae FROM alvaras al INNER JOIN ccmcadastroprevio cc ON cc.idccmcadastroprevio = al.idorigem INNER JOIN alvaralicencaprevia ap ON ap.IdAlvaraLicencaPrevia = cc.IdAlvaraLicencaPrevia INNER JOIN cnae cn ON cn.IdCnae = ap.IdCnae WHERE IdAlvara = null |
com.sil.util.Query.open(Query.java:235) |
com.sil.util.Query.open(Query.java:174) |
org.apache.jsp.work.tbw.AlvaraConsultar_jsp._jspService(AlvaraConsultar_jsp.java:511) |
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71) |
javax.servlet.http.HttpServlet.service(HttpServlet.java:733) |
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477) |
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385) |
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329) |
javax.servlet.http.HttpServlet.service(HttpServlet.java:733) |
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712) |
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) |
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384) |
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) |
com.sil.servlets.ControleServ.forward(ControleServ.java:4746) |
com.sil.servlets.ControleServ.execObj(ControleServ.java:4555) |
com.sil.servlets.ControleServ.finalizar(ControleServ.java:2378) |
com.sil.servlets.ControleServ.processRequest(ControleServ.java:572) |
com.sil.servlets.ControleServ.beforeProcessRequest(ControleServ.java:5161) |
com.sil.servlets.ControleServ.doGet(ControleServ.java:5197) |
javax.servlet.http.HttpServlet.service(HttpServlet.java:626) |
javax.servlet.http.HttpServlet.service(HttpServlet.java:733) |
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712) |
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) |
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384) |
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) |
org.apache.jsp.loginWeb_jsp._jspService(loginWeb_jsp.java:187) |
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71) |
javax.servlet.http.HttpServlet.service(HttpServlet.java:733) |
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477) |
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385) |
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329) |
javax.servlet.http.HttpServlet.service(HttpServlet.java:733) |
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
com.sil.filter.InitControl.doFilter(InitControl.java:35) |
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
com.sil.filter.InitControl.doFilter(InitControl.java:35) |
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) |
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) |
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
psiprobe.Tomcat90AgentValve.invoke(Tomcat90AgentValve.java:35) |
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) |
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) |
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) |
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) |
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) |
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) |
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
java.lang.Thread.run(Thread.java:748) |