Prezados,
Ao logar no sistema após instalado, a seguinte mensagem aparece "Ocorreu um erro inesperado no sistema, entre em contato com suporte.ggas@procenge.com.br."
Coloquei em modo DEBUG o log4j e obtive a seguinte mensagem:
" ... 2013-09-19 16:01:17,288 [http-8080-2] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Completing transaction for [br.com.procenge.ggas.controleacesso.ControladorAcesso.consultarUsuarioDosPapeis]
2013-09-19 16:01:17,290 [http-8080-2] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'controladorTarifa'
2013-09-19 16:01:17,291 [http-8080-2] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'controladorParametroSistema'
2013-09-19 16:01:17,291 [http-8080-2] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@7ead510] for key [org.hibernate.impl.SessionFactoryImpl@29952be0] bound to thread [http-8080-2]
2013-09-19 16:01:17,291 [http-8080-2] DEBUG org.springframework.orm.hibernate3.HibernateTransactionManager - Found thread-bound Session [org.hibernate.impl.SessionImpl@53248513] for Hibernate transaction
2013-09-19 16:01:17,291 [http-8080-2] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Getting transaction for [br.com.procenge.ggas.parametrosistema.ControladorParametroSistema.obterValorDoParametroPorCodigo]
2013-09-19 16:01:17,291 [http-8080-2] INFO br.com.procenge.ggas.parametrosistema.impl.ControladorParametroSistemaImpl - ### <<< CACHE >>> ### obterValorDoParametroPorCodigo: CODIGO_STATUS_PENDENTE
2013-09-19 16:01:17,291 [http-8080-2] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Completing transaction for [br.com.procenge.ggas.parametrosistema.ControladorParametroSistema.obterValorDoParametroPorCodigo]
2013-09-19 16:01:17,291 [http-8080-2] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@7ead510] for key [org.hibernate.impl.SessionFactoryImpl@29952be0] bound to thread [http-8080-2]
2013-09-19 16:01:17,291 [http-8080-2] DEBUG org.springframework.orm.hibernate3.HibernateTransactionManager - Found thread-bound Session [org.hibernate.impl.SessionImpl@53248513] for Hibernate transaction
2013-09-19 16:01:17,291 [http-8080-2] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Getting transaction for [br.com.procenge.ggas.faturamento.tarifa.ControladorTarifa.consultarTarifas]
2013-09-19 16:01:17,291 [http-8080-2] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@7ead510] for key [org.hibernate.impl.SessionFactoryImpl@29952be0] bound to thread [http-8080-2]
2013-09-19 16:01:17,292 [http-8080-2] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-19 16:01:17,292 [http-8080-2] DEBUG org.hibernate.SQL - select this_.TARI_CD as TARI1_187_0_, this_.TARI_DS as TARI2_187_0_, this_.TARI_DS_ABREVIADA as TARI3_187_0_, this_.TARI_QN_CASA_DECIMAL as TARI4_187_0_, this_.TARI_NR_VERSAO as TARI5_187_0_, this_.TARI_TM_ULTIMA_ALTERACAO as TARI6_187_0_, this_.TARI_IN_USO as TARI7_187_0_, this_.SEGM_CD as SEGM8_187_0_, this_.USSI_CD as USSI9_187_0_, this_.ENCO_CD_ITEM_FATURA as ENCO10_187_0_, this_.ENCO_CD_STATUS as ENCO11_187_0_ from TARIFA this_ where this_.TARI_IN_USO=? and this_.ENCO_CD_STATUS=? order by this_.TARI_DS asc
2013-09-19 16:01:17,292 [http-8080-2] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
2013-09-19 16:01:17,292 [http-8080-2] DEBUG org.hibernate.type.BooleanType - binding 'true' to parameter: 1
2013-09-19 16:01:17,292 [http-8080-2] DEBUG org.hibernate.type.LongType - binding '242' to parameter: 2
2013-09-19 16:01:17,303 [http-8080-2] DEBUG com.mchange.v2.c3p0.impl.NewPooledConnection - com.mchange.v2.c3p0.impl.NewPooledConnection@6684917a handling a throwable.
java.sql.SQLException: ORA-00904: "THIS_"."ENCO_CD_STATUS": identificador inválido
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) ... "
O que pode estar acontecendo? Verifiquei na tabela TARIFA e a unica coluna que faz referencia a tabela ENTIDADE_CONTEUDO é a coluna ENCO_CD_ITEM_FATURA.
Minha infra é a seguinte:
1 VM com CentOS rodando Apache Tomcat 6.0.36;
1 Servidor RedHat rodando Oracle Database Enterprise Edition 11g 11.2.0.3.
Autor: diego weber