Getting table or view does not exist

[Vikash Chandra Ansh]

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

[Pablo Vidaurri]

Schema changed, did you set you dll to drop and recreate the schema on first run?

## ddlauto options none|validate|update|create|create-drop
cas.ticket.registry.jpa.ddlAuto=create

-psv

[Vikash Chandra Ansh]

Thanks Pablo.

It worked. A new table cas_tickets has been added.

Thanks for your help