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 cas-user+unsubscr...@apereo.org. 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.
