11-Oct-2023 06:01:45.451 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name:   Apache Tomcat/8.5.85
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Jan 11 2023 00:09:15 UTC
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 8.5.85.0
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Windows Server 2019
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.0
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             C:\_YES\tools\java\jdk1.8.0_261\jre
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_261-b12
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\conf\logging.properties
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85
11-Oct-2023 06:01:45.461 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\temp
11-Oct-2023 06:01:45.467 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded Apache Tomcat Native library [1.2.35] using APR version [1.7.0].
11-Oct-2023 06:01:45.467 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true], UDS [{4}].
11-Oct-2023 06:01:45.468 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
11-Oct-2023 06:01:45.473 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.1q  5 Jul 2022]
11-Oct-2023 06:01:45.677 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
11-Oct-2023 06:01:45.706 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 775 ms
11-Oct-2023 06:01:45.781 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
11-Oct-2023 06:01:45.782 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/8.5.85]
11-Oct-2023 06:01:45.851 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\WebAPI.war]
11-Oct-2023 06:01:45.875 WARNING [localhost-startStop-1] org.apache.catalina.startup.SetContextPropertiesRule.begin [SetContextPropertiesRule]{Context} Setting property 'antiJARLocking' to 'true' did not find a matching property.
11-Oct-2023 06:02:01.581 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::       (v1.5.22.RELEASE)

2023-10-11 06:02:04.299 INFO localhost-startStop-1 org.springframework.boot.StartupInfoLogger - [] - Starting WebApi on EC2AMAZ-VRRANO5 with PID 3408 (C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\WebAPI\WEB-INF\classes started by Administrator in C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\bin)
2023-10-11 06:02:04.314 INFO localhost-startStop-1 org.springframework.boot.SpringApplication - [] - The following profiles are active: default
2023-10-11 06:02:04.394 INFO localhost-startStop-1 org.springframework.context.support.AbstractApplicationContext - [] - Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@47e9c083: startup date [Wed Oct 11 06:02:04 UTC 2023]; root of context hierarchy
2023-10-11 06:02:04.664 INFO background-preinit org.hibernate.validator.internal.util.Version - [] - HV000001: Hibernate Validator 5.4.2.Final
2023-10-11 06:02:07.521 INFO localhost-startStop-1 org.springframework.beans.factory.support.DefaultListableBeanFactory - [] - Overriding bean definition for bean 'jobBuilders' with a different definition: replacing [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration; factoryMethodName=jobBuilders; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/springframework/batch/core/configuration/annotation/SimpleBatchConfiguration.class]] with [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=true; factoryBeanName=jobConfig; factoryMethodName=jobBuilders; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/ohdsi/webapi/JobConfig.class]]
2023-10-11 06:02:07.904 INFO localhost-startStop-1 org.springframework.beans.factory.support.DefaultListableBeanFactory - [] - Overriding bean definition for bean 'requestContextFilter' with a different definition: replacing [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=org.springframework.boot.autoconfigure.jersey.JerseyAutoConfiguration; factoryMethodName=requestContextFilter; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/springframework/boot/autoconfigure/jersey/JerseyAutoConfiguration.class]] with [Root bean: class [org.springframework.boot.autoconfigure.web.WebMvcAutoConfiguration$WebMvcAutoConfigurationAdapter]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=requestContextFilter; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/springframework/boot/autoconfigure/web/WebMvcAutoConfiguration$WebMvcAutoConfigurationAdapter.class]]
2023-10-11 06:02:08.445 INFO localhost-startStop-1 org.springframework.integration.config.IntegrationRegistrar - [] - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
2023-10-11 06:02:09.204 INFO localhost-startStop-1 org.springframework.integration.config.DefaultConfiguringBeanFactoryPostProcessor - [] - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
2023-10-11 06:02:09.236 INFO localhost-startStop-1 org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor - [] - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
2023-10-11 06:02:09.346 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'converterConfiguration' of type [org.ohdsi.webapi.ConverterConfiguration$$EnhancerBySpringCGLIB$$494e6d7d] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:09.419 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'conversionService' of type [org.springframework.core.convert.support.DefaultConversionService] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:09.982 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$e2b34631] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:10.482 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'shiroConfiguration' of type [org.ohdsi.webapi.ShiroConfiguration$$EnhancerBySpringCGLIB$$2721ac2c] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:10.498 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'flywayConfig' of type [org.ohdsi.webapi.FlywayConfig$$EnhancerBySpringCGLIB$$e556f885] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:11.242 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'secondaryDataSource' of type [org.apache.tomcat.jdbc.pool.DataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:11.294 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration' of type [org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration$$EnhancerBySpringCGLIB$$c4a6e991] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:11.385 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'spring.datasource-org.springframework.boot.autoconfigure.jdbc.DataSourceProperties' of type [org.springframework.boot.autoconfigure.jdbc.DataSourceProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:11.401 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'dataSourceInitializer' of type [org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:11.544 INFO localhost-startStop-1 org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Flyway 4.2.0 by Boxfuse
2023-10-11 06:02:12.836 INFO localhost-startStop-1 org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Database: jdbc:postgresql://localhost:5432/OHDSI (PostgreSQL 15.1)
2023-10-11 06:02:13.398 INFO localhost-startStop-1 org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Current version of schema "webapi": 2.12.0.20220719110154
2023-10-11 06:02:13.398 WARN localhost-startStop-1 org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - outOfOrder mode is active. Migration of schema "webapi" may not be reproducible.
2023-10-11 06:02:13.398 INFO localhost-startStop-1 org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Schema "webapi" is up to date. No migration necessary.
2023-10-11 06:02:13.398 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'flyway' of type [org.flywaydb.core.Flyway] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:13.430 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'disabledSecurity' of type [org.ohdsi.webapi.shiro.management.DisabledSecurity] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:13.450 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'noLockoutPolicy' of type [org.ohdsi.webapi.shiro.lockout.NoLockoutPolicy] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:13.779 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'securityManager' of type [org.ohdsi.webapi.shiro.AtlasWebSecurityManager] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:13.953 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'integrationGlobalProperties' of type [org.springframework.beans.factory.config.PropertiesFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:13.969 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'integrationGlobalProperties' of type [java.util.Properties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-10-11 06:02:14.132 INFO localhost-startStop-1 org.springframework.boot.context.embedded.EmbeddedWebApplicationContext - [] - Root WebApplicationContext: initialization completed in 9738 ms
2023-10-11 06:02:15.703 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - datasource.url is: jdbc:postgresql://localhost:5432/OHDSI
2023-10-11 06:02:15.703 INFO localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - [] - Loaded JDBC driver: org.postgresql.Driver
2023-10-11 06:02:15.703 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - driver loaded: org.postgresql.Driver
2023-10-11 06:02:15.767 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - driver loaded: com.microsoft.sqlserver.jdbc.SQLServerDriver
2023-10-11 06:02:15.767 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - error loading oracle.jdbc.driver.OracleDriver driver. oracle.jdbc.driver.OracleDriver
2023-10-11 06:02:15.846 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - driver loaded: com.amazon.redshift.jdbc.Driver
2023-10-11 06:02:15.863 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - error loading com.cloudera.impala.jdbc.Driver driver. com.cloudera.impala.jdbc.Driver
2023-10-11 06:02:15.863 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - error loading net.starschema.clouddb.jdbc.BQDriver driver. net.starschema.clouddb.jdbc.BQDriver
2023-10-11 06:02:15.863 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - error loading org.netezza.Driver driver. org.netezza.Driver
2023-10-11 06:02:15.879 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - error loading com.simba.googlebigquery.jdbc42.Driver driver. com.simba.googlebigquery.jdbc42.Driver
2023-10-11 06:02:15.888 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - error loading org.apache.hive.jdbc.HiveDriver driver. org.apache.hive.jdbc.HiveDriver
2023-10-11 06:02:15.888 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - driver loaded: com.simba.spark.jdbc.Driver
2023-10-11 06:02:15.895 INFO localhost-startStop-1 org.ohdsi.webapi.DataAccessConfig - [] - error loading net.snowflake.client.jdbc.SnowflakeDriver driver. net.snowflake.client.jdbc.SnowflakeDriver
2023-10-11 06:02:16.373 INFO localhost-startStop-1 org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean - [] - Building JPA container EntityManagerFactory for persistence unit 'default'
2023-10-11 06:02:16.421 INFO localhost-startStop-1 org.hibernate.jpa.internal.util.LogHelper - [] - HHH000204: Processing PersistenceUnitInfo [name: default]
2023-10-11 06:02:16.611 INFO localhost-startStop-1 org.hibernate.Version - [] - HHH000412: Hibernate Core {5.4.2.Final}
2023-10-11 06:02:17.057 INFO localhost-startStop-1 org.hibernate.annotations.common.reflection.java.JavaReflectionManager - [] - HCANN000001: Hibernate Commons Annotations {5.1.0.Final}
2023-10-11 06:02:18.210 INFO localhost-startStop-1 org.hibernate.dialect.Dialect - [] - HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL9Dialect
2023-10-11 06:02:19.342 WARN localhost-startStop-1 org.hibernate.id.SequenceGenerator - [] - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead.  See Hibernate Domain Model Mapping Guide for details.
2023-10-11 06:02:19.388 WARN localhost-startStop-1 org.hibernate.id.SequenceGenerator - [] - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead.  See Hibernate Domain Model Mapping Guide for details.
2023-10-11 06:02:19.468 WARN localhost-startStop-1 org.hibernate.mapping.RootClass - [] - HHH000038: Composite-id class does not override equals(): org.ohdsi.webapi.conceptset.ConceptSetGenerationInfoKey
2023-10-11 06:02:19.482 WARN localhost-startStop-1 org.hibernate.mapping.RootClass - [] - HHH000039: Composite-id class does not override hashCode(): org.ohdsi.webapi.conceptset.ConceptSetGenerationInfoKey
2023-10-11 06:02:21.836 INFO localhost-startStop-1 org.hibernate.engine.transaction.jta.platform.internal.JtaPlatformInitiator - [] - HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2023-10-11 06:02:21.852 INFO localhost-startStop-1 org.springframework.orm.jpa.AbstractEntityManagerFactoryBean - [] - Initialized JPA EntityManagerFactory for persistence unit 'default'
2023-10-11 06:02:25.607 INFO localhost-startStop-1 org.springframework.batch.core.repository.support.JobRepositoryFactoryBean - [] - No database type set, using meta data indicating: POSTGRES
2023-10-11 06:02:26.017 INFO localhost-startStop-1 org.springframework.scheduling.concurrent.ExecutorConfigurationSupport - [] - Initializing ExecutorService
2023-10-11 06:02:26.048 INFO localhost-startStop-1 org.springframework.scheduling.concurrent.ExecutorConfigurationSupport - [] - Initializing ExecutorService 'taskExecutor'
2023-10-11 06:02:27.309 INFO localhost-startStop-1 org.springframework.boot.web.servlet.ServletRegistrationBean - [] - Mapping servlet: 'org.ohdsi.webapi.JerseyConfig' to [/*]
2023-10-11 06:02:27.309 INFO localhost-startStop-1 org.springframework.boot.web.servlet.ServletRegistrationBean - [] - Mapping servlet: 'dispatcherServlet' to [/]
2023-10-11 06:02:27.325 INFO localhost-startStop-1 org.springframework.boot.web.servlet.AbstractFilterRegistrationBean - [] - Mapping filter: 'errorPageFilter' to: [/*]
2023-10-11 06:02:27.325 INFO localhost-startStop-1 org.springframework.boot.web.servlet.AbstractFilterRegistrationBean - [] - Mapping filter: 'characterEncodingFilter' to: [/*]
2023-10-11 06:02:27.325 INFO localhost-startStop-1 org.springframework.boot.web.servlet.AbstractFilterRegistrationBean - [] - Mapping filter: 'hiddenHttpMethodFilter' to: [/*]
2023-10-11 06:02:27.325 INFO localhost-startStop-1 org.springframework.boot.web.servlet.AbstractFilterRegistrationBean - [] - Mapping filter: 'httpPutFormContentFilter' to: [/*]
2023-10-11 06:02:27.325 INFO localhost-startStop-1 org.springframework.boot.web.servlet.AbstractFilterRegistrationBean - [] - Mapping filter: 'requestContextFilter' to: [/*]
2023-10-11 06:02:27.325 INFO localhost-startStop-1 org.springframework.boot.web.servlet.AbstractFilterRegistrationBean - [] - Mapping filter: 'exceptionHandlerFilter' to: [/*]
2023-10-11 06:02:27.325 INFO localhost-startStop-1 org.springframework.boot.web.servlet.AbstractFilterRegistrationBean - [] - Mapping filter: 'cacheFilter' to: [/*]
2023-10-11 06:02:27.325 INFO localhost-startStop-1 org.springframework.boot.web.servlet.AbstractFilterRegistrationBean - [] - Mapping filter: 'corsFilter' to: [/*]
2023-10-11 06:02:27.325 INFO localhost-startStop-1 org.springframework.boot.web.servlet.AbstractFilterRegistrationBean - [] - Mapping filter: 'shiroFilter' to: [/*]
2023-10-11 06:02:29.425 INFO localhost-startStop-1 org.ohdsi.webapi.executionengine.service.ScriptExecutionServiceImpl - [] - Invalidating execution engine based analyses
2023-10-11 06:02:32.192 INFO localhost-startStop-1 org.springframework.batch.core.launch.support.SimpleJobLauncher - [] - No TaskExecutor has been set, defaulting to synchronous executor.
2023-10-11 06:02:32.623 INFO taskExecutor-1 org.springframework.batch.core.launch.support.SimpleJobLauncher$1 - [] - Job: [SimpleJob: [name=warming cache: DATABRICKS_COVID_OHDSI_PROD]] launched with the following parameters: [{jobName=warming cache: DATABRICKS_COVID_OHDSI_PROD, source_key=DATABRICKS_COVID_OHDSI_PROD, source_id=-1, time=1697004152388, jobAuthor=anonymous}]
2023-10-11 06:02:33.005 INFO taskExecutor-1 org.springframework.batch.core.job.SimpleStepHandler - [] - Executing step: [warming cache: DATABRICKS_COVID_OHDSI_PROD]
2023-10-11 06:02:33.180 INFO localhost-startStop-1 org.springframework.scheduling.concurrent.ExecutorConfigurationSupport - [] - Initializing ExecutorService
2023-10-11 06:02:33.213 INFO localhost-startStop-1 org.springframework.scheduling.concurrent.ExecutorConfigurationSupport - [] - Initializing ExecutorService 'taskScheduler'
2023-10-11 06:02:33.213 INFO taskExecutor-1 org.springframework.batch.core.launch.support.SimpleJobLauncher$1 - [] - Job: [SimpleJob: [name=warming cache: DATABRICKS_COVID_OHDSI_PROD]] launched with the following parameters: [{jobName=warming cache: DATABRICKS_COVID_OHDSI_PROD, source_key=DATABRICKS_COVID_OHDSI_PROD, source_id=2, jobAuthor=anonymous, time=1697004153085}]
2023-10-11 06:02:33.372 WARN localhost-startStop-1 org.springframework.aop.framework.CglibAopProxy - [] - Unable to proxy interface-implementing method [public final void com.odysseusinc.scheduler.service.BaseJobServiceImpl.setApplicationContext(org.springframework.context.ApplicationContext) throws org.springframework.beans.BeansException] because it is marked as final: Consider using interface-based JDK proxies instead!
2023-10-11 06:02:33.372 INFO localhost-startStop-1 org.springframework.aop.framework.CglibAopProxy - [] - Final method [public final void com.odysseusinc.scheduler.service.BaseJobServiceImpl.setApplicationContext(org.springframework.context.ApplicationContext) throws org.springframework.beans.BeansException] cannot get proxied via CGLIB: Calls to this method will NOT be routed to the target instance and might lead to NPEs against uninitialized fields in the proxy instance.
2023-10-11 06:02:33.372 INFO localhost-startStop-1 org.springframework.aop.framework.CglibAopProxy - [] - Final method [protected final com.cronutils.model.time.ExecutionTime com.odysseusinc.scheduler.service.BaseJobServiceImpl.getExecutionTime(com.odysseusinc.scheduler.model.ArachneJob)] cannot get proxied via CGLIB: Calls to this method will NOT be routed to the target instance and might lead to NPEs against uninitialized fields in the proxy instance.
2023-10-11 06:02:33.498 INFO taskExecutor-1 org.springframework.batch.core.job.SimpleStepHandler - [] - Executing step: [warming cache: DATABRICKS_COVID_OHDSI_PROD achilles]
2023-10-11 06:02:33.815 INFO localhost-startStop-1 org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Current version of schema "webapi": 2.12.0.20220719110154
2023-10-11 06:02:33.815 WARN localhost-startStop-1 org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - outOfOrder mode is active. Migration of schema "webapi" may not be reproducible.
2023-10-11 06:02:33.815 INFO localhost-startStop-1 org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Schema "webapi" is up to date. No migration necessary.
2023-10-11 06:02:35.060 INFO localhost-startStop-1 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - [] - Looking for @ControllerAdvice: org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@47e9c083: startup date [Wed Oct 11 06:02:04 UTC 2023]; root of context hierarchy
2023-10-11 06:02:35.819 INFO localhost-startStop-1 org.springframework.web.servlet.handler.AbstractUrlHandlerMapping - [] - Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
2023-10-11 06:02:35.819 INFO localhost-startStop-1 org.springframework.web.servlet.handler.AbstractUrlHandlerMapping - [] - Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
ERROR StatusLogger Unrecognized format specifier [d]
ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [thread]
ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [level]
ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [logger]
ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [msg]
ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [n]
ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [d]
ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [thread]
ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [level]
ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [logger]
ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [msg]
ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [n]
ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.
2023-10-11 06:02:35.982 INFO localhost-startStop-1 org.springframework.web.servlet.handler.AbstractUrlHandlerMapping - [] - Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
2023-10-11 06:02:36.663 INFO localhost-startStop-1 org.springframework.ldap.core.support.AbstractContextSource - [] - Property 'userDn' not set - anonymous context will be used for read-write operations
2023-10-11 06:02:36.902 INFO localhost-startStop-1 org.springframework.ui.freemarker.SpringTemplateLoader - [] - SpringTemplateLoader for FreeMarker: using resource loader [org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@47e9c083: startup date [Wed Oct 11 06:02:04 UTC 2023]; root of context hierarchy] and template loader path [classpath:/templates/]
2023-10-11 06:02:36.902 INFO localhost-startStop-1 org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer - [] - ClassTemplateLoader for Spring macros added to FreeMarker configuration
2023-10-11 06:02:38.411 INFO localhost-startStop-1 org.springframework.jmx.export.MBeanExporter - [] - Registering beans for JMX exposure on startup
2023-10-11 06:02:38.451 INFO localhost-startStop-1 org.springframework.jmx.export.MBeanExporter - [] - Bean with name 'taskExecutor' has been autodetected for JMX exposure
2023-10-11 06:02:38.451 INFO localhost-startStop-1 org.springframework.jmx.export.MBeanExporter - [] - Bean with name 'integrationMbeanExporter' has been autodetected for JMX exposure
2023-10-11 06:02:38.458 INFO localhost-startStop-1 org.springframework.jmx.export.MBeanExporter - [] - Located managed bean 'taskExecutor': registering with JMX server as MBean [org.ohdsi.webapi.util:name=taskExecutor,type=ManagedThreadPoolTaskExecutor]
2023-10-11 06:02:38.522 INFO localhost-startStop-1 org.springframework.jmx.export.MBeanExporter - [] - Located managed bean 'integrationMbeanExporter': registering with JMX server as MBean [org.springframework.integration.monitor:name=integrationMbeanExporter,type=IntegrationMBeanExporter]
2023-10-11 06:02:38.554 INFO localhost-startStop-1 org.springframework.jmx.export.MBeanExporter - [] - Registering beans for JMX exposure on startup
2023-10-11 06:02:38.554 INFO localhost-startStop-1 org.springframework.integration.monitor.IntegrationMBeanExporter - [] - Registering MessageChannel nullChannel
2023-10-11 06:02:38.575 INFO localhost-startStop-1 org.springframework.jmx.export.MBeanExporter - [] - Located managed bean 'org.springframework.integration:type=MessageChannel,name=nullChannel': registering with JMX server as MBean [org.springframework.integration:type=MessageChannel,name=nullChannel]
2023-10-11 06:02:38.586 INFO localhost-startStop-1 org.springframework.integration.monitor.IntegrationMBeanExporter - [] - Registering MessageChannel errorChannel
2023-10-11 06:02:38.586 INFO localhost-startStop-1 org.springframework.jmx.export.MBeanExporter - [] - Located managed bean 'org.springframework.integration:type=MessageChannel,name=errorChannel': registering with JMX server as MBean [org.springframework.integration:type=MessageChannel,name=errorChannel]
2023-10-11 06:02:38.700 INFO localhost-startStop-1 org.springframework.integration.monitor.IntegrationMBeanExporter - [] - Registering MessageHandler errorLogger
2023-10-11 06:02:38.713 INFO localhost-startStop-1 org.springframework.jmx.export.MBeanExporter - [] - Located managed bean 'org.springframework.integration:type=MessageHandler,name=errorLogger,bean=internal': registering with JMX server as MBean [org.springframework.integration:type=MessageHandler,name=errorLogger,bean=internal]
2023-10-11 06:02:38.763 INFO localhost-startStop-1 org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup - [] - Starting beans in phase 0
2023-10-11 06:02:38.763 INFO localhost-startStop-1 org.springframework.integration.endpoint.EventDrivenConsumer - [] - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
2023-10-11 06:02:38.763 INFO localhost-startStop-1 org.springframework.integration.channel.AbstractSubscribableChannel - [] - Channel 'application:default:8080.errorChannel' has 1 subscriber(s).
2023-10-11 06:02:38.763 INFO localhost-startStop-1 org.springframework.integration.endpoint.AbstractEndpoint - [] - started _org.springframework.integration.errorLogger
2023-10-11 06:02:38.763 INFO localhost-startStop-1 org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup - [] - Starting beans in phase 2147483647
2023-10-11 06:02:38.794 INFO taskScheduler-1 org.ohdsi.webapi.tag.TagService - [] - Starting tags statistics refreshing
2023-10-11 06:02:38.809 INFO localhost-startStop-1 org.springframework.boot.StartupInfoLogger - [] - Started WebApi in 35.28 seconds (JVM running for 54.201)
11-Oct-2023 06:02:38.888 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\WebAPI.war] has finished in [53,037] ms
11-Oct-2023 06:02:38.904 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\atlas]
2023-10-11 06:02:39.136 INFO taskScheduler-3 org.ohdsi.webapi.executionengine.service.ScriptExecutionServiceImpl - [] - Invalidating execution engine based analyses
2023-10-11 06:02:39.607 INFO taskScheduler-1 org.ohdsi.webapi.tag.TagService - [] - Finishing tags statistics refreshing
11-Oct-2023 06:02:40.640 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Oct-2023 06:02:40.640 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\atlas] has finished in [1,736] ms
11-Oct-2023 06:02:40.640 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\docs]
11-Oct-2023 06:02:42.260 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Oct-2023 06:02:42.260 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\docs] has finished in [1,620] ms
11-Oct-2023 06:02:42.260 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\examples]
11-Oct-2023 06:02:44.158 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Oct-2023 06:02:44.221 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\examples] has finished in [1,961] ms
11-Oct-2023 06:02:44.221 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\host-manager]
11-Oct-2023 06:02:45.857 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Oct-2023 06:02:45.873 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\host-manager] has finished in [1,652] ms
11-Oct-2023 06:02:45.873 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\manager]
11-Oct-2023 06:02:47.446 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Oct-2023 06:02:47.451 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\manager] has finished in [1,578] ms
11-Oct-2023 06:02:47.451 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\ROOT]
11-Oct-2023 06:02:49.092 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Oct-2023 06:02:49.099 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\_YES\servers\apache-tomcat\apache-tomcat-8.5.85-windows-x64\apache-tomcat-8.5.85\webapps\ROOT] has finished in [1,648] ms
11-Oct-2023 06:02:49.108 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
11-Oct-2023 06:02:49.124 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 63430 ms
2023-10-11 06:02:57.275 WARN http-nio-8080-exec-1 org.glassfish.jersey.server.ApplicationHandler - [] - Component of class interface org.ohdsi.webapi.service.IRAnalysisResource cannot be instantiated and will be ignored.
2023-10-11 06:02:58.550 WARN http-nio-8080-exec-1 org.glassfish.jersey.internal.Errors - [] - The following warnings have been detected: WARNING: The (sub)resource method getIRAnalysisList in org.ohdsi.webapi.service.IRAnalysisResource contains empty path annotation.
WARNING: The (sub)resource method createAnalysis in org.ohdsi.webapi.service.IRAnalysisResource contains empty path annotation.
WARNING: The (sub)resource method createAnalysis in org.ohdsi.webapi.feanalysis.FeAnalysisController contains empty path annotation.
WARNING: The (sub)resource method list in org.ohdsi.webapi.feanalysis.FeAnalysisController contains empty path annotation.
WARNING: The (sub)resource method getConceptSets in org.ohdsi.webapi.service.ConceptSetService contains empty path annotation.
WARNING: The (sub)resource method createConceptSet in org.ohdsi.webapi.service.ConceptSetService contains empty path annotation.
WARNING: The (sub)resource method create in org.ohdsi.webapi.pathway.PathwayController contains empty path annotation.
WARNING: The (sub)resource method list in org.ohdsi.webapi.pathway.PathwayController contains empty path annotation.
WARNING: The (sub)resource method page in org.ohdsi.webapi.reusable.ReusableController contains empty path annotation.
WARNING: The (sub)resource method create in org.ohdsi.webapi.reusable.ReusableController contains empty path annotation.
WARNING: The (sub)resource method getResources in org.ohdsi.webapi.i18n.I18nController contains empty path annotation.
WARNING: The (sub)resource method list in org.ohdsi.webapi.job.NotificationController contains empty path annotation.
WARNING: The (sub)resource method getInfo in org.ohdsi.webapi.info.InfoService contains empty path annotation.
WARNING: The (sub)resource method create in org.ohdsi.webapi.cohortcharacterization.CcController contains empty path annotation.
WARNING: The (sub)resource method list in org.ohdsi.webapi.cohortcharacterization.CcController contains empty path annotation.
WARNING: The (sub)resource method getCohortDefinitionList in org.ohdsi.webapi.service.CohortDefinitionService contains empty path annotation.
WARNING: The (sub)resource method createCohortDefinition in org.ohdsi.webapi.service.CohortDefinitionService contains empty path annotation.
WARNING: The (sub)resource method getPermissions in org.ohdsi.webapi.security.PermissionController contains empty path annotation.
WARNING: The (sub)resource method create in org.ohdsi.webapi.tag.TagController contains empty path annotation.
WARNING: The (sub)resource method list in org.ohdsi.webapi.tag.TagController contains empty path annotation.
WARNING: The (sub)resource method createJob in org.ohdsi.webapi.user.importer.UserImportJobController contains empty path annotation.
WARNING: The (sub)resource method listJobs in org.ohdsi.webapi.user.importer.UserImportJobController contains empty path annotation.
WARNING: The (sub)resource method getAnalysisList in org.ohdsi.webapi.estimation.EstimationController contains empty path annotation.
WARNING: The (sub)resource method createEstimation in org.ohdsi.webapi.estimation.EstimationController contains empty path annotation.
WARNING: The (sub)resource method getFeasibilityStudyList in org.ohdsi.webapi.service.FeasibilityService contains empty path annotation.
WARNING: The (sub)resource method createStudy in org.ohdsi.webapi.service.FeasibilityService contains empty path annotation.
WARNING: The (sub)resource method createSource in org.ohdsi.webapi.source.SourceController contains empty path annotation.
WARNING: The (sub)resource method getAnalysisList in org.ohdsi.webapi.prediction.PredictionController contains empty path annotation.
WARNING: The (sub)resource method createAnalysis in org.ohdsi.webapi.prediction.PredictionController contains empty path annotation.

2023-10-11 06:02:58.660 INFO Finalizer com.simba.spark.jdbc42.internal.apache.commons.logging.impl.Jdk14Logger - [] - I/O exception (java.net.SocketException) caught when processing request to {s}->https://nachc-databricks.cloud.databricks.com:443: Socket closed
2023-10-11 06:02:58.661 INFO Finalizer com.simba.spark.jdbc42.internal.apache.commons.logging.impl.Jdk14Logger - [] - Retrying request to {s}->https://nachc-databricks.cloud.databricks.com:443
2023-10-11 06:03:29.249 WARN taskExecutor-1 org.ohdsi.webapi.achilles.service.AchillesCacheService - [] - Cannot cache drilldown reports for DATABRICKS_COVID_OHDSI_PROD, domain condition. Check if result schema contains achilles results tables.
2023-10-11 06:03:56.804 ERROR http-nio-8080-exec-7 org.ohdsi.webapi.util.GenericExceptionMapper - [] - java.lang.NullPointerException
        at org.ohdsi.webapi.service.VocabularyService.getVocabularies(VocabularyService.java:1105)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
        at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
        at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
        at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
        at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
        at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
        at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
        at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
        at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
        at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
        at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
        at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
        at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
        at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
        at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
        at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
        at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
        at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
        at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
        at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
        at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
        at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
        at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
        at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
        at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
        at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
        at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
        at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.ohdsi.webapi.shiro.filters.CacheFilter.doFilter(CacheFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.ohdsi.webapi.shiro.filters.ExceptionHandlerFilter.doFilter(ExceptionHandlerFilter.java:28)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.boot.web.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:128)
        at org.springframework.boot.web.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66)
        at org.springframework.boot.web.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:103)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.springframework.boot.web.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:121)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:885)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1688)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)

2023-10-11 06:03:56.804 ERROR http-nio-8080-exec-1 org.ohdsi.webapi.util.GenericExceptionMapper - [] - java.lang.NullPointerException
        at org.ohdsi.webapi.service.VocabularyService.getDomains(VocabularyService.java:1056)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
        at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
        at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
        at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
        at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
        at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
        at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
        at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
        at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
        at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
        at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
        at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
        at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
        at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
        at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
        at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
        at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
        at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
        at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
        at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
        at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
        at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
        at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
        at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
        at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
        at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
        at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
        at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.ohdsi.webapi.shiro.filters.CacheFilter.doFilter(CacheFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.ohdsi.webapi.shiro.filters.ExceptionHandlerFilter.doFilter(ExceptionHandlerFilter.java:28)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.boot.web.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:128)
        at org.springframework.boot.web.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66)
        at org.springframework.boot.web.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:103)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.springframework.boot.web.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:121)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:885)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1688)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)

2023-10-11 06:03:59.328 WARN taskExecutor-1 org.ohdsi.webapi.achilles.service.AchillesCacheService - [] - Cannot cache drilldown reports for DATABRICKS_COVID_OHDSI_PROD, domain observation. Check if result schema contains achilles results tables.
2023-10-11 06:04:08.754 WARN taskExecutor-1 org.ohdsi.webapi.achilles.service.AchillesCacheService - [] - Cannot cache drilldown reports for DATABRICKS_COVID_OHDSI_PROD, domain conditionera. Check if result schema contains achilles results tables.