Instalei a versão VC4R0.9-JB7 a partir do zero (sem upgrade da base antiga) e estou tendo diversos erros
banco de dados postgres
Quando clico no menu Cadastro de Contratos não aparece nada:
15:42:56,102 WARN [br.com.centralit.citajax.servlet.CITServlet] (http--0.0.0.0-8080-7) java.lang.NullPointerException: org.apache.jasper.JasperException: java.lang.NullPointerException
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:413) [jbossweb-7.0.13.Final.jar:]
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:326) [jbossweb-7.0.13.Final.jar:]
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:253) [jbossweb-7.0.13.Final.jar:]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:840) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:622) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:560) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:488) [jbossweb-7.0.13.Final.jar:]
at br.com.centralit.citajax.servlet.CITServlet.processRequest(CITServlet.java:196) [classes:]
at br.com.centralit.citajax.servlet.CITServlet.doGet(CITServlet.java:476) [classes:]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
at br.com.centralit.citcorpore.util.FiltroSegurancaCITSmart.doFilter(FiltroSegurancaCITSmart.java:83) [classes:]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45]
Caused by: java.lang.NullPointerException
at org.apache.jsp.pages.dinamicViews.dinamicViews_jsp._jspService(dinamicViews_jsp.java:1638)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) [jbossweb-7.0.13.Final.jar:]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369) [jbossweb-7.0.13.Final.jar:]
... 29 more
Quando clico em Catalogo de Serviços alguns campos não aparecem:
Caused by: br.com.citframework.excecao.PersistenceException: SQL ERROR: SELECT SITUACAODEMANDA.IDSITUACAODEMANDA Fld_1, SITUACAODEMANDA.NOMESITUACAO Fld_2 FROM SITUACAODEMANDA WHERE 1 = 1 AND (UPPER(DELETED) IS NULL OR UPPER(DELETED) = 'N') ORDER BY 2
parameters:
*** ERROR: ERROR: column "deleted" does not exist
Position: 129
at br.com.citframework.integracao.JdbcEngine.execSQL(JdbcEngine.java:148) [classes:]
at br.com.citframework.integracao.JdbcEngine.execSQL(JdbcEngine.java:61) [classes:]
at br.com.citframework.integracao.DaoTransactDefaultImpl.execSQL(DaoTransactDefaultImpl.java:29) [classes:]
at br.com.centralit.citcorpore.metainfo.integracao.LookupDao.execSQL(LookupDao.java:43) [classes:]
at br.com.centralit.citcorpore.metainfo.negocio.TableSearchServiceEjb.findItens(TableSearchServiceEjb.java:215) [classes:]
at br.com.centralit.citcorpore.metainfo.ajaxForms.TableSearch.load(TableSearch.java:40) [classes:]
... 28 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "deleted" does not exist
Position: 129
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at br.com.citframework.integracao.JdbcEngine.execSQL(JdbcEngine.java:86) [classes:]
... 33 more
Autor: Luiz Érico M. de Almeida
1Um comentário