Software Público

Portal do SPB

Membros

mizaelr

Ver todos(as)

Citsmart ITSM Community

Ajuda

Participe

Repositório

Wiki

Citsmart ITSM Community > Histórico de Fóruns > Fórum Citsmart > Pequisa Avançada extremamente lenta

Histórico de Fóruns

Voltar a Fórum Citsmart

Pessoal,

A pesquisa avançada está extremamente lenta, mesmo quando a pesquisa é feita com a utilização do campo número do chamado.

Alguém já passou por isso?

Versão do Citsmart : VC5R3.7

Driver do Banco: PostgreSQL 9.4 JDBC4.1 (build 1201)

Log JBOSS

13:55:00,002 WARN [org.hibernate.util.JDBCExceptionReporter] (DefaultQuartzScheduler_Worker-6) SQL Error: 17008, SQLState: 08003

13:55:00,003 ERROR [org.hibernate.util.JDBCExceptionReporter] (DefaultQuartzScheduler_Worker-6) Conexão Fechada

13:55:00,004 ERROR [org.hibernate.transaction.JDBCTransaction] (DefaultQuartzScheduler_Worker-6) JDBC rollback failed: java.sql.SQLRecoverableException: Conexão Fechada

at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3921)

at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:1117)

at org.jboss.jca.adapters.jdbc.WrappedConnection.rollback(WrappedConnection.java:779)

at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:213) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:192) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:674) [spring-orm-2.5.6.SEC03.jar:2.5.6.SEC03]

at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:823) [spring-tx-2.5.6.SEC03.jar:2.5.6.SEC03]

at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:800) [spring-tx-2.5.6.SEC03.jar:2.5.6.SEC03]

at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:339) [spring-tx-2.5.6.SEC03.jar:2.5.6.SEC03]

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [spring-tx-2.5.6.SEC03.jar:2.5.6.SEC03]

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) [spring-aop-2.5.6.SEC03.jar:2.5.6.SEC03]

at gov.projudi.service.util.datasource.DataSourceTypeAdvice.invoke(DataSourceTypeAdvice.java:48) [classes:]

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) [spring-aop-2.5.6.SEC03.jar:2.5.6.SEC03]

at gov.projudi.service.util.QueryMonitorAdvice.invoke(QueryMonitorAdvice.java:22) [classes:]

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) [spring-aop-2.5.6.SEC03.jar:2.5.6.SEC03]

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) [spring-aop-2.5.6.SEC03.jar:2.5.6.SEC03]

at com.sun.proxy.$Proxy407.saveNumeroSessoesAtivas(Unknown Source)

at sun.reflect.GeneratedMethodAccessor445.invoke(Unknown Source) [:1.7.0_75]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]

at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276) [spring-core-2.5.6.SEC03.jar:2.5.6.SEC03]

at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:272) [spring-support-2.0.8.jar:2.0.8]

at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86) [spring-support-2.0.8.jar:2.0.8]

at org.quartz.core.JobRunShell.run(JobRunShell.java:199) [quartz-1.7.3.jar:]

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546) [quartz-1.7.3.jar:]

13:55:00,011 ERROR [org.springframework.transaction.interceptor.TransactionInterceptor] (DefaultQuartzScheduler_Worker-6) Application exception overridden by rollback exception: org.hibernate.exception.JDBCConnectionException: could not get next sequence value

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:99) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:132) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:105) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:121) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.impl.SessionImpl.save(SessionImpl.java:701) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at org.hibernate.impl.SessionImpl.save(SessionImpl.java:697) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]

at br.mp.mppr.persistence.hibernate.AbstractHibernateDAO.save(AbstractHibernateDAO.java:204) [classes:]

at gov.tjpr.service.impl.AbstractServiceImpl.save(AbstractServiceImpl.java:92) [tjpr-framework-1.4.6.jar:]

at gov.projudi.service.util.impl.MonitorSessaoServiceImpl.saveNumeroSessoesAtivas(MonitorSessaoServiceImpl.java:131) [classes:]

at sun.reflect.GeneratedMethodAccessor446.invoke(Unknown Source) [:1.7.0_75]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) [spring-aop-2.5.6.SEC03.jar:2.5.6.SEC03]

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) [spring-aop-2.5.6.SEC03.jar:2.5.6.SEC03]

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) [spring-aop-2.5.6.SEC03.jar:2.5.6.SEC03]

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) [spring-tx-2.5.6.SEC03.jar:2.5.6.SEC03]