Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Missing terminology entities foreign key partition columns #6690

Open
jmarchionatto opened this issue Feb 7, 2025 · 0 comments · May be fixed by #6688
Open

Missing terminology entities foreign key partition columns #6690

jmarchionatto opened this issue Feb 7, 2025 · 0 comments · May be fixed by #6688
Assignees
@jmarchionatto
Labels
bug

Comments

@jmarchionatto
Copy link
Collaborator

When partition enable database_partition_mode setting is configured, endpoint_hl7v2_in_v2 fails to start with exception:

SqlException: Duplicate column name "PARTITION_ID"
insert into TRM_CONCEPT_MAP_GROUP (CONCEPT_MAP_PID,PARTITION_ID,CONCEPT_MAP_URL,PARTITION_DATE,SOURCE_URL,SOURCE_VS,SOURCE_VERSION,TARGET_URL,TARGET_VS,TARGET_VERSION,PID,PARTITION_ID) values (?,?,?,?,?,?,?,?,?,?,?,?)

To Reproduce
Steps to reproduce the behavior:

Start app with configuration:

module.persistence.config.partitioning.enabled                 =true
module.persistence.config.partitioning.partition_selection_mode=REQUEST_TENANT
module.persistence.config.partitioning.seed.file               =classpath:/config_seeding/fhir-partitions.json
module.persistence.config.partitioning.default_partition_id = 10
module.persistence.config.database_partition_mode.enabled =true

module.fhir_endpoint.config.partitioning.tenant_identification_strategy=URL_BASED

module.endpoint_hl7v2_in_v2.type=ENDPOINT_HL7V2_IN_V2
module.endpoint_hl7v2_in_v2.requires.SECURITY_IN_ANONYMOUS=local_security
module.endpoint_hl7v2_in_v2.requires.SECURITY_IN_UP=local_security
module.endpoint_hl7v2_in_v2.requires.PERSISTENCE_ALL=persistence
module.endpoint_hl7v2_in_v2.config.storage_tenant_name=Partition-A
module.endpoint_hl7v2_in_v2.config.mllp_port=7000
module.endpoint_hl7v2_in_v2.config.port=7000
module.endpoint_hl7v2_in_v2.config.anonymous.access.account_username=ANONYMOUS
  1. See exception

Expected behavior
Application should start without exceptions

Environment:

  • HAPI FHIR Version: v7.6.1
@jmarchionatto jmarchionatto self-assigned this Feb 7, 2025
@jmarchionatto jmarchionatto linked a pull request Feb 7, 2025 that will close this issue
Jm adjust terminology entities for partitioning #6688
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jmarchionatto jmarchionatto

Labels
bug
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Jm adjust terminology entities for partitioning hapifhir/hapi-fhir
1 participant
@jmarchionatto