Hi All, Recently I have upgraded my CAS from 6.3.7.4 to 6.5.0, but I am encountering table or view does not exist. I beleive it is something related to ticket cleaner. Please suggest if any new table has been added
Below is the logs:- 2022-04-05 09:00:08, 149 INFO (org.apereo.inspektr.audit.support.JdbcAuditTrailManager] - <Cleaning audit records with query DELETE FROM COM AUDIT TRAIL WHERE ADD_DATE < ?> 09:00:08,149 2 2022-04-05 09:00:08,151 INFO [org.apereo.inspektr.audit.support. JdboAuditTrailManager] - <0 records deleted.> 3 2022-04-05 09:00:08, 588 WARN (org.hibernate.engine.jdbc.spi.SqlExceptionHelper) - <50L Error: 942, 50LState: 42000> 09:00:08,588 4 2022-04-05 09:00:08, 588 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper) <ORA-00942: table or view does not exist 09:00:08,588 5 > C 2022-04-05 09:00:08, 509 ERROR [org.apereo.can.ticket.registry.DefaultTicketRegistryCleaner] - <could not extract. ResultSet> org.hibernate.exception. SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQL.ExceptionType Delegate.convert (SQLExceptionTypeDelegate.java:63)-[hibernate-core-5.6.5.Final.jar:5.6.5.Final] at org.hibernate.exception. internal. StandardSQLExceptionConverter.convert (StandardSOLExceptionConverter.java:37) -[hibernate-core-5.6.5.Final.jar:5.6.5.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert (SqlExceptionHelper.java:113) -(hibernate-core-5.6.5.Final.jar:5.6.5.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert (SqlExceptionllelper.java:99) -[hibernate-core-5.6.5.Final.jar:5.6.5.Final] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract (ResultSetReturnImpl.java:67) -[hibernate-core-5.6.5.Final.jar:5.6.5.Final] at org.hibernate.loader.Loader.getResultSet (Loader.java:2322) - [hibernate-core-5.6.5. Final.jar:5.6.5.Final] at org.hibernate.loader.Loader.executeQueryStatement (Loader.java:2075) -[hibernate-core-5.6.5.Final.jar:5.6.5.Final] at org.hibernate.loader.Loader.executeQueryStatement (Loader.java:2037) - [hibernate-core-5.6.5. Final.jar:5.6.5. Final] at org.hibernate.loader.Loader.scroll (Loader.java:2945) -[hibernate-core-5.6.5.Final.jar:5.6.5. Final] at org.hibernate.loader.hql.QueryLoader.scroll (QueryLoader.java:610) -[hibernate-core-5.6.5.Final.jar:5.6.5. Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.scroll (QueryTranslatorImpl.java:452) -[hibernate-core-5.6.5.Final.jar:5.6.5.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performScroll (HQLQueryPlan.java:353) - [hibernate-core-5.6.5.Final.jar:5.6.5.Final] at org.hibernate.internal.SessionImpl.scroll (SessionImpl.java:1596) -[hibernate-core-5.6.5.Final.jar:5.6.5.Final] at org.hibernate.query.internal.Abstract ProducedQuery.doScroll (AbstractProducedQuery.java:1588) -[hibernate-core-5.6.5.Final.jar:5.6.5.Final] at org.hibernate.query.internal.Abstract ProducedQuery.scroll (Abstract ProducedQuery.java:1574) -[hibernate-core-5.6.5.Final.jar:5.6.5.Final] at org.hibernate.query.internal.Abstract ProducedQuery.stream (Abstract ProducedQuery.java:1598) -[hibernate-core-5.6.5.Final.jar:5.6.5. Finall at org.apereo.cas.hibernate. CeallibernateJpaBeanFactory.streamQuery (CasHibernateJpaBeanFactory.java:103)-[cas-server-support-jpa-hibernate-6.5.0.jar:6.5.01 st org.apereo.cas.ticket.registry-JpaTicketRegistry.stream (JpaTicketRegistry.java:163) -[cas-server-support-jpe-ticket-registry-6.5.0.jar:6.5.01 at org.apereo.cas.ticket.registry.JpaTicketRegistryssFastClassBySpringCGLIBGC84ce3a7e.invoke (<generated>) -(cas-server-support-jpa-ticket-registry-6.5.0.jar:6.5.01 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) -(spring-core-5.3.15.jar:5.3.15) at org.springframework.aop.framework.CglibhopProxysCglibMethodInvocation.invoke Joinpoint (CalibAopProxy.java:783) -(spring-acp-5.3.15.jar:5.3.151 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:169) (apring-app-5.3.15.jar:5.3.151 at org.springframework.cop.framework.CalibhopProxy:CglihMethodInvocation proceed (CglibAopProxy.java:753) -[spring-aop-5.3.15.jar:5.3.151 at org.springframework.transaction.interceptor.Transaction Interceptore1.proceedWithInvocation (TransactionInterceptor.java:123) -[spring-tx-5.3.15.jar:5.3.15) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) -(spring-tx-5.3.15.jar:5.3.151 at org.springframework.transaction.interceptor Transaction Interceptor.invoke (TransactionInterceptor.java:119) (spring-tx-5.3.15.jar:5.3.15] at org.springframework.aop.framework.ReflectivelethodInvocation proceed (ReflectiveMethodInvocation.java:186) -(apning-aop-5.3.15.jar:5.1.151 at org.springframework.aop.framework. CalibAopProxy:CalibMethodInvocation proceed (CglibhopProxy.java:753) -[spring-aop-5.3.15.jar:5.3.15) at org.springframework.aop, framework. CglibAopProxy DynamicAdviseainterceptor, intercept (ColibAopProxy.java:658) (apring-aop-5.3.15.jar:5.3.15] org.apereo.cas.ticket.registry.JpaTicketRegistryd EnhancerBySpringCGLIB04eb1295b.stream (cgenerated) [cas-server-support-ipa-ticket-registry-6.5.0.jar:6.5.01 at org.apered.cap.ticket.registry. DefaultTicketRegistryCleaner, cleanInternal (DefaultTicketRegistrycleaner.java:66] -[cas-server-core-tickets-api-6-5.0 Thanks and regards Vikash Chandra -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- 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/CA%2BdrvxiWYNF1_hAJi2LwPdH0Hh6azGDs5nJschgKyYavrX2U0g%40mail.gmail.com.
