HAPI FHIR fails to start: Flyway Community Edition does not support PostgreSQL 15

[niccoreyes]

Description

The eref-hapi container fails to start with PostgreSQL 15.18. The root cause is that Flyway Community Edition 10.x does not support PostgreSQL ≥15 (requires Teams/Enterprise license per Redgate licensing).

Error

org.flywaydb.core.api.FlywayException: Unsupported Database: PostgreSQL 15.18

Root Cause

1. SPRING_CONFIG_LOCATION=file:/app/config/ replaces default config locations, so the embedded spring.flyway.enabled: false from src/main/resources/application.yaml is not loaded
2. The runtime config/application.yaml did not disable Flyway, triggering Flyway auto-configuration
3. Flyway CE 10.x only supports PostgreSQL ≤14

Fix Applied

• Added spring.flyway.enabled: false to config/application.yaml
• Fixed typo: allow-circular-references: truedoc → true
• Added explanatory comment documenting the Flyway rationale

References

• Hapi server does not work with PostgreSQL 15 and 16 hapifhir/hapi-fhir-jpaserver-starter#694 — "Hapi server does not work with PostgreSQL 15 and 16"
• hfj_resource does not exist hapifhir/hapi-fhir-jpaserver-starter#804 — "hfj_resource does not exist" (env var dialect issue)
• Flyway Community Edition compatibility

[niccoreyes]

Update: Flyway fix works, next blocker found

With Flyway disabled, the server now progresses past database initialization but hits an IG package installation error:

Error installing IG fhir.ph.core#0.2.0: Resource Observation/observation-lab-panel-example not found

The IG package references example resources (e.g., Observation/observation-lab-panel-example) in the ImplementationGuide.definition.resource entries, but these resources cannot be resolved in a fresh database. This appears to be a pre-existing issue.

Workaround for testing: Add installResourceTypes filtering to exclude example resources, or ensure the package.tgz at https://fhirhub.telehealth.ph/IG/PH-Core/package.tgz contains the referenced examples.

This is tracked as a separate concern from the Flyway fix in this PR.