Fail to config JPA service registry

[Ps Chu]

Hi all,

I have successfully config the service registry using JSON. However, I failed to config the JPA service registry when connecting to MSSQL. As I am new to CAS as well as the Spring, anyone could give some advices is much appreciated. 

Background:

CAS version: 6.6.2

OS: Windows 10

JDK: 11

Executed with embedded Tomcat by [gradle run]

Configuration [cas.properties]

cas.service-registry.jpa.user=XXX

cas.service-registry.jpa.password=XXXX
cas.service-registry.jpa.driver-class=com.microsoft.sqlserver.jdbc.SQLServerDriver
cas.service-registry.jpa.url=jdbc:sqlserver://XXX.XXX.XXX.XXX:XXXX;encrypt=false;databaseName=xxx_db;
cas.service-registry.jpa.dialect=org.hibernate.dialect.SQLServer2016Dialect
cas.service-registry.jpa.ddlAuto=create-drop
cas.service-registry.jpa.autocommit=true
cas.service-registry.jpa.idle-timeout=5000

Dependencies

implementation "org.apereo.cas:cas-server-support-jpa-service-registry:${project.'cas.version'}"

Below is the error I got when [gradle run] the project.

2022-11-22 16:35:43,579 ERROR [org.springframework.boot.web.embedded.tomcat.TomcatStarter] - <Error starting Tomcat context. Exception: org.springframework.beans.factory.UnsatisfiedDependencyException. Message: Error
creating bean with name 'casCorsFilter' defined in class path resource [org/apereo/cas/config/CasFiltersConfiguration$CasFiltersCorsConfiguration.class]: Unsatisfied dependency expressed through method 'casCorsFilter'
 parameter 1; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'corsHttpWebRequestConfigurationSource' defined in class path resource [org/apereo/cas/
config/CasFiltersConfiguration$CasFiltersCorsConfiguration.class]: Unsatisfied dependency expressed through method 'corsHttpWebRequestConfigurationSource' parameter 3; nested exception is org.springframework.beans.fac
tory.UnsatisfiedDependencyException: Error creating bean with name 'servicesManager' defined in class path resource [org/apereo/cas/config/CasCoreServicesConfiguration$CasCoreServicesManagerConfiguration.class]: Unsat
isfied dependency expressed through method 'servicesManager' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'defaultServicesManagerExec
utionPlanConfigurer' defined in class path resource [org/apereo/cas/config/CasCoreServicesConfiguration$CasCoreServicesManagerExecutionPlanConfiguration.class]: Unsatisfied dependency expressed through method 'default
ServicesManagerExecutionPlanConfigurer' parameter 1; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'servicesManagerConfigurationContext' defined in
 class path resource [org/apereo/cas/config/CasCoreServicesConfiguration$CasCoreServicesManagerExecutionPlanConfiguration.class]: Unsatisfied dependency expressed through method 'servicesManagerConfigurationContext' p
arameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'serviceRegistry' defined in class path resource [org/apereo/cas/config/CasCoreServicesCo
nfiguration$CasCoreServiceRegistryConfiguration.class]: Unsatisfied dependency expressed through method 'serviceRegistry' parameter 2; nested exception is org.springframework.beans.factory.BeanCreationException: Error
 creating bean with name 'serviceRegistryExecutionPlan' defined in class path resource [org/apereo/cas/config/CasCoreServicesConfiguration$CasCoreServiceRegistryPlanConfiguration.class]: Bean instantiation via factory
 method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apereo.cas.services.ServiceRegistryExecutionPlan]: Factory method 'serviceRegistryExecutionPlan' thr
ew exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'jpaServiceRegistryExecutionPlanConfigurer' defined in class path resource [org/apereo/
cas/config/JpaServiceRegistryConfiguration$JpaServiceRegistryPlanConfiguration.class]: Unsatisfied dependency expressed through method 'jpaServiceRegistryExecutionPlanConfigurer' parameter 1; nested exception is org.s
pringframework.beans.factory.BeanCreationException: Error creating bean with name 'jpaServiceRegistry': Injection of persistence dependencies failed; nested exception is java.lang.ClassCastException: class org.springf
ramework.beans.factory.support.NullBean cannot be cast to class javax.persistence.EntityManagerFactory (org.springframework.beans.factory.support.NullBean and javax.persistence.EntityManagerFactory are in unnamed modu
le of loader org.springframework.boot.loader.LaunchedURLClassLoader @2b98378d)>
2022-11-22 16:35:43,600 WARN [org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext] - <Exception encountered during context initialization - cancelling refresh attempt: org.s
pringframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat>
Hibernate:

    drop table if exists Registered_Services
2022-11-22 16:35:43,610 Log4j2-TF-1-AsyncLogger[AsyncContext@2b98378d]-1 ERROR An exception occurred processing Appender casConsole java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.Annotat
ionConfigServletWebServerApplicationContext@11a7ba62 has not been refreshed yet
        at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1141)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1159)
        at org.apereo.cas.util.spring.ApplicationContextProvider.getMessagSanitizer(ApplicationContextProvider.java:208)
        at org.apereo.cas.logging.LoggingUtils.prepareLogEvent(LoggingUtils.java:28)
        at org.apereo.cas.logging.CasAppender.append(CasAppender.java:80)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:161)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:134)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:125)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:89)
        at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:675)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:633)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:604)
        at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:98)
        at org.apache.logging.log4j.core.async.AsyncLogger.actualAsyncLog(AsyncLogger.java:488)
        at org.apache.logging.log4j.core.async.RingBufferLogEvent.execute(RingBufferLogEvent.java:156)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:51)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:29)
        at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168)
        at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125)
        at java.base/java.lang.Thread.run(Thread.java:834)

AsyncLogger error handling event seq=10, value='org.apache.logging.log4j.core.async.RingBufferLogEvent@234e6e2d': org.apache.logging.log4j.core.appender.AppenderLoggingException: An exception occurred processing Appen
der casConsole
org.apache.logging.log4j.core.appender.AppenderLoggingException: An exception occurred processing Appender casConsole
        at org.apache.logging.log4j.core.appender.DefaultErrorHandler.error(DefaultErrorHandler.java:96)
        at org.apache.logging.log4j.core.config.AppenderControl.handleAppenderError(AppenderControl.java:170)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:163)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:134)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:125)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:89)
        at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:675)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:633)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:604)
        at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:98)
        at org.apache.logging.log4j.core.async.AsyncLogger.actualAsyncLog(AsyncLogger.java:488)
        at org.apache.logging.log4j.core.async.RingBufferLogEvent.execute(RingBufferLogEvent.java:156)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:51)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:29)
        at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168)
        at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125)
        at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@11a7ba62 has not been refreshed yet
        at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1141)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1159)
        at org.apereo.cas.util.spring.ApplicationContextProvider.getMessagSanitizer(ApplicationContextProvider.java:208)
        at org.apereo.cas.logging.LoggingUtils.prepareLogEvent(LoggingUtils.java:28)
        at org.apereo.cas.logging.CasAppender.append(CasAppender.java:80)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:161)
        ... 15 more
2022-11-22 16:35:43,614 Log4j2-TF-1-AsyncLogger[AsyncContext@2b98378d]-1 ERROR An exception occurred processing Appender casFile java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.Annotation
ConfigServletWebServerApplicationContext@11a7ba62 has not been refreshed yet
        at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1141)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1159)
        at org.apereo.cas.util.spring.ApplicationContextProvider.getMessagSanitizer(ApplicationContextProvider.java:208)
        at org.apereo.cas.logging.LoggingUtils.prepareLogEvent(LoggingUtils.java:28)
        at org.apereo.cas.logging.CasAppender.append(CasAppender.java:80)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:161)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:134)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:125)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:89)
        at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:675)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:633)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:604)
        at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:98)
        at org.apache.logging.log4j.core.async.AsyncLogger.actualAsyncLog(AsyncLogger.java:488)
        at org.apache.logging.log4j.core.async.RingBufferLogEvent.execute(RingBufferLogEvent.java:156)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:51)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:29)
        at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168)
AsyncLogger error handling event seq=   at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125)
        at java.base/java.lang.Thread.run(Thread.java:834)

11, value='org.apache.logging.log4j.core.async.RingBufferLogEvent@46f8628': org.apache.logging.log4j.core.appender.AppenderLoggingException: An exception occurred processing Appender casFile
org.apache.logging.log4j.core.appender.AppenderLoggingException: An exception occurred processing Appender casFile
        at org.apache.logging.log4j.core.appender.DefaultErrorHandler.error(DefaultErrorHandler.java:96)
        at org.apache.logging.log4j.core.config.AppenderControl.handleAppenderError(AppenderControl.java:170)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:163)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:134)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:125)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:89)
        at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:675)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:633)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:604)
        at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:98)
        at org.apache.logging.log4j.core.async.AsyncLogger.actualAsyncLog(AsyncLogger.java:488)
        at org.apache.logging.log4j.core.async.RingBufferLogEvent.execute(RingBufferLogEvent.java:156)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:51)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:29)
        at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168)
        at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125)
        at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@11a7ba62 has not been refreshed yet
        at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1141)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1159)
        at org.apereo.cas.util.spring.ApplicationContextProvider.getMessagSanitizer(ApplicationContextProvider.java:208)
        at org.apereo.cas.logging.LoggingUtils.prepareLogEvent(LoggingUtils.java:28)
        at org.apereo.cas.logging.CasAppender.append(CasAppender.java:80)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:161)
        ... 15 more
2022-11-22 16:35:43,615 Log4j2-TF-1-AsyncLogger[AsyncContext@2b98378d]-1 ERROR An exception occurred processing Appender casFile java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.Annotation
ConfigServletWebServerApplicationContext@11a7ba62 has not been refreshed yet
        at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1141)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1159)
        at org.apereo.cas.util.spring.ApplicationContextProvider.getMessagSanitizer(ApplicationContextProvider.java:208)
        at org.apereo.cas.logging.LoggingUtils.prepareLogEvent(LoggingUtils.java:28)
        at org.apereo.cas.logging.CasAppender.append(CasAppender.java:80)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:161)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:134)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:125)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:89)
        at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:675)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:633)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.logParent(LoggerConfig.java:666)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:635)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:604)
        at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:98)
        at org.apache.logging.log4j.core.async.AsyncLogger.actualAsyncLog(AsyncLogger.java:488)
        at org.apache.logging.log4j.core.async.RingBufferLogEvent.execute(RingBufferLogEvent.java:156)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:51)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:29)
        at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168)
        at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125)
        at java.base/java.lang.Thread.run(Thread.java:834)

AsyncLogger error handling event seq=12, value='org.apache.logging.log4j.core.async.RingBufferLogEvent@50247fdd': org.apache.logging.log4j.core.appender.AppenderLoggingException: An exception occurred processing Appen
der casFile
org.apache.logging.log4j.core.appender.AppenderLoggingException: An exception occurred processing Appender casFile
        at org.apache.logging.log4j.core.appender.DefaultErrorHandler.error(DefaultErrorHandler.java:96)
        at org.apache.logging.log4j.core.config.AppenderControl.handleAppenderError(AppenderControl.java:170)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:163)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:134)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:125)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:89)
        at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:675)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:633)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.logParent(LoggerConfig.java:666)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:635)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:604)
        at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:98)
        at org.apache.logging.log4j.core.async.AsyncLogger.actualAsyncLog(AsyncLogger.java:488)
        at org.apache.logging.log4j.core.async.RingBufferLogEvent.execute(RingBufferLogEvent.java:156)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:51)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:29)
        at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168)
        at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125)
        at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@11a7ba62 has not been refreshed yet
        at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1141)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1159)
        at org.apereo.cas.util.spring.ApplicationContextProvider.getMessagSanitizer(ApplicationContextProvider.java:208)
        at org.apereo.cas.logging.LoggingUtils.prepareLogEvent(LoggingUtils.java:28)
        at org.apereo.cas.logging.CasAppender.append(CasAppender.java:80)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:161)
        ... 18 more
2022-11-22 16:35:43,616 Log4j2-TF-1-AsyncLogger[AsyncContext@2b98378d]-1 ERROR An exception occurred processing Appender casFile java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.Annotation
ConfigServletWebServerApplicationContext@11a7ba62 has not been refreshed yet
        at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1141)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1159)
        at org.apereo.cas.util.spring.ApplicationContextProvider.getMessagSanitizer(ApplicationContextProvider.java:208)
        at org.apereo.cas.logging.LoggingUtils.prepareLogEvent(LoggingUtils.java:28)
        at org.apereo.cas.logging.CasAppender.append(CasAppender.java:80)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:161)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:134)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:125)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:89)
        at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:675)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:633)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.logParent(LoggerConfig.java:666)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:635)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:604)
        at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:98)
        at org.apache.logging.log4j.core.async.AsyncLogger.actualAsyncLog(AsyncLogger.java:488)
        at org.apache.logging.log4j.core.async.RingBufferLogEvent.execute(RingBufferLogEvent.java:156)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:51)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:29)
        at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168)
        at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125)
        at java.base/java.lang.Thread.run(Thread.java:834)

AsyncLogger error handling event seq=13, value='org.apache.logging.log4j.core.async.RingBufferLogEvent@2646fc87': org.apache.logging.log4j.core.appender.AppenderLoggingException: An exception occurred processing Appen
der casFile
org.apache.logging.log4j.core.appender.AppenderLoggingException: An exception occurred processing Appender casFile
        at org.apache.logging.log4j.core.appender.DefaultErrorHandler.error(DefaultErrorHandler.java:96)
        at org.apache.logging.log4j.core.config.AppenderControl.handleAppenderError(AppenderControl.java:170)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:163)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:134)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:125)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:89)
        at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:675)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:633)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.logParent(LoggerConfig.java:666)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:635)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:604)
        at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:98)
        at org.apache.logging.log4j.core.async.AsyncLogger.actualAsyncLog(AsyncLogger.java:488)
        at org.apache.logging.log4j.core.async.RingBufferLogEvent.execute(RingBufferLogEvent.java:156)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:51)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:29)
        at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168)
        at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125)
        at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@11a7ba62 has not been refreshed yet
        at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1141)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1159)
        at org.apereo.cas.util.spring.ApplicationContextProvider.getMessagSanitizer(ApplicationContextProvider.java:208)
        at org.apereo.cas.logging.LoggingUtils.prepareLogEvent(LoggingUtils.java:28)
        at org.apereo.cas.logging.CasAppender.append(CasAppender.java:80)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:161)
        ... 18 more
2022-11-22 16:35:43,665 Log4j2-TF-1-AsyncLogger[AsyncContext@2b98378d]-1 ERROR An exception occurred processing Appender casFile java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.Annotation
ConfigServletWebServerApplicationContext@11a7ba62 has not been refreshed yet
        at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1141)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1159)
        at org.apereo.cas.util.spring.ApplicationContextProvider.getMessagSanitizer(ApplicationContextProvider.java:208)
        at org.apereo.cas.logging.LoggingUtils.prepareLogEvent(LoggingUtils.java:28)
        at org.apereo.cas.logging.CasAppender.append(CasAppender.java:80)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:161)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:134)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:125)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:89)
        at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:675)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:633)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.logParent(LoggerConfig.java:666)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:635)
AsyncLogger error handling event seq=   at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.logParent(LoggerConfig.java:666)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:635)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:604)
        at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:98)
        at org.apache.logging.log4j.core.async.AsyncLogger.actualAsyncLog(AsyncLogger.java:488)
14, value='org.apache.logging.log4j.core.async.RingBufferLogEvent@6dc89390': org.apache.logging.log4j.core.appender.AppenderLoggingException: An exception occurred processing Appender casFile
        at org.apache.logging.log4j.core.async.RingBufferLogEvent.execute(RingBufferLogEvent.java:156)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:51)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:29)
        at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168)
        at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125)
        at java.base/java.lang.Thread.run(Thread.java:834)

org.apache.logging.log4j.core.appender.AppenderLoggingException: An exception occurred processing Appender casFile
        at org.apache.logging.log4j.core.appender.DefaultErrorHandler.error(DefaultErrorHandler.java:96)
        at org.apache.logging.log4j.core.config.AppenderControl.handleAppenderError(AppenderControl.java:170)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:163)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:134)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:125)
        at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:89)
        at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:675)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:633)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.logParent(LoggerConfig.java:666)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:635)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.logParent(LoggerConfig.java:666)
        at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:635)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:616)
        at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:604)
        at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:98)
        at org.apache.logging.log4j.core.async.AsyncLogger.actualAsyncLog(AsyncLogger.java:488)
        at org.apache.logging.log4j.core.async.RingBufferLogEvent.execute(RingBufferLogEvent.java:156)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:51)
        at org.apache.logging.log4j.core.async.RingBufferLogEventHandler.onEvent(RingBufferLogEventHandler.java:29)
        at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168)
        at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125)
        at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@11a7ba62 has not been refreshed yet
        at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1141)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1159)
        at org.apereo.cas.util.spring.ApplicationContextProvider.getMessagSanitizer(ApplicationContextProvider.java:208)
        at org.apereo.cas.logging.LoggingUtils.prepareLogEvent(LoggingUtils.java:28)
        at org.apereo.cas.logging.CasAppender.append(CasAppender.java:80)
        at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:161)
        ... 21 more

Thank you very much.

---

Disclaimer This message (including any attachments) may contain confidential information intended for a specific individual and/or purpose. If you are not the intended recipient, please delete this message and notify the sender and the University immediately. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is prohibited as it may be unlawful. In addition, the University specifically denies any responsibility for the accuracy or quality of information obtained through University E-mail Facilities. Any views and opinions expressed in the email(s) are those of the author(s), and do not necessarily represent the views and opinions of the University. The University accepts no liability whatsoever for any losses or damages that may be incurred or caused to any party as a result of the use of such information.

[Gregory G]

I have the same error since CAS 6.6 with JPA, something is broken ?

[Ps Chu]

Hi Gregory,

Would you be able to solve this issue? I have tried to upgrade to cas version 6.6.6 but still no luck.

[Ps Chu]

Finally I figure out it is my configuration mistake. It is working after upgraded the cas version 6.6.6 with a correct configuration.

Thanks all.

[Pablo Vidaurri]

How about letting us know the mistake you made incase we (like @Gregory C) also make the same mistake? :)

[Ps Chu]

My configuration mistake mentioned above was that I tried to connect to the sybase db this time (Not MS SQL) with below configuration after the cas version upgraded to 6.6.6:

cas.service-registry.jpa.enabled=true
cas.service-registry.jpa.driver-class=net.sourceforge.jtds.jdbc.Driver
cas.service-registry.jpa.user=
cas.service-registry.jpa.password=
cas.service-registry.jpa.url=
cas.service-registry.jpa.dialect=org.hibernate.dialect.SybaseASE15Dialect

It seems that ANOTHER error was occoured:

cas-overlay-cas-1    | 2023-03-16 12:58:11,347 ERROR [com.zaxxer.hikari.pool.PoolBase] - <55e6e78e-a96d-4eab-87cb-40339b4ca569 - Failed to execute isValid() for connection, configure connection test
query (null).>
cas-overlay-cas-1    | 2023-03-16 12:58:11,352 ERROR [org.springframework.boot.web.embedded.tomcat.TomcatStarter] - <Error starting Tomcat context. Exception: org.springframework.beans.factory.Unsati
sfiedDependencyException. Message: Error creating bean with name 'casCorsFilter' defined in class path resource [org/apereo/cas/config/CasFiltersConfiguration$CasFiltersCorsConfiguration.class]: Unsa

tisfied dependency expressed through method 'casCorsFilter' parameter 1; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'corsHttpW

ebRequestConfigurationSource' defined in class path resource [org/apereo/cas/config/CasFiltersConfiguration$CasFiltersCorsConfiguration.class]: Unsatisfied dependency expressed through method 'corsHt
tpWebRequestConfigurationSource' parameter 3; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'servicesManager' defined in class pa
th resource [org/apereo/cas/config/CasCoreServicesConfiguration$CasCoreServicesManagerConfiguration.class]: Unsatisfied dependency expressed through method 'servicesManager' parameter 0; nested excep
tion is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'defaultServicesManagerExecutionPlanConfigurer' defined in class path resource [org/apereo/cas/
config/CasCoreServicesConfiguration$CasCoreServicesManagerExecutionPlanConfiguration.class]: Unsatisfied dependency expressed through method 'defaultServicesManagerExecutionPlanConfigurer' parameter

1; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'servicesManagerConfigurationContext' defined in class path resource [org/apereo
/cas/config/CasCoreServicesConfiguration$CasCoreServicesManagerExecutionPlanConfiguration.class]: Unsatisfied dependency expressed through method 'servicesManagerConfigurationContext' parameter 0; ne
sted exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'serviceRegistry' defined in class path resource [org/apereo/cas/config/CasCoreServic

esConfiguration$CasCoreServiceRegistryConfiguration.class]: Unsatisfied dependency expressed through method 'serviceRegistry' parameter 2; nested exception is org.springframework.beans.factory.BeanCr
eationException: Error creating bean with name 'serviceRegistryExecutionPlan' defined in class path resource [org/apereo/cas/config/CasCoreServicesConfiguration$CasCoreServiceRegistryPlanConfiguratio

n.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apereo.cas.services.ServiceRegistryExecuti

onPlan]: Factory method 'serviceRegistryExecutionPlan' threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'jpaService
RegistryExecutionPlanConfigurer' defined in class path resource [org/apereo/cas/config/JpaServiceRegistryConfiguration$JpaServiceRegistryPlanConfiguration.class]: Unsatisfied dependency expressed thr
ough method 'jpaServiceRegistryExecutionPlanConfigurer' parameter 1; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'jpaServiceReg
istry' defined in class path resource [org/apereo/cas/config/JpaServiceRegistryConfiguration$JpaServiceRegistryBaseConfiguration.class]: Unsatisfied dependency expressed through method 'jpaServiceReg
istry' parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'jdbcServiceRegistryTransactionTemplate' defined in class path
resource [org/apereo/cas/config/JpaServiceRegistryConfiguration$JpaServiceRegistryTransactionConfiguration.class]: Unsatisfied dependency expressed through method 'jdbcServiceRegistryTransactionTempl
ate' parameter 1; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'transactionManagerServiceReg' defined in class path resource [or
g/apereo/cas/config/JpaServiceRegistryConfiguration$JpaServiceRegistryTransactionConfiguration.class]: Unsatisfied dependency expressed through method 'transactionManagerServiceReg' parameter 1; nest
ed exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'serviceEntityManagerFactory' defined in class path resource [org/apereo/cas/config/JpaServiceRe
gistryConfiguration$JpaServiceRegistryEntityConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to ins
tantiate [org.springframework.beans.factory.FactoryBean]: Factory method 'serviceEntityManagerFactory' threw exception; nested exception is java.lang.AbstractMethodError>
cas-overlay-cas-1    | 2023-03-16 12:58:11,364 WARN [org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext] - <Exception encountered during context initializ
ation - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Un

able to start embedded Tomcat>

So, it works finally after I added one more OPTIOANL configuration as below. 

cas.service-registry.jpa.health-query=SELECT 1

Maybe my db is kind of "legacy" database anyways.

If connecting to MSSQL, everything is working after the cas version upgraded. (without the need to add the OPTIONAL configuration)