hapi-fhir-jpaserver-starter does not work with PostgreSQL 15 and 16
561 views
Skip to first unread message
Martin Neu
Jun 16, 2024, 10:32:51 AM6/16/24
to HAPI FHIR
Hi!
I have this docker compose file:
services:
web:
image: "hapiproject/hapi:latest"
container_name: hapi-fhir
ports:
- "8090:8080"
volumes:
#- ./configs/application.yaml:/data/hapi/application.yaml
#- ./configs:/data/hapi
- ./configs/application.yaml:/data/hapi/application.yaml
environment:
SPRING_CONFIG_LOCATION: 'file:///data/hapi/application.yaml'
networks:
- postgresql_15_postgresql_15
- hapi-network
networks:
postgresql_15_postgresql_15:
external: true
hapi-network:
driver: bridge
I have this docker compose file:
services:
web:
image: "hapiproject/hapi:latest"
container_name: hapi-fhir
ports:
- "8090:8080"
volumes:
#- ./configs/application.yaml:/data/hapi/application.yaml
#- ./configs:/data/hapi
- ./configs/application.yaml:/data/hapi/application.yaml
environment:
SPRING_CONFIG_LOCATION: 'file:///data/hapi/application.yaml'
networks:
- postgresql_15_postgresql_15
- hapi-network
networks:
postgresql_15_postgresql_15:
external: true
hapi-network:
driver: bridge
And this application.yaml
#Uncomment the "servlet" and "context-path" lines below to make the fhir endpoint available at /example/path/fhir instead of the default value of /fhir
server:
# servlet:
# context-path: /example/path
port: 8080
#Adds the option to go to eg. http://localhost:8080/actuator/health for seeing the running configuration
#see https://docs.spring.io/spring-boot/docs/current/reference/html/actuator.html#actuator.endpoints
management:
endpoints:
web:
exposure:
include: "health,prometheus"
spring:
main:
allow-circular-references: true
#allow-bean-definition-overriding: true
flyway:
enabled: false
baselineOnMigrate: true
fail-on-missing-locations: false
datasource:
url: jdbc:postgresql://172.26.0.2:5432/hapi
username: postgres
password: password
driver-class-name: org.postgresql.Driver
# database connection pool size
hikari:
maximum-pool-size: 10
jpa:
properties:
hibernate.format_sql: false
hibernate.show_sql: false
#Hibernate dialect is automatically detected except Postgres and H2.
#If using H2, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect
#If using postgres, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirPostgres94Dialect
hibernate.dialect: ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect
# hibernate.hbm2ddl.auto: update
# hibernate.jdbc.batch_size: 20
# hibernate.cache.use_query_cache: false
# hibernate.cache.use_second_level_cache: false
# hibernate.cache.use_structured_entries: false
# hibernate.cache.use_minimal_puts: false
### These settings will enable fulltext search with lucene or elastic
hibernate.search.enabled: true
### lucene parameters
# hibernate.search.backend.type: lucene
# hibernate.search.backend.analysis.configurer: ca.uhn.fhir.jpa.search.HapiHSearchAnalysisConfigurers$HapiLuceneAnalysisConfigurer
# hibernate.search.backend.directory.type: local-filesystem
# hibernate.search.backend.directory.root: target/lucenefiles
# hibernate.search.backend.lucene_version: lucene_current
### elastic parameters ===> see also elasticsearch section below <===
# hibernate.search.backend.type: elasticsearch
# hibernate.search.backend.analysis.configurer: ca.uhn.fhir.jpa.search.HapiHSearchAnalysisConfigurers$HapiElasticAnalysisConfigurer
hapi:
fhir:
### This flag when enabled to true, will avail evaluate measure operations from CR Module.
### Flag is false by default, can be passed as command line argument to override.
cr:
enabled: false
cdshooks:
enabled: true
clientIdHeaderName: client_id
### This enables the swagger-ui at /fhir/swagger-ui/index.html as well as the /fhir/api-docs (see https://hapifhir.io/hapi-fhir/docs/server_plain/openapi.html)
openapi_enabled: true
### This is the FHIR version. Choose between, DSTU2, DSTU3, R4 or R5
fhir_version: R4
### Flag is false by default. This flag enables runtime installation of IG's.
ig_runtime_upload_enabled: false
### This flag when enabled to true, will avail evaluate measure operations from CR Module.
### enable to use the ApacheProxyAddressStrategy which uses X-Forwarded-* headers
### to determine the FHIR server address
# use_apache_address_strategy: false
### forces the use of the https:// protocol for the returned server address.
### alternatively, it may be set using the X-Forwarded-Proto header.
# use_apache_address_strategy_https: false
### enables the server to overwrite defaults on HTML, css, etc. under the url pattern of eg. /content/custom **
### Folder with custom content MUST be named custom. If omitted then default content applies
#custom_content_path: ./custom
### enables the server host custom content. If e.g. the value ./configs/app is supplied then the content
### will be served under /web/app
#app_content_path: ./configs/app
### enable to set the Server URL
# server_address: http://hapi.fhir.org/baseR4
# defer_indexing_for_codesystems_of_size: 101
# install_transitive_ig_dependencies: true
#implementationguides:
### example from registry (packages.fhir.org)
# swiss:
# name: swiss.mednet.fhir
# version: 0.8.0
# reloadExisting: false
# installMode: STORE_AND_INSTALL
# example not from registry
# ips_1_0_0:
# packageUrl: https://build.fhir.org/ig/HL7/fhir-ips/package.tgz
# name: hl7.fhir.uv.ips
# version: 1.0.0
# supported_resource_types:
# - Patient
# - Observation
##################################################
# Allowed Bundle Types for persistence (defaults are: COLLECTION,DOCUMENT,MESSAGE)
##################################################
# allowed_bundle_types: COLLECTION,DOCUMENT,MESSAGE,TRANSACTION,TRANSACTIONRESPONSE,BATCH,BATCHRESPONSE,HISTORY,SEARCHSET
# allow_cascading_deletes: true
# allow_contains_searches: true
# allow_external_references: true
# allow_multiple_delete: true
# allow_override_default_search_params: true
# auto_create_placeholder_reference_targets: false
### tells the server to automatically append the current version of the target resource to references at these paths
# auto_version_reference_at_paths: Device.patient, Device.location, Device.parent, DeviceMetric.parent, DeviceMetric.source, Observation.device, Observation.subject
# ips_enabled: false
# default_encoding: JSON
# default_pretty_print: true
# default_page_size: 20
# delete_expunge_enabled: true
# enable_repository_validating_interceptor: true
# enable_index_missing_fields: false
# enable_index_of_type: true
# enable_index_contained_resource: false
# resource_dbhistory_enabled: false
### !!Extended Lucene/Elasticsearch Indexing is still a experimental feature, expect some features (e.g. _total=accurate) to not work as expected!!
### more information here: https://hapifhir.io/hapi-fhir/docs/server_jpa/elastic.html
advanced_lucene_indexing: false
bulk_export_enabled: false
bulk_import_enabled: false
# language_search_parameter_enabled: true
# enforce_referential_integrity_on_delete: false
# This is an experimental feature, and does not fully support _total and other FHIR features.
# enforce_referential_integrity_on_delete: false
# enforce_referential_integrity_on_write: false
# etag_support_enabled: true
# expunge_enabled: true
# client_id_strategy: ALPHANUMERIC
# server_id_strategy: SEQUENTIAL_NUMERIC
# fhirpath_interceptor_enabled: false
# filter_search_enabled: true
# graphql_enabled: true
narrative_enabled: false
mdm_enabled: false
mdm_rules_json_location: "mdm-rules.json"
# local_base_urls:
# - https://hapi.fhir.org/baseR4
logical_urls:
- http://terminology.hl7.org/*
- https://terminology.hl7.org/*
- http://snomed.info/*
- https://snomed.info/*
- http://unitsofmeasure.org/*
- https://unitsofmeasure.org/*
- http://loinc.org/*
- https://loinc.org/*
# partitioning:
# allow_references_across_partitions: false
# partitioning_include_in_search_hashes: false
cors:
allow_Credentials: true
# These are allowed_origin patterns, see: https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/web/cors/CorsConfiguration.html#setAllowedOriginPatterns-java.util.List-
allowed_origin:
- '*'
# Search coordinator thread pool sizes
search-coord-core-pool-size: 20
search-coord-max-pool-size: 100
search-coord-queue-capacity: 200
# comma-separated package names, will be @ComponentScan'ed by Spring to allow for creating custom Spring beans
#custom-bean-packages:
# comma-separated list of fully qualified interceptor classes.
# classes listed here will be fetched from the Spring context when combined with 'custom-bean-packages',
# or will be instantiated via reflection using an no-arg contructor; then registered with the server
#custom-interceptor-classes:
# comma-separated list of fully qualified provider classes.
# classes listed here will be fetched from the Spring context when combined with 'custom-bean-packages',
# or will be instantiated via reflection using an no-arg contructor; then registered with the server
#custom-provider-classes:
# Threadpool size for BATCH'ed GETs in a bundle.
# bundle_batch_pool_size: 10
# bundle_batch_pool_max_size: 50
# logger:
# error_format: 'ERROR - ${requestVerb} ${requestUrl}'
# format: >-
# Path[${servletPath}] Source[${requestHeader.x-forwarded-for}]
# Operation[${operationType} ${operationName} ${idOrResourceName}]
# UA[${requestHeader.user-agent}] Params[${requestParameters}]
# ResponseEncoding[${responseEncodingNoDefault}]
# log_exceptions: true
# name: fhirtest.access
# max_binary_size: 104857600
# max_page_size: 200
# retain_cached_searches_mins: 60
# reuse_cached_search_results_millis: 60000
tester:
home:
name: Local Tester
server_address: 'http://localhost:8080/fhir'
refuse_to_fetch_third_party_urls: false
fhir_version: R4
global:
name: Global Tester
server_address: "http://hapi.fhir.org/baseR4"
refuse_to_fetch_third_party_urls: false
fhir_version: R4
# validation:
# requests_enabled: true
# responses_enabled: true
# binary_storage_enabled: true
inline_resource_storage_below_size: 4000
# bulk_export_enabled: true
# subscription:
# resthook_enabled: true
# websocket_enabled: false
# email:
# from: so...@test.com
# host: google.com
# port:
# username:
# password:
# auth:
# startTlsEnable:
# startTlsRequired:
# quitWait:
# lastn_enabled: true
# store_resource_in_lucene_index_enabled: true
### This is configuration for normalized quantity search level default is 0
### 0: NORMALIZED_QUANTITY_SEARCH_NOT_SUPPORTED - default
### 1: NORMALIZED_QUANTITY_STORAGE_SUPPORTED
### 2: NORMALIZED_QUANTITY_SEARCH_SUPPORTED
# normalized_quantity_search_level: 2
#elasticsearch:
# debug:
# pretty_print_json_log: false
# refresh_after_write: false
# enabled: false
# password: SomePassword
# required_index_status: YELLOW
# rest_url: 'localhost:9200'
# protocol: 'http'
# schema_management_strategy: CREATE
# username: SomeUsername
But when I start with docker compose up, the tables were created in PostgreSQL, but I'm getting these errors in the log then http://localhost:8090/ works, but REST API does not:
2024-06-12 15:50:57 hapi-fhir |
2024-06-12 15:50:57 hapi-fhir | . ____ _ __ _ _
2024-06-12 15:50:57 hapi-fhir | /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
2024-06-12 15:50:57 hapi-fhir | ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
2024-06-12 15:50:57 hapi-fhir | \\/ ___)| |_)| | | | | || (_| | ) ) ) )
2024-06-12 15:50:57 hapi-fhir | ' |____| .__|_| |_|_| |_\__, | / / / /
2024-06-12 15:50:57 hapi-fhir | =========|_|==============|___/=/_/_/_/
2024-06-12 15:50:57 hapi-fhir | 2024-06-12 18:50:57.312 [background-preinit] INFO o.h.validator.internal.util.Version [Version.java:21] HV000001: Hibernate Validator 8.0.0.Final
2024-06-12 15:50:57 hapi-fhir | :: Spring Boot :: (v3.2.0)
2024-06-12 15:50:57 hapi-fhir |
2024-06-12 15:50:57 hapi-fhir | 2024-06-12 18:50:57.370 [main] INFO ca.uhn.fhir.jpa.starter.Application [StartupInfoLogger.java:50] Starting Application using Java 17.0.11 with PID 1 (/app/main.war started by nonroot in /app)
2024-06-12 15:50:57 hapi-fhir | 2024-06-12 18:50:57.371 [main] INFO ca.uhn.fhir.jpa.starter.Application [SpringApplication.java:653] No active profile set, falling back to 1 default profile: "default"
2024-06-12 15:50:58 hapi-fhir | 2024-06-12 18:50:58.036 [main] INFO o.s.d.r.c.RepositoryConfigurationDelegate [RepositoryConfigurationDelegate.java:139] Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-06-12 15:50:58 hapi-fhir | 2024-06-12 18:50:58.160 [main] INFO o.s.d.r.c.RepositoryConfigurationDelegate [RepositoryConfigurationDelegate.java:208] Finished Spring Data repository scanning in 119 ms. Found 52 JPA repository interfaces.
2024-06-12 15:50:58 hapi-fhir | 2024-06-12 18:50:58.966 [main] WARN o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker [PostProcessorRegistrationDelegate.java:429] Bean 'ca.uhn.fhir.jpa.config.BeanPostProcessorConfig' of type [ca.uhn.fhir.jpa.config.BeanPostProcessorConfig$$SpringCGLIB$$0] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying). The currently created BeanPostProcessor [persistenceExceptionTranslationPostProcessor] is declared through a non-static factory method on that class; consider declaring it as static instead.
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.212 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer [TomcatWebServer.java:108] Tomcat initialized with port 8080 (http)
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.219 [main] INFO o.a.coyote.http11.Http11NioProtocol [DirectJDKLog.java:173] Initializing ProtocolHandler ["http-nio-8080"]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.220 [main] INFO o.a.catalina.core.StandardService [DirectJDKLog.java:173] Starting service [Tomcat]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.220 [main] INFO o.a.catalina.core.StandardEngine [DirectJDKLog.java:173] Starting Servlet engine: [Apache Tomcat/10.1.16]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.283 [main] INFO o.a.c.c.C.[Tomcat].[localhost].[/] [DirectJDKLog.java:173] Initializing Spring embedded WebApplicationContext
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.284 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext [ServletWebServerApplicationContext.java:296] Root WebApplicationContext: initialization completed in 1877 ms
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.331 [main] INFO ca.uhn.fhir.util.VersionUtil [VersionUtil.java:84] HAPI FHIR version 7.2.0 - Rev 018a38bd45
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.333 [main] INFO ca.uhn.fhir.context.FhirContext [FhirContext.java:226] Creating new FHIR context for FHIR version [R4]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.346 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:39] Server configured to allow contains searches
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:41] Server configured to deny multiple deletes
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:43] Server configured to deny external references
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:45] Server configured to enable DAO scheduling
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:47] Server configured to disable delete expunges
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:49] Server configured to enable expunges
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:51] Server configured to allow overriding default search params
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:54] Server configured to disable auto-creating placeholder references
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:57] Server configured to auto-version references at paths []
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.370 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:122] Server configured to have a maximum fetch size of 'unlimited'
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.370 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:127] Server configured to cache search results for 60000 milliseconds
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.370 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:178] Server configured to use 'ALPHANUMERIC' Client ID Strategy
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.432 [main] INFO o.h.jpa.internal.util.LogHelper [LogHelper.java:31] HHH000204: Processing PersistenceUnitInfo [name: HAPI_PU]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.473 [main] INFO org.hibernate.Version [Version.java:44] HHH000412: Hibernate ORM core version 6.4.1.Final
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.607 [main] INFO c.u.f.j.l.FilteringSqlLoggerImplContributor [FilteringSqlLoggerImplContributor.java:33] Adding service: SqlStatementFilteringLogger
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.620 [main] INFO o.h.c.i.RegionFactoryInitiator [RegionFactoryInitiator.java:50] HHH000026: Second-level cache disabled
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.663 [main] INFO o.h.e.b.internal.EnversServiceImpl [EnversServiceImpl.java:76] Envers integration enabled? : true
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.836 [main] INFO o.s.o.j.p.SpringPersistenceUnitInfo [SpringPersistenceUnitInfo.java:87] No LoadTimeWeaver setup: ignoring JPA class transformer
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.852 [main] INFO com.zaxxer.hikari.HikariDataSource [HikariDataSource.java:110] HikariPool-1 - Starting...
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.991 [main] INFO com.zaxxer.hikari.pool.HikariPool [HikariPool.java:565] HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@65bb6275
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.994 [main] INFO com.zaxxer.hikari.HikariDataSource [HikariDataSource.java:123] HikariPool-1 - Start completed.
2024-06-12 15:51:03 hapi-fhir | 2024-06-12 18:51:03.010 [main] WARN o.h.e.j.e.i.JdbcEnvironmentInitiator [JdbcEnvironmentInitiator.java:345] HHH000342: Could not obtain connection to query metadata
2024-06-12 15:51:03 hapi-fhir | org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named strategy class [ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect]
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:244)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:189)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.constructDialect(DialectFactoryImpl.java:123)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:88)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$1.execute(JdbcEnvironmentInitiator.java:328)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$1.execute(JdbcEnvironmentInitiator.java:277)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:58)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jdbc.AbstractReturningWork.accept(AbstractReturningWork.java:34)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:70)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentUsingJdbcMetadata(JdbcEnvironmentInitiator.java:276)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:107)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:129)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:238)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:215)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.model.relational.Database.<init>(Database.java:45)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:223)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:191)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:170)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1432)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1503)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:142)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:390)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:366)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1833)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:225)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1323)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1284)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1252)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findDefaultEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:593)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:557)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.resolveEntityManager(PersistenceAnnotationBeanPostProcessor.java:724)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.getResourceToInject(PersistenceAnnotationBeanPostProcessor.java:697)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:270)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:145)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessProperties(PersistenceAnnotationBeanPostProcessor.java:385)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1419)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1335)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1165)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1335)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1165)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:205)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:210)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:201)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addServletContextInitializerBeans(ServletContextInitializerBeans.java:96)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.<init>(ServletContextInitializerBeans.java:85)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:266)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:240)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatStarter.onStartup(TomcatStarter.java:52)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4850)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2024-06-12 15:51:03 hapi-fhir | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:845)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2024-06-12 15:51:03 hapi-fhir | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:240)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardService.startInternal(StandardService.java:433)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:917)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.startup.Tomcat.start(Tomcat.java:488)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:123)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:104)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:501)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:218)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:188)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:162)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:618)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:753)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:455)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.run(SpringApplication.java:323)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1342)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1331)
2024-06-12 15:51:03 hapi-fhir | at ca.uhn.fhir.jpa.starter.Application.main(Application.java:46)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.reflect.Method.invoke(Method.java:568)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.Launcher.launch(Launcher.java:95)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:466)
2024-06-12 15:51:03 hapi-fhir | Caused by: org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named dialect class [ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect]
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.lambda$constructDialect$0(DialectFactoryImpl.java:143)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:240)
2024-06-12 15:51:03 hapi-fhir | ... 131 common frames omitted
2024-06-12 15:51:03 hapi-fhir | Caused by: java.lang.reflect.InvocationTargetException: null
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.lambda$constructDialect$0(DialectFactoryImpl.java:131)
2024-06-12 15:51:03 hapi-fhir | ... 132 common frames omitted
2024-06-12 15:51:03 hapi-fhir | Caused by: java.lang.NumberFormatException: For input string: "(Debian"
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:67)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.Integer.parseInt(Integer.java:654)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.Integer.parseInt(Integer.java:786)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.dialect.H2Dialect.parseBuildId(H2Dialect.java:160)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.dialect.H2Dialect.parseVersion(H2Dialect.java:150)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.dialect.H2Dialect.<init>(H2Dialect.java:124)
2024-06-12 15:51:03 hapi-fhir | at ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect.<init>(HapiFhirH2Dialect.java:36)
2024-06-12 15:51:03 hapi-fhir | ... 138 common frames omitted
2024-06-12 15:51:03 hapi-fhir | 2024-06-12 18:51:03.384 [main] INFO o.h.s.m.o.b.i.HibernateSearchPreIntegrationService [HibernateSearchPreIntegrationService.java:101] HSEARCH000034: Hibernate Search version 7.0.0.Final
2024-06-12 15:51:03 hapi-fhir | 2024-06-12 18:51:03.470 [main] INFO o.h.e.c.i.m.AuditMetadataGenerator [AuditMetadataGenerator.java:322] Adding properties for entity: ca.uhn.fhir.jpa.entity.MdmLink
2024-06-12 15:51:04 hapi-fhir | 2024-06-12 18:51:04.258 [main] INFO o.h.e.t.j.p.i.JtaPlatformInitiator [JtaPlatformInitiator.java:58] HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2024-06-12 15:51:04 hapi-fhir | 2024-06-12 18:51:04.310 [main] WARN o.h.t.s.i.ExceptionHandlerLoggedImpl [ExceptionHandlerLoggedImpl.java:27] GenerationTarget encountered exception accepting command : Error executing DDL "create table bt2_job_instance (id varchar(100) not null, job_cancelled boolean not null, cmb_recs_processed integer, cmb_recs_per_sec float(53), create_time timestamp(6) not null, cur_gated_step_id varchar(100), definition_id varchar(100) not null, definition_ver integer not null, end_time timestamp(6), error_count integer, error_msg varchar(500), est_remaining varchar(100), fast_tracking boolean, params_json varchar(2000), params_json_lob clob, params_json_vc clob, progress_pct float(53), report clob, report_vc clob, start_time timestamp(6), stat varchar(20) not null, tot_elapsed_millis integer, client_id varchar(200), user_name varchar(200), update_time timestamp(6), warning_msg varchar(4000), work_chunks_purged boolean not null, primary key (id))" via JDBC [ERROR: type "clob" does not exist
2024-06-12 15:51:04 hapi-fhir | Position: 445]
2024-06-12 15:51:04 hapi-fhir | org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table bt2_job_instance (id varchar(100) not null, job_cancelled boolean not null, cmb_recs_processed integer, cmb_recs_per_sec float(53), create_time timestamp(6) not null, cur_gated_step_id varchar(100), definition_id varchar(100) not null, definition_ver integer not null, end_time timestamp(6), error_count integer, error_msg varchar(500), est_remaining varchar(100), fast_tracking boolean, params_json varchar(2000), params_json_lob clob, params_json_vc clob, progress_pct float(53), report clob, report_vc clob, start_time timestamp(6), stat varchar(20) not null, tot_elapsed_millis integer, client_id varchar(200), user_name varchar(200), update_time timestamp(6), warning_msg varchar(4000), work_chunks_purged boolean not null, primary key (id))" via JDBC [ERROR: type "clob" does not exist
2024-06-12 15:51:04 hapi-fhir | Position: 445]
.... and more....
Please, can anyone help me to understand what I am doing wrong?
Thanks!
#Uncomment the "servlet" and "context-path" lines below to make the fhir endpoint available at /example/path/fhir instead of the default value of /fhir
server:
# servlet:
# context-path: /example/path
port: 8080
#Adds the option to go to eg. http://localhost:8080/actuator/health for seeing the running configuration
#see https://docs.spring.io/spring-boot/docs/current/reference/html/actuator.html#actuator.endpoints
management:
endpoints:
web:
exposure:
include: "health,prometheus"
spring:
main:
allow-circular-references: true
#allow-bean-definition-overriding: true
flyway:
enabled: false
baselineOnMigrate: true
fail-on-missing-locations: false
datasource:
url: jdbc:postgresql://172.26.0.2:5432/hapi
username: postgres
password: password
driver-class-name: org.postgresql.Driver
# database connection pool size
hikari:
maximum-pool-size: 10
jpa:
properties:
hibernate.format_sql: false
hibernate.show_sql: false
#Hibernate dialect is automatically detected except Postgres and H2.
#If using H2, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect
#If using postgres, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirPostgres94Dialect
hibernate.dialect: ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect
# hibernate.hbm2ddl.auto: update
# hibernate.jdbc.batch_size: 20
# hibernate.cache.use_query_cache: false
# hibernate.cache.use_second_level_cache: false
# hibernate.cache.use_structured_entries: false
# hibernate.cache.use_minimal_puts: false
### These settings will enable fulltext search with lucene or elastic
hibernate.search.enabled: true
### lucene parameters
# hibernate.search.backend.type: lucene
# hibernate.search.backend.analysis.configurer: ca.uhn.fhir.jpa.search.HapiHSearchAnalysisConfigurers$HapiLuceneAnalysisConfigurer
# hibernate.search.backend.directory.type: local-filesystem
# hibernate.search.backend.directory.root: target/lucenefiles
# hibernate.search.backend.lucene_version: lucene_current
### elastic parameters ===> see also elasticsearch section below <===
# hibernate.search.backend.type: elasticsearch
# hibernate.search.backend.analysis.configurer: ca.uhn.fhir.jpa.search.HapiHSearchAnalysisConfigurers$HapiElasticAnalysisConfigurer
hapi:
fhir:
### This flag when enabled to true, will avail evaluate measure operations from CR Module.
### Flag is false by default, can be passed as command line argument to override.
cr:
enabled: false
cdshooks:
enabled: true
clientIdHeaderName: client_id
### This enables the swagger-ui at /fhir/swagger-ui/index.html as well as the /fhir/api-docs (see https://hapifhir.io/hapi-fhir/docs/server_plain/openapi.html)
openapi_enabled: true
### This is the FHIR version. Choose between, DSTU2, DSTU3, R4 or R5
fhir_version: R4
### Flag is false by default. This flag enables runtime installation of IG's.
ig_runtime_upload_enabled: false
### This flag when enabled to true, will avail evaluate measure operations from CR Module.
### enable to use the ApacheProxyAddressStrategy which uses X-Forwarded-* headers
### to determine the FHIR server address
# use_apache_address_strategy: false
### forces the use of the https:// protocol for the returned server address.
### alternatively, it may be set using the X-Forwarded-Proto header.
# use_apache_address_strategy_https: false
### enables the server to overwrite defaults on HTML, css, etc. under the url pattern of eg. /content/custom **
### Folder with custom content MUST be named custom. If omitted then default content applies
#custom_content_path: ./custom
### enables the server host custom content. If e.g. the value ./configs/app is supplied then the content
### will be served under /web/app
#app_content_path: ./configs/app
### enable to set the Server URL
# server_address: http://hapi.fhir.org/baseR4
# defer_indexing_for_codesystems_of_size: 101
# install_transitive_ig_dependencies: true
#implementationguides:
### example from registry (packages.fhir.org)
# swiss:
# name: swiss.mednet.fhir
# version: 0.8.0
# reloadExisting: false
# installMode: STORE_AND_INSTALL
# example not from registry
# ips_1_0_0:
# packageUrl: https://build.fhir.org/ig/HL7/fhir-ips/package.tgz
# name: hl7.fhir.uv.ips
# version: 1.0.0
# supported_resource_types:
# - Patient
# - Observation
##################################################
# Allowed Bundle Types for persistence (defaults are: COLLECTION,DOCUMENT,MESSAGE)
##################################################
# allowed_bundle_types: COLLECTION,DOCUMENT,MESSAGE,TRANSACTION,TRANSACTIONRESPONSE,BATCH,BATCHRESPONSE,HISTORY,SEARCHSET
# allow_cascading_deletes: true
# allow_contains_searches: true
# allow_external_references: true
# allow_multiple_delete: true
# allow_override_default_search_params: true
# auto_create_placeholder_reference_targets: false
### tells the server to automatically append the current version of the target resource to references at these paths
# auto_version_reference_at_paths: Device.patient, Device.location, Device.parent, DeviceMetric.parent, DeviceMetric.source, Observation.device, Observation.subject
# ips_enabled: false
# default_encoding: JSON
# default_pretty_print: true
# default_page_size: 20
# delete_expunge_enabled: true
# enable_repository_validating_interceptor: true
# enable_index_missing_fields: false
# enable_index_of_type: true
# enable_index_contained_resource: false
# resource_dbhistory_enabled: false
### !!Extended Lucene/Elasticsearch Indexing is still a experimental feature, expect some features (e.g. _total=accurate) to not work as expected!!
### more information here: https://hapifhir.io/hapi-fhir/docs/server_jpa/elastic.html
advanced_lucene_indexing: false
bulk_export_enabled: false
bulk_import_enabled: false
# language_search_parameter_enabled: true
# enforce_referential_integrity_on_delete: false
# This is an experimental feature, and does not fully support _total and other FHIR features.
# enforce_referential_integrity_on_delete: false
# enforce_referential_integrity_on_write: false
# etag_support_enabled: true
# expunge_enabled: true
# client_id_strategy: ALPHANUMERIC
# server_id_strategy: SEQUENTIAL_NUMERIC
# fhirpath_interceptor_enabled: false
# filter_search_enabled: true
# graphql_enabled: true
narrative_enabled: false
mdm_enabled: false
mdm_rules_json_location: "mdm-rules.json"
# local_base_urls:
# - https://hapi.fhir.org/baseR4
logical_urls:
- http://terminology.hl7.org/*
- https://terminology.hl7.org/*
- http://snomed.info/*
- https://snomed.info/*
- http://unitsofmeasure.org/*
- https://unitsofmeasure.org/*
- http://loinc.org/*
- https://loinc.org/*
# partitioning:
# allow_references_across_partitions: false
# partitioning_include_in_search_hashes: false
cors:
allow_Credentials: true
# These are allowed_origin patterns, see: https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/web/cors/CorsConfiguration.html#setAllowedOriginPatterns-java.util.List-
allowed_origin:
- '*'
# Search coordinator thread pool sizes
search-coord-core-pool-size: 20
search-coord-max-pool-size: 100
search-coord-queue-capacity: 200
# comma-separated package names, will be @ComponentScan'ed by Spring to allow for creating custom Spring beans
#custom-bean-packages:
# comma-separated list of fully qualified interceptor classes.
# classes listed here will be fetched from the Spring context when combined with 'custom-bean-packages',
# or will be instantiated via reflection using an no-arg contructor; then registered with the server
#custom-interceptor-classes:
# comma-separated list of fully qualified provider classes.
# classes listed here will be fetched from the Spring context when combined with 'custom-bean-packages',
# or will be instantiated via reflection using an no-arg contructor; then registered with the server
#custom-provider-classes:
# Threadpool size for BATCH'ed GETs in a bundle.
# bundle_batch_pool_size: 10
# bundle_batch_pool_max_size: 50
# logger:
# error_format: 'ERROR - ${requestVerb} ${requestUrl}'
# format: >-
# Path[${servletPath}] Source[${requestHeader.x-forwarded-for}]
# Operation[${operationType} ${operationName} ${idOrResourceName}]
# UA[${requestHeader.user-agent}] Params[${requestParameters}]
# ResponseEncoding[${responseEncodingNoDefault}]
# log_exceptions: true
# name: fhirtest.access
# max_binary_size: 104857600
# max_page_size: 200
# retain_cached_searches_mins: 60
# reuse_cached_search_results_millis: 60000
tester:
home:
name: Local Tester
server_address: 'http://localhost:8080/fhir'
refuse_to_fetch_third_party_urls: false
fhir_version: R4
global:
name: Global Tester
server_address: "http://hapi.fhir.org/baseR4"
refuse_to_fetch_third_party_urls: false
fhir_version: R4
# validation:
# requests_enabled: true
# responses_enabled: true
# binary_storage_enabled: true
inline_resource_storage_below_size: 4000
# bulk_export_enabled: true
# subscription:
# resthook_enabled: true
# websocket_enabled: false
# email:
# from: so...@test.com
# host: google.com
# port:
# username:
# password:
# auth:
# startTlsEnable:
# startTlsRequired:
# quitWait:
# lastn_enabled: true
# store_resource_in_lucene_index_enabled: true
### This is configuration for normalized quantity search level default is 0
### 0: NORMALIZED_QUANTITY_SEARCH_NOT_SUPPORTED - default
### 1: NORMALIZED_QUANTITY_STORAGE_SUPPORTED
### 2: NORMALIZED_QUANTITY_SEARCH_SUPPORTED
# normalized_quantity_search_level: 2
#elasticsearch:
# debug:
# pretty_print_json_log: false
# refresh_after_write: false
# enabled: false
# password: SomePassword
# required_index_status: YELLOW
# rest_url: 'localhost:9200'
# protocol: 'http'
# schema_management_strategy: CREATE
# username: SomeUsername
But when I start with docker compose up, the tables were created in PostgreSQL, but I'm getting these errors in the log then http://localhost:8090/ works, but REST API does not:
2024-06-12 15:50:57 hapi-fhir |
2024-06-12 15:50:57 hapi-fhir | . ____ _ __ _ _
2024-06-12 15:50:57 hapi-fhir | /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
2024-06-12 15:50:57 hapi-fhir | ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
2024-06-12 15:50:57 hapi-fhir | \\/ ___)| |_)| | | | | || (_| | ) ) ) )
2024-06-12 15:50:57 hapi-fhir | ' |____| .__|_| |_|_| |_\__, | / / / /
2024-06-12 15:50:57 hapi-fhir | =========|_|==============|___/=/_/_/_/
2024-06-12 15:50:57 hapi-fhir | 2024-06-12 18:50:57.312 [background-preinit] INFO o.h.validator.internal.util.Version [Version.java:21] HV000001: Hibernate Validator 8.0.0.Final
2024-06-12 15:50:57 hapi-fhir | :: Spring Boot :: (v3.2.0)
2024-06-12 15:50:57 hapi-fhir |
2024-06-12 15:50:57 hapi-fhir | 2024-06-12 18:50:57.370 [main] INFO ca.uhn.fhir.jpa.starter.Application [StartupInfoLogger.java:50] Starting Application using Java 17.0.11 with PID 1 (/app/main.war started by nonroot in /app)
2024-06-12 15:50:57 hapi-fhir | 2024-06-12 18:50:57.371 [main] INFO ca.uhn.fhir.jpa.starter.Application [SpringApplication.java:653] No active profile set, falling back to 1 default profile: "default"
2024-06-12 15:50:58 hapi-fhir | 2024-06-12 18:50:58.036 [main] INFO o.s.d.r.c.RepositoryConfigurationDelegate [RepositoryConfigurationDelegate.java:139] Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-06-12 15:50:58 hapi-fhir | 2024-06-12 18:50:58.160 [main] INFO o.s.d.r.c.RepositoryConfigurationDelegate [RepositoryConfigurationDelegate.java:208] Finished Spring Data repository scanning in 119 ms. Found 52 JPA repository interfaces.
2024-06-12 15:50:58 hapi-fhir | 2024-06-12 18:50:58.966 [main] WARN o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker [PostProcessorRegistrationDelegate.java:429] Bean 'ca.uhn.fhir.jpa.config.BeanPostProcessorConfig' of type [ca.uhn.fhir.jpa.config.BeanPostProcessorConfig$$SpringCGLIB$$0] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying). The currently created BeanPostProcessor [persistenceExceptionTranslationPostProcessor] is declared through a non-static factory method on that class; consider declaring it as static instead.
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.212 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer [TomcatWebServer.java:108] Tomcat initialized with port 8080 (http)
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.219 [main] INFO o.a.coyote.http11.Http11NioProtocol [DirectJDKLog.java:173] Initializing ProtocolHandler ["http-nio-8080"]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.220 [main] INFO o.a.catalina.core.StandardService [DirectJDKLog.java:173] Starting service [Tomcat]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.220 [main] INFO o.a.catalina.core.StandardEngine [DirectJDKLog.java:173] Starting Servlet engine: [Apache Tomcat/10.1.16]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.283 [main] INFO o.a.c.c.C.[Tomcat].[localhost].[/] [DirectJDKLog.java:173] Initializing Spring embedded WebApplicationContext
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.284 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext [ServletWebServerApplicationContext.java:296] Root WebApplicationContext: initialization completed in 1877 ms
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.331 [main] INFO ca.uhn.fhir.util.VersionUtil [VersionUtil.java:84] HAPI FHIR version 7.2.0 - Rev 018a38bd45
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.333 [main] INFO ca.uhn.fhir.context.FhirContext [FhirContext.java:226] Creating new FHIR context for FHIR version [R4]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.346 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:39] Server configured to allow contains searches
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:41] Server configured to deny multiple deletes
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:43] Server configured to deny external references
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:45] Server configured to enable DAO scheduling
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:47] Server configured to disable delete expunges
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:49] Server configured to enable expunges
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:51] Server configured to allow overriding default search params
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:54] Server configured to disable auto-creating placeholder references
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.347 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:57] Server configured to auto-version references at paths []
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.370 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:122] Server configured to have a maximum fetch size of 'unlimited'
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.370 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:127] Server configured to cache search results for 60000 milliseconds
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.370 [main] INFO c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:178] Server configured to use 'ALPHANUMERIC' Client ID Strategy
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.432 [main] INFO o.h.jpa.internal.util.LogHelper [LogHelper.java:31] HHH000204: Processing PersistenceUnitInfo [name: HAPI_PU]
2024-06-12 15:50:59 hapi-fhir | 2024-06-12 18:50:59.473 [main] INFO org.hibernate.Version [Version.java:44] HHH000412: Hibernate ORM core version 6.4.1.Final
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.607 [main] INFO c.u.f.j.l.FilteringSqlLoggerImplContributor [FilteringSqlLoggerImplContributor.java:33] Adding service: SqlStatementFilteringLogger
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.620 [main] INFO o.h.c.i.RegionFactoryInitiator [RegionFactoryInitiator.java:50] HHH000026: Second-level cache disabled
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.663 [main] INFO o.h.e.b.internal.EnversServiceImpl [EnversServiceImpl.java:76] Envers integration enabled? : true
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.836 [main] INFO o.s.o.j.p.SpringPersistenceUnitInfo [SpringPersistenceUnitInfo.java:87] No LoadTimeWeaver setup: ignoring JPA class transformer
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.852 [main] INFO com.zaxxer.hikari.HikariDataSource [HikariDataSource.java:110] HikariPool-1 - Starting...
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.991 [main] INFO com.zaxxer.hikari.pool.HikariPool [HikariPool.java:565] HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@65bb6275
2024-06-12 15:51:02 hapi-fhir | 2024-06-12 18:51:02.994 [main] INFO com.zaxxer.hikari.HikariDataSource [HikariDataSource.java:123] HikariPool-1 - Start completed.
2024-06-12 15:51:03 hapi-fhir | 2024-06-12 18:51:03.010 [main] WARN o.h.e.j.e.i.JdbcEnvironmentInitiator [JdbcEnvironmentInitiator.java:345] HHH000342: Could not obtain connection to query metadata
2024-06-12 15:51:03 hapi-fhir | org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named strategy class [ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect]
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:244)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:189)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.constructDialect(DialectFactoryImpl.java:123)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:88)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$1.execute(JdbcEnvironmentInitiator.java:328)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$1.execute(JdbcEnvironmentInitiator.java:277)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:58)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jdbc.AbstractReturningWork.accept(AbstractReturningWork.java:34)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:70)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentUsingJdbcMetadata(JdbcEnvironmentInitiator.java:276)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:107)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:129)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:238)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:215)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.model.relational.Database.<init>(Database.java:45)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:223)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:191)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:170)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1432)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1503)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:142)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:390)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:366)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1833)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:225)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1323)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1284)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1252)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findDefaultEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:593)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:557)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.resolveEntityManager(PersistenceAnnotationBeanPostProcessor.java:724)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.getResourceToInject(PersistenceAnnotationBeanPostProcessor.java:697)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:270)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:145)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessProperties(PersistenceAnnotationBeanPostProcessor.java:385)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1419)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1335)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1165)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1335)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1165)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:205)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:210)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:201)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addServletContextInitializerBeans(ServletContextInitializerBeans.java:96)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.<init>(ServletContextInitializerBeans.java:85)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:266)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:240)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatStarter.onStartup(TomcatStarter.java:52)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4850)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2024-06-12 15:51:03 hapi-fhir | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:845)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2024-06-12 15:51:03 hapi-fhir | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:240)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardService.startInternal(StandardService.java:433)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:917)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir | at org.apache.catalina.startup.Tomcat.start(Tomcat.java:488)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:123)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:104)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:501)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:218)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:188)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:162)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:618)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:753)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:455)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.run(SpringApplication.java:323)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1342)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1331)
2024-06-12 15:51:03 hapi-fhir | at ca.uhn.fhir.jpa.starter.Application.main(Application.java:46)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.reflect.Method.invoke(Method.java:568)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.Launcher.launch(Launcher.java:95)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
2024-06-12 15:51:03 hapi-fhir | at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:466)
2024-06-12 15:51:03 hapi-fhir | Caused by: org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named dialect class [ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect]
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.lambda$constructDialect$0(DialectFactoryImpl.java:143)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:240)
2024-06-12 15:51:03 hapi-fhir | ... 131 common frames omitted
2024-06-12 15:51:03 hapi-fhir | Caused by: java.lang.reflect.InvocationTargetException: null
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
2024-06-12 15:51:03 hapi-fhir | at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.lambda$constructDialect$0(DialectFactoryImpl.java:131)
2024-06-12 15:51:03 hapi-fhir | ... 132 common frames omitted
2024-06-12 15:51:03 hapi-fhir | Caused by: java.lang.NumberFormatException: For input string: "(Debian"
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:67)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.Integer.parseInt(Integer.java:654)
2024-06-12 15:51:03 hapi-fhir | at java.base/java.lang.Integer.parseInt(Integer.java:786)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.dialect.H2Dialect.parseBuildId(H2Dialect.java:160)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.dialect.H2Dialect.parseVersion(H2Dialect.java:150)
2024-06-12 15:51:03 hapi-fhir | at org.hibernate.dialect.H2Dialect.<init>(H2Dialect.java:124)
2024-06-12 15:51:03 hapi-fhir | at ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect.<init>(HapiFhirH2Dialect.java:36)
2024-06-12 15:51:03 hapi-fhir | ... 138 common frames omitted
2024-06-12 15:51:03 hapi-fhir | 2024-06-12 18:51:03.384 [main] INFO o.h.s.m.o.b.i.HibernateSearchPreIntegrationService [HibernateSearchPreIntegrationService.java:101] HSEARCH000034: Hibernate Search version 7.0.0.Final
2024-06-12 15:51:03 hapi-fhir | 2024-06-12 18:51:03.470 [main] INFO o.h.e.c.i.m.AuditMetadataGenerator [AuditMetadataGenerator.java:322] Adding properties for entity: ca.uhn.fhir.jpa.entity.MdmLink
2024-06-12 15:51:04 hapi-fhir | 2024-06-12 18:51:04.258 [main] INFO o.h.e.t.j.p.i.JtaPlatformInitiator [JtaPlatformInitiator.java:58] HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2024-06-12 15:51:04 hapi-fhir | 2024-06-12 18:51:04.310 [main] WARN o.h.t.s.i.ExceptionHandlerLoggedImpl [ExceptionHandlerLoggedImpl.java:27] GenerationTarget encountered exception accepting command : Error executing DDL "create table bt2_job_instance (id varchar(100) not null, job_cancelled boolean not null, cmb_recs_processed integer, cmb_recs_per_sec float(53), create_time timestamp(6) not null, cur_gated_step_id varchar(100), definition_id varchar(100) not null, definition_ver integer not null, end_time timestamp(6), error_count integer, error_msg varchar(500), est_remaining varchar(100), fast_tracking boolean, params_json varchar(2000), params_json_lob clob, params_json_vc clob, progress_pct float(53), report clob, report_vc clob, start_time timestamp(6), stat varchar(20) not null, tot_elapsed_millis integer, client_id varchar(200), user_name varchar(200), update_time timestamp(6), warning_msg varchar(4000), work_chunks_purged boolean not null, primary key (id))" via JDBC [ERROR: type "clob" does not exist
2024-06-12 15:51:04 hapi-fhir | Position: 445]
2024-06-12 15:51:04 hapi-fhir | org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table bt2_job_instance (id varchar(100) not null, job_cancelled boolean not null, cmb_recs_processed integer, cmb_recs_per_sec float(53), create_time timestamp(6) not null, cur_gated_step_id varchar(100), definition_id varchar(100) not null, definition_ver integer not null, end_time timestamp(6), error_count integer, error_msg varchar(500), est_remaining varchar(100), fast_tracking boolean, params_json varchar(2000), params_json_lob clob, params_json_vc clob, progress_pct float(53), report clob, report_vc clob, start_time timestamp(6), stat varchar(20) not null, tot_elapsed_millis integer, client_id varchar(200), user_name varchar(200), update_time timestamp(6), warning_msg varchar(4000), work_chunks_purged boolean not null, primary key (id))" via JDBC [ERROR: type "clob" does not exist
2024-06-12 15:51:04 hapi-fhir | Position: 445]
.... and more....
Please, can anyone help me to understand what I am doing wrong?
Thanks!
James Agnew
Jun 16, 2024, 10:39:54 AM6/16/24
to Martin Neu, HAPI FHIR
The stack trace in that error:
> at org.hibernate.dialect.H2Dialect.parseBuildId(H2Dialect.java:160)
indicates that hibernate is configured to use the H2 database dialect. You need to set that to Postgres.
Cheers,
James
--
You received this message because you are subscribed to the Google Groups "HAPI FHIR" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hapi-fhir+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/hapi-fhir/c920b8cd-73b9-4f5f-8c03-c7033d47e27en%40googlegroups.com.
Marcelo Romero-Cors
Jan 16, 2025, 9:55:28 AM1/16/25
to HAPI FHIR
I'm currently using Postgres, you just have to change some lines in the application.yaml:
show_sql: false
#Hibernate dialect is automatically detected except Postgres and H2.
#If using H2, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect
Good luck!
jpa:
database: postgresql
database-platform: org.hibernate.dialect.PostgreSQL94Dialect
properties:
hibernate:
format_sql: true
database: postgresql
database-platform: org.hibernate.dialect.PostgreSQL94Dialect
properties:
hibernate:
format_sql: true
show_sql: false
#Hibernate dialect is automatically detected except Postgres and H2.
#If using H2, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect
# hibernate.dialect: ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect
#If using postgres, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirPostgresDialect
dialect: ca.uhn.fhir.jpa.model.dialect.HapiFhirPostgresDialect
hbm2ddl:
auto: update
jdbc:
batch_size: 20
#If using postgres, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirPostgresDialect
dialect: ca.uhn.fhir.jpa.model.dialect.HapiFhirPostgresDialect
hbm2ddl:
auto: update
jdbc:
batch_size: 20
Good luck!
Marcelo
Rob Ferguson
Jan 16, 2025, 2:37:29 PM1/16/25
to HAPI FHIR
A Dockerised example that uses Postgres:
- https://github.com/Robinyo/hapi-fhir-jpaserver-starter
And a more complex Dockerised example that uses Postgres:
= https://github.com/Robinyo/hapi-fhir-au/
- https://github.com/Robinyo/hapi-fhir-jpaserver-starter
And a more complex Dockerised example that uses Postgres:
= https://github.com/Robinyo/hapi-fhir-au/
Reply all
Reply to author
Forward
0 new messages