Helo, this is a topic of interest for us since we plan on upgrading from Oracle 11 to something else.
If you have not solved yet the issue can you please activate the SQL tracing and try again? It is something like 'database.hibernate.show.sql=true' in 'cas.properties'. If you solved the issue please reply how you did, me at least. Regards y le dejo mis dies. Uxío Prego Madiva Soluciones Cl / Serrano Galvache 56 E Abedul 4 28033 Madrid 917 56 84 94 www.madiva.com The activity of email inboxes can be systematically tracked by colleagues, business partners and third parties. Turn off automatic loading of images to hamper it. 2016-11-02 16:11 GMT+01:00 CR0SS <[email protected]>: > Hello, > > > > We have CAS 3.4.3 installed distributed in 4 different machines using the > same data base. The data base has been upgraded from Oracle11 to Oracle 12c > and since then, we are getting errors related to the deletion of the > session TICKET. The driver version we’re using is 10.1.0.2.0. > > > > Exception trace: > > > > 2016-10-31 13:36:15,039 INFO [STDOUT] 2016-10-31 13:36:15,039 ERROR > [org.hibernate.util.JDBCExceptionReporter] - <ORA-01031: privilegios > insuficientes > > > > > 2016-10-31 13:36:15,085 INFO [STDOUT] 2016-10-31 13:36:15,039 ERROR > [org.hibernate.event.def.AbstractFlushingEventListener] - <Could not > synchronize database state with session> > > org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch > update > > at org.hibernate.exception.SQLStateConverter.convert( > SQLStateConverter.java:92) > > at org.hibernate.exception.JDBCExceptionHelper.convert( > JDBCExceptionHelper.java:66) > > at org.hibernate.jdbc.AbstractBatcher.executeBatch( > AbstractBatcher.java:275) > > at org.hibernate.engine.ActionQueue.executeActions( > ActionQueue.java:263) > > at org.hibernate.engine.ActionQueue.executeActions( > ActionQueue.java:184) > > at org.hibernate.event.def.AbstractFlushingEventListener. > performExecutions(AbstractFlushingEventListener.java:321) > > at org.hibernate.event.def.DefaultFlushEventListener.onFlush( > DefaultFlushEventListener.java:51) > > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206) > > at org.hibernate.impl.SessionImpl.managedFlush( > SessionImpl.java:375) > > at org.hibernate.transaction.JDBCTransaction.commit( > JDBCTransaction.java:137) > > at org.hibernate.ejb.TransactionImpl.commit( > TransactionImpl.java:76) > > at org.springframework.orm.jpa.JpaTransactionManager.doCommit( > JpaTransactionManager.java:467) > > at org.springframework.transaction.support. > AbstractPlatformTransactionManager.processCommit( > AbstractPlatformTransactionManager.java:754) > > at org.springframework.transaction.support. > AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionMan > ager.java:723) > > at org.springframework.transaction.interceptor. > TransactionAspectSupport.commitTransactionAfterReturnin > g(TransactionAspectSupport.java:393) > > at org.springframework.transaction.interceptor. > TransactionInterceptor.invoke(TransactionInterceptor.java:120) > > at org.springframework.aop.framework.ReflectiveMethodInvocation. > proceed(ReflectiveMethodInvocation.java:172) > > at org.springframework.aop.framework.JdkDynamicAopProxy. > invoke(JdkDynamicAopProxy.java:202) > > at $Proxy78.deleteTicket(Unknown Source) > > at org.jasig.cas.CentralAuthenticationServiceIm > pl.validateServiceTicket(CentralAuthenticationServiceImpl.java:454) > > at sun.reflect.GeneratedMethodAccessor461.invoke(Unknown Source) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:585) > > at org.springframework.aop.support.AopUtils. > invokeJoinpointUsingReflection(AopUtils.java:309) > > at org.springframework.aop.framework.ReflectiveMethodInvocation. > invokeJoinpoint(ReflectiveMethodInvocation.java:183) > > at org.springframework.aop.framework.ReflectiveMethodInvocation. > proceed(ReflectiveMethodInvocation.java:150) > > at org.springframework.aop.aspectj.MethodInvocationProceedingJoin > Point.proceed(MethodInvocationProceedingJoinPoint.java:80) > > at org.perf4j.aop.AbstractTimingAspect.doPerfLogging( > AbstractTimingAspect.java:71) > > at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:585) > > at org.springframework.aop.aspectj.AbstractAspectJAdvice. > invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) > > at org.springframework.aop.aspectj.AbstractAspectJAdvice. > invokeAdviceMethod(AbstractAspectJAdvice.java:610) > > at org.springframework.aop.aspectj.AspectJAroundAdvice. > invoke(AspectJAroundAdvice.java:65) > > at org.springframework.aop.framework.ReflectiveMethodInvocation. > proceed(ReflectiveMethodInvocation.java:161) > > at org.springframework.aop.interceptor.ExposeInvocationInterceptor. > invoke(ExposeInvocationInterceptor.java:89) > > at org.springframework.aop.framework.ReflectiveMethodInvocation. > proceed(ReflectiveMethodInvocation.java:172) > > at org.springframework.aop.framework.JdkDynamicAopProxy. > invoke(JdkDynamicAopProxy.java:202) > > at $Proxy80.validateServiceTicket(Unknown Source) > > at org.jasig.cas.web.ServiceValidateController. > handleRequestInternal(ServiceValidateController.java:148) > > at org.springframework.web.servlet.mvc.AbstractController. > handleRequest(AbstractController.java:153) > > at org.springframework.web.servlet.mvc. > SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter > .java:48) > > at org.springframework.web.servlet.DispatcherServlet. > doDispatch(DispatcherServlet.java:788) > > at org.springframework.web.servlet.DispatcherServlet. > doService(DispatcherServlet.java:717) > > at org.springframework.web.servlet.FrameworkServlet.processRequest( > FrameworkServlet.java:644) > > at org.springframework.web.servlet.FrameworkServlet. > doPost(FrameworkServlet.java:560) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) > > at org.jasig.cas.web.init.SafeDispatcherServlet.service_ > aroundBody2(SafeDispatcherServlet.java:115) > > at org.jasig.cas.web.init.SafeDispatcherServlet.service_ > aroundBody3$advice(SafeDispatcherServlet.java:44) > > at org.jasig.cas.web.init.SafeDispatcherServlet.service( > SafeDispatcherServlet.java:1) > > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:252) > > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:173) > > at com.github.inspektr.common.web.ClientInfoThreadLocalFilter. > doFilter(ClientInfoThreadLocalFilter.java:46) > > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:202) > > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:173) > > at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter( > ReplyHeaderFilter.java:81) > > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:202) > > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:173) > > at org.apache.catalina.core.StandardWrapperValve.invoke( > StandardWrapperValve.java:213) > > at org.apache.catalina.core.StandardContextValve.invoke( > StandardContextValve.java:178) > > at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke( > CustomPrincipalValve.java:39) > > at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke( > SecurityAssociationValve.java:159) > > at org.jboss.web.tomcat.security.JaccContextValve.invoke( > JaccContextValve.java:59) > > at org.apache.catalina.core.StandardHostValve.invoke( > StandardHostValve.java:126) > > at org.apache.catalina.valves.ErrorReportValve.invoke( > ErrorReportValve.java:105) > > at org.apache.catalina.valves.AccessLogValve.invoke( > AccessLogValve.java:526) > > at org.apache.catalina.core.StandardEngineValve.invoke( > StandardEngineValve.java:107) > > at org.apache.catalina.connector.CoyoteAdapter.service( > CoyoteAdapter.java:148) > > at org.apache.coyote.http11.Http11Processor.process( > Http11Processor.java:856) > > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler. > processConnection(Http11Protocol.java:744) > > at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket( > PoolTcpEndpoint.java:527) > > at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run( > MasterSlaveWorkerThread.java:112) > > at java.lang.Thread.run(Thread.java:595) > > Caused by: java.sql.BatchUpdateException: ORA-01031: privilegios > insuficientes > > > > at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException( > DatabaseError.java:367) > > at oracle.jdbc.driver.OraclePreparedStatement.executeBatch( > OraclePreparedStatement.java:8739) > > at org.jboss.resource.adapter.jdbc.WrappedStatement. > executeBatch(WrappedStatement.java:487) > > at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch( > BatchingBatcher.java:70) > > at org.hibernate.jdbc.AbstractBatcher.executeBatch( > AbstractBatcher.java:268) > > ... 71 more > > > > Have you experienced this type of errors before related to ticket > deletion? > > Do you know what may be causing this issue? > > > > King regards, > > -- > - CAS gitter chatroom: https://gitter.im/apereo/cas > - CAS mailing list guidelines: https://apereo.github.io/cas/ > Mailing-Lists.html > - CAS documentation website: https://apereo.github.io/cas > - CAS project website: https://github.com/apereo/cas > --- > You received this message because you are subscribed to the Google Groups > "CAS Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit https://groups.google.com/a/ > apereo.org/d/msgid/cas-user/4ddc9ad6-2c94-4c1e-935c- > 6a3075fed10e%40apereo.org > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/4ddc9ad6-2c94-4c1e-935c-6a3075fed10e%40apereo.org?utm_medium=email&utm_source=footer> > . > -- - CAS gitter chatroom: https://gitter.im/apereo/cas - CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html - CAS documentation website: https://apereo.github.io/cas - CAS project website: https://github.com/apereo/cas --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CANidDKa-YNeGbk5yR20R_XOLarDdaLmxd%3DjvKNMg%3D0NfXk5t1w%40mail.gmail.com.
