This matrix shows the impact of upgrading each release on the various Smile CDR databases.
| Release | Cluster Manager | Persistence | Audit Log | Transaction Log | Overall | Comments |
|---|---|---|---|---|---|---|
| 2023.08 | 25 indexes are added to the Persistence Database, however most of them are on small tables. The overall migration time should not exceed a few hours. | |||||
| 2023.11 | LOW | HIGH | NONE | NONE | HIGH | The Persistence database undergoes a huge migration to fix the padding on the FORCED_ID column for all resources in the HFJ_RESOURCE table. This migration is performed in chunks of 100,000 resources. The FORCED_ID script is executed twice during schema migration. This will take a significant amount of time for databases that contain a large number of resources. |
| 2024.02 | LOW | MEDIUM | NONE | LOW | LOW | This release adds a couple of indexes to the HFJ_SPIDX_* tables. For customers that have a large number of rows in HFJ_SPIDX_STRING and HFJ_SPIDX__URI tables, this could take quite a while to complete (e.g. several hours). |
| 2024.05 | HIGH | HIGH | HIGH | HIGH | HIGH | This release involves migrating the large objects to inline storage for PostgreSQL databases. Depending on the number of large objects present in the database, this could take anywhere from a few hours to a few days to complete. |
| 2024.08 | LOW | MEDIUM | NONE | NONE | LOW | This release adds a couple of indexes to the HFJ_SPIDX_URI table. For customers that have a large number of rows in this table, this could take a while to complete (e.g. several hours). |
| 2024.11 | LOW | NONE | LOW | NONE | LOW | This release adds 2 new indexes to the CDR_AUDIT_EVT_TARGET_RES table. |
| 2025.02 | LOW | LOW | LOW | LOW | LOW | This release adds a RESULT column to the FLY_HFJ_MIGRATION table and a PARTITION_ID column to several tables in the FHIR database to support database partitioning mode. This release also drops foreign keys from the HFJ_HISTORY_TAG, HFJ_RES_LINK, HFJ_RES_SEARCH_URL, HFJ_RES_TAG, HFJ_RES_VER_PROV and HFJ_SUBSCRIPTION_STATS tables. |
| 2025.05 | NONE | LOW | NONE | NONE | LOW | The HFJ_SPIDX_IDENTITY table has been added to the persistence database. Additionally, a new USER_DATA_JSON text column has been added to the BT2_JOB_INSTANCE table. |
| 2025.08 | LOW | LOW | NONE | LOW | LOW | A new table named CDR_XACT_LOG_STOR_OUTCOME has been added to the Cluster Manager and Transaction databases. In the Persistence database, a new table HFJ_RESOURCE_TYPE has been introduced, and a new column RES_TYPE_ID has been added to the HFJ_RESOURCE, HFJ_RES_VER, HFJ_RES_TAG, HFJ_HISTORY_TAG and HFJ_RES_LINK tables. |
| 2025.11 | LOW | LOW | NONE | NONE | LOW | Cluster Manager: This release adds 2 new tables to the Cluster Manager database namely: CDR_CUSTOM_ROLE & CDR_CUSTOM_ROLE_PERM. Additionally the data type of the scope column of the table CDR_USER_DETAILS_OA2CLNAPRVSCP is changed to VARCHAR(764). Persistence: This release adds 2 new tables HFJ_RES_IDENTIFIER_PT_UNIQ and HFJ_RES_SYSTEM tables. Additionally the NOT NULL constraint on the IDX_STRING column of the table HFJ_IDX_CMB_TOK_NU is removed. Audit Log Persistence: No changes in this release. Transaction Log Persistence: No changes in this release. |
| 2026.02 | NONE | LOW | NONE | NONE | LOW | Cluster Manager: No changes in this release. Persistence: For SQL Server only, this release changes the collation on the FHIR_ID column of the HFJ_RESOURCE table to SQL_Latin1_General_CP1_CS_AS. The existing indexes on this table, namely IDX_RES_TYPE_FHIR_ID and IDX_RES_FHIR_ID, will be dropped and re-created to support this collation change. Audit Log Persistence: No changes in this release. Transaction Log Persistence: No changes in this release. |
| 2026.05 | NONE | MEDIUM | NONE | NONE | MEDIUM | Cluster Manager: No changes in this release. Persistence: Added a new column called LAST_HEARTBEAT to the BT2_WORK_CHUNK table, for the table HFJ_IDX_CMB_TOK_NU added the column DATE_ORDINAL; dropped the index IDX_IDXCMBTOKNU_STR; added the index IDX_IDXCMBTOKNU_HD on (HASH_COMPLETE, DATE_ORDINAL, RES_ID, PARTITION_ID), and for the table HFJ_RESOURCE_MODIFIED added the index IDX_RES_MOD_CREATED on (CREATED_TIME). Audit Log Persistence: No changes in this release. Transaction Log Persistence: No changes in this release. |
| 2026.08 | LOW | MEDIUM | NONE | NONE | MEDIUM | Cluster Manager: This release adds persistent storage for scheduled job definitions and their execution history as well as performs some minor data cleanup. Persistence: This release ALTERs the HFJ_SEARCH and BT2_JOB_INSTANCE tables, so if those contain a large amount of data, those steps could take some time. This release also adds support for a redesigned TOKEN table structure but does not populate the new tables, which should be handled afterwards using a new $reindex Batch Job operation. Audit Log Persistence: No changes in this release. Transaction Log Persistence: No changes in this release. |
You are about to leave the Smile Digital Health documentation and navigate to the Open Source HAPI-FHIR Documentation.