Retornar

java.lang.Exception: Invalid column name 'IDRESPSOLIC'. SELECT COUNT(*) FROM ( SELECT A001.IDSOLIC, A001.CDMODALIDADE,         DEMANDA       = CASE WHEN A001.CDMODALIDADE = 'P'                        THEN RTRIM(A006.NRPROCESSO) + '/' + RTRIM(A006.NREXERCICIO) + ' - ' + RTRIM(A006.NRVOLUME)                        ELSE RTRIM(A001.NRSOLIC)    + ' / ' + RTRIM(A001.NREXERCICIO) END,        DTASOLIC      = CONVERT(VARCHAR(10),A001.DTHRSOLIC,103),        HRSOLIC       = CONVERT(VARCHAR(8),A001.DTHRSOLIC,114),        PREVISAO      = DBO.STD01700 (A001.IDSOLIC),        STATUS        = DBO.SAD02800(  A001.CDSTSOLIC ),        REQUERENTE    = X001.NMPESSOA,        ENCERRAMENTO = A001.DTHRENCERRA,        IDREQUERENTE  = X001.IDPESSOA,        BENEFICIARIO  = X001B.NMPESSOA,        ORG_SOLIC     = B012.DCORGAO,        ASSUNTO       = RTRIM(B014.DCASSUNTO),        TIP_SOLIC     = CASE (A001.TPSOLIC)                           WHEN 1 THEN 'INFORMAÇÃO'                           WHEN 2 THEN 'SERVIÇO'                           WHEN 3 THEN 'RECLAMAÇÃO'                           WHEN 4 THEN 'SUGESTÃO'                           WHEN 5 THEN 'ELOGIO'                           WHEN 6 THEN 'DENUNCIA' + CASE WHEN (A001.FLSIGILO = 'S') THEN ' /SIGILOSA' ELSE ''                                                    END +                                                     CASE WHEN (A001.FLPRIOR = 'S') THEN ' /URGENTE' ELSE ''                                                    END                        END,        RECEBIMENTO    =  CASE (A001.DCMEIOREC)                             WHEN 1 THEN 'PRESENCIAL'                             WHEN 2 THEN 'CARTA'                             WHEN 3 THEN 'INTERNO'                             WHEN 4 THEN 'TELEFONE'                             WHEN 5 THEN 'INTERNET'                             WHEN 6 THEN 'E-MAIL'                          END,        MOTIVO        = RTRIM(A001.DCCOMPLASS),        LOC           = A001.NMLOCINSP,        CEP           = X002.CDCEP,        RUA           = X003.NMLOGRA,        NUM           = A001.NRLOGRALOCINSP,        COMPL         = A001.DCCOMPLLOCINSP,        BAIRRO        = X005.NMBAIRRO,        CID           = X006.NMCIDADE,        EST           = X007.SGUF,        SETOR         = A001.DCSETOR,        QUADRA        = A001.DCQUADRA,        LOTE          = A001.DCLOTE,        CANCELAMENTO  = A001.DCCANCEL,        EMPRESA       = A001.IDEMPNRSOLIC,        RESPOCANCEL   = RTRIM(X001D.NMPESSOA),        ORGAORESPASS  = RTRIM(B012D.CDORGAO)  + ' - ' +  RTRIM(B012D.DCORGAO) + ISNULL( ' - ' + RTRIM(B012D.DCSIGLA),''),        FONEORGRESP   = B012D.CDFONE,        ORGAOORIGEM   = RTRIM(B012A.CDORGAO)  + ' - ' +  RTRIM(B012A.DCORGAO) + ISNULL( ' - ' + RTRIM(B012A.DCSIGLA),''),        ORGAOANTERIOR = RTRIM(B012B.CDORGAO)  + ' - ' +  RTRIM(B012B.DCORGAO) + ISNULL( ' - ' + RTRIM(B012B.DCSIGLA),''),        ORGAOATUAL    = RTRIM(B012C.CDORGAO)  + ' - ' +  RTRIM(B012C.DCORGAO) + ISNULL( ' - ' + RTRIM(B012C.DCSIGLA),''),        EMAILORGATUAL = B012C.CDEMAIL,        FONEORGATUAL  = B012C.CDFONE,        RESPONSAVEL   = RTRIM(X001A.NMPESSOA),        DATAENVIO     = A006.DTHRREM,        DATARECEBE    = A006.DTHRRECEB,        REMESSA       = A006.NRREMESSA,        ANOREMESSA    = A006.CDANONRREM,        ICSEQTRAMITE  = ISNULL(A006.ICSEQTRAMITE, A001.NRSEQTRAMITE)   FROM SAT00100 A001 WITH (READUNCOMMITTED) INNER JOIN BXT00100 X001  WITH (READUNCOMMITTED) ON X001.IDPESSOA   =  A001.IDPESSOA INNER JOIN SBT01200 B012A WITH (READUNCOMMITTED) ON B012A.IDORGAO   =  A001.IDORGORIGEM INNER JOIN SBT01400 B014  WITH (READUNCOMMITTED) ON B014.IDASSUNTO  =  A001.IDASSUNTO INNER JOIN SBT01200 B012D WITH (READUNCOMMITTED) ON B012D.IDORGAO   =  B014.IDORGRESPASS INNER JOIN SBT01200 B012B WITH (READUNCOMMITTED) ON B012B.IDORGAO   =  A001.IDLOCALANT INNER JOIN SBT01200 B012C WITH (READUNCOMMITTED) ON B012C.IDORGAO   =  A001.IDLOCALATUAL  LEFT JOIN SAT00600 A006  WITH (READUNCOMMITTED) ON A006.IDSOLIC    =  A001.IDSOLIC  LEFT JOIN SBT01200 B012  WITH (READUNCOMMITTED) ON B012.IDORGAO    =  A001.IDORGSOLICITANTE  LEFT JOIN BXT00200 X002  WITH (READUNCOMMITTED) ON X002.IDCEP      =  A001.IDCEPLOCINSP  LEFT JOIN BXT00300 X003  WITH (READUNCOMMITTED) ON X003.IDLOGRA    =  X002.IDLOGRA  LEFT JOIN BXT00500 X005  WITH (READUNCOMMITTED) ON X005.IDBAIRRO   =  X002.IDBAIRRO  LEFT JOIN BXT00600 X006  WITH (READUNCOMMITTED) ON X006.IDCIDADE   =  X002.IDCIDADE  LEFT JOIN BXT00700 X007  WITH (READUNCOMMITTED) ON X007.IDUF       =  X006.IDUF  LEFT JOIN SBT00100 B001C WITH (READUNCOMMITTED) ON B001C.IDUSUARIO =  A001.IDRESPCANCEL  LEFT JOIN BXT00100 X001D WITH (READUNCOMMITTED) ON X001D.IDPESSOA  =  B001C.IDPESSOA  LEFT JOIN BXT00100 X001A WITH (READUNCOMMITTED) ON X001A.IDPESSOA  =  A001.IDRESPSOLIC   LEFT JOIN BXT00100 X001B WITH (READUNCOMMITTED) ON X001B.IDPESSOA  =  A001.IDBENEFICIARIO WHERE 'N' = CASE A001.CDMODALIDADE WHEN 'P'              THEN (SELECT VALORPARAMSIS                        FROM XXT00900 WITH (READUNCOMMITTED)                       WHERE NOMEPARAMSIS = 'UTILCADENDPREFPROC'                       AND TPPARAMSIS   = 'SMARSA')              ELSE (SELECT VALORPARAMSIS                        FROM XXT00900 WITH (READUNCOMMITTED)                     WHERE NOMEPARAMSIS = 'UTILCADENDPREFSOLIC'                       AND TPPARAMSIS   = 'SMARSA')             END UNION SELECT A001.IDSOLIC, A001.CDMODALIDADE,         DEMANDA       = CASE WHEN A001.CDMODALIDADE = 'P'                        THEN RTRIM(A006.NRPROCESSO) + '/' + RTRIM(A006.NREXERCICIO) + ' - ' + RTRIM(A006.NRVOLUME)                        ELSE RTRIM(A001.NRSOLIC) + ' / ' + RTRIM(A001.NREXERCICIO) END,        DTASOLIC      = CONVERT(VARCHAR(10),A001.DTHRSOLIC,103),        HRSOLIC       = CONVERT(VARCHAR(8),A001.DTHRSOLIC,114),        PREVISAO      = (DBO.STD01200(A001.IDEMPNRSOLIC, A001.DTHRSOLIC, (DATEADD(DAY, B014.QTTEMPOEX, A001.DTHRSOLIC)))),        STATUS        = CASE (A001.CDSTSOLIC)                           WHEN 1 THEN 'AGUARDANDO DISTRIBUIÇÃO'                           WHEN 2 THEN 'EM ANÁLISE'                           WHEN 3 THEN 'CONCLUÍDO'                           WHEN 4 THEN 'CANCELADO'                           WHEN 5 THEN 'AGUARDANDO PGTO TAXA'                           WHEN 6 THEN 'EM TRÂNSITO'                           WHEN 7 THEN 'EMPRESTADO'                           WHEN 8 THEN 'AGUARDANDO IMPRESSÃO GUIA'                           WHEN 9 THEN 'INCORPORADO'                           WHEN 10 THEN 'TRÂMITE AGENDADO'                           WHEN 11 THEN 'AGUARDANDO RESPOSTA'                        END,        REQUERENTE    = X001.NMPESSOA,        ENCERRAMENTO = A001.DTHRENCERRA,        IDREQUERENTE  = X001.IDPESSOA,        BENEFICIARIO  = X001B.NMPESSOA,        ORG_SOLIC     = B012.DCORGAO,        ASSUNTO       = RTRIM(B014.DCASSUNTO),        TIP_SOLIC     = CASE (A001.TPSOLIC)                           WHEN 1 THEN 'INFORMAÇÃO'                           WHEN 2 THEN 'SERVIÇO'                           WHEN 3 THEN 'RECLAMAÇÃO'                           WHEN 4 THEN 'SUGESTÃO'                           WHEN 5 THEN 'ELOGIO'                           WHEN 6 THEN 'DENUNCIA' + CASE WHEN (A001.FLSIGILO = 'S') THEN ' /SIGILOSA' ELSE ''                                                    END +                                                     CASE WHEN (A001.FLPRIOR = 'S') THEN ' /URGENTE' ELSE ''                                                    END                        END,        RECEBIMENTO    =  CASE (A001.DCMEIOREC)                             WHEN 1 THEN 'PRESENCIAL'                             WHEN 2 THEN 'CARTA'                             WHEN 3 THEN 'INTERNO'                             WHEN 4 THEN 'TELEFONE'                             WHEN 5 THEN 'INTERNET'                             WHEN 6 THEN 'E-MAIL'                          END,        MOTIVO        = RTRIM(A001.DCCOMPLASS),        LOC           = A001.NMLOCINSP,        CEP           = B035.CDCEP,        RUA           = B036.DCLOGRA,        NUM           = A001.NRLOGRALOCINSP,        COMPL         = A001.DCCOMPLLOCINSP,        BAIRRO        = B037.DCBAIRRO,        CID           = B038.DCCIDADE,        EST           = NULL,        SETOR         = A001.DCSETOR,        QUADRA        = A001.DCQUADRA,        LOTE          = A001.DCLOTE,        CANCELAMENTO  = A001.DCCANCEL,        EMPRESA       = A001.IDEMPNRSOLIC,        RESPOCANCEL   = RTRIM(X001D.NMPESSOA),        ORGAORESPASS  = RTRIM(B012D.CDORGAO)  + ' - ' +  B012D.DCORGAO + ISNULL( ' - ' + B012D.DCSIGLA,''),        FONEORGRESP   = B012D.CDFONE,        ORGAOORIGEM   = RTRIM(B012A.CDORGAO)  + ' - ' +  B012A.DCORGAO + ISNULL( ' - ' + B012A.DCSIGLA,''),        ORGAOANTERIOR = RTRIM(B012B.CDORGAO)  + ' - ' +  B012B.DCORGAO + ISNULL( ' - ' + B012B.DCSIGLA,''),        ORGAOATUAL    = RTRIM(B012C.CDORGAO)  + ' - ' +  B012C.DCORGAO + ISNULL( ' - ' + B012C.DCSIGLA,''),        EMAILORGATUAL = B012C.CDEMAIL,        FONEORGATUAL  = B012C.CDFONE,        RESPONSAVEL   = RTRIM(X001A.NMPESSOA),        DATAENVIO     = A006.DTHRREM,        DATARECEBE    = A006.DTHRRECEB,        REMESSA       = A006.NRREMESSA,        ANOREMESSA    = A006.CDANONRREM,        ICSEQTRAMITE  = ISNULL(A006.ICSEQTRAMITE, A001.NRSEQTRAMITE)   FROM SAT00100 A001 WITH (READUNCOMMITTED) INNER JOIN BXT00100 X001  WITH (READUNCOMMITTED) ON X001.IDPESSOA   =  A001.IDPESSOA INNER JOIN SBT01200 B012A WITH (READUNCOMMITTED) ON B012A.IDORGAO   =  A001.IDORGORIGEM INNER JOIN SBT01400 B014  WITH (READUNCOMMITTED) ON B014.IDASSUNTO  =  A001.IDASSUNTO INNER JOIN SBT01200 B012D WITH (READUNCOMMITTED) ON B012D.IDORGAO   =  B014.IDORGRESPASS INNER JOIN SBT01200 B012B WITH (READUNCOMMITTED) ON B012B.IDORGAO   =  A001.IDLOCALANT INNER JOIN SBT01200 B012C WITH (READUNCOMMITTED) ON B012C.IDORGAO   =  A001.IDLOCALATUAL  LEFT JOIN SAT00600 A006  WITH (READUNCOMMITTED) ON A006.IDSOLIC    =  A001.IDSOLIC  LEFT JOIN SBT01200 B012  WITH (READUNCOMMITTED) ON B012.IDORGAO    =  A001.IDORGSOLICITANTE  LEFT JOIN SBT03500 B035  WITH (READUNCOMMITTED) ON B035.IDCEP      =  A001.IDCEPATEND  LEFT JOIN SBT03600 B036  WITH (READUNCOMMITTED) ON B036.IDLOGRA    =  B035.IDLOGRA  LEFT JOIN SBT03700 B037  WITH (READUNCOMMITTED) ON B037.IDBAIRRO   =  B035.IDBAIRRO  LEFT JOIN SBT03800 B038  WITH (READUNCOMMITTED) ON B038.IDCIDADE   =  B035.IDCIDADE  LEFT JOIN SBT00100 B001C WITH (READUNCOMMITTED) ON B001C.IDUSUARIO =  A001.IDRESPCANCEL  LEFT JOIN BXT00100 X001D WITH (READUNCOMMITTED) ON X001D.IDPESSOA  =  B001C.IDPESSOA  LEFT JOIN BXT00100 X001A WITH (READUNCOMMITTED) ON X001A.IDPESSOA  =  A001.IDRESPSOLIC   LEFT JOIN BXT00100 X001B WITH (READUNCOMMITTED) ON X001B.IDPESSOA  =  A001.IDBENEFICIARIO WHERE 'S' = CASE A001.CDMODALIDADE WHEN 'P'              THEN (SELECT VALORPARAMSIS                        FROM XXT00900 WITH (READUNCOMMITTED)                       WHERE NOMEPARAMSIS = 'UTILCADENDPREFPROC'                       AND TPPARAMSIS   = 'SMARSA')              ELSE (SELECT VALORPARAMSIS                        FROM XXT00900 WITH (READUNCOMMITTED)                     WHERE NOMEPARAMSIS = 'UTILCADENDPREFSOLIC'                       AND TPPARAMSIS   = 'SMARSA')             END              ) RS WHERE IDSOLIC = -1 com.sil.util.Query.countRecords(Query.java:608) com.sil.util.Query.open(Query.java:130) com.sil.util.Query.open(Query.java:93) org.apache.jsp.work.ddw.PesquisaProcessoCidadao_jsp.execFirstTime(PesquisaProcessoCidadao_jsp.java:610) org.apache.jsp.work.ddw.PesquisaProcessoCidadao_jsp._jspService(PesquisaProcessoCidadao_jsp.java:1594) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) com.sil.servlets.ControleServ.forward(ControleServ.java:3040) com.sil.servlets.ControleServ.execObj(ControleServ.java:2902) com.sil.servlets.ControleServ.finalizar(ControleServ.java:1295) com.sil.servlets.ControleServ.processRequest(ControleServ.java:257) com.sil.servlets.ControleServ.beforeProcessRequest(ControleServ.java:3247) com.sil.servlets.ControleServ.doGet(ControleServ.java:3260) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) org.apache.jsp.loginWeb_jsp._jspService(loginWeb_jsp.java:73) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.java:30) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) java.lang.Thread.run(Thread.java:662)