Fix for Liquibase upgrade failure due to NULL participantId 97/142397/2
authordanielhanrahan <daniel.hanrahan@est.tech>
Mon, 10 Nov 2025 14:02:42 +0000 (14:02 +0000)
committerDaniel Hanrahan <daniel.hanrahan@est.tech>
Mon, 10 Nov 2025 16:50:49 +0000 (16:50 +0000)
commit5c05acc556e8f35d0809edf0e35e19e27f7389c4
tree7f092a34a47c27b390e1b23bfbb30001dab9f795
parent4ab4ee94e599ba4dd8ba3fe80e352450e951cef6
Fix for Liquibase upgrade failure due to NULL participantId

This fixes an intermittent upgrade issue when adding not-null
constraints to participant tables due to orphan entries with
NULL values. The fix is to delete rows with NULL entries before
adding the NOT NULL constraints. Since the changesets may have
already been deployed, we need to override the checksums to
avoid Liquibase checksum validation errors.

Issue-ID: POLICY-5486
Change-Id: Ic60b536a1118c3f22e32f04ef0d1c573917c0d20
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
runtime-acm/src/main/resources/db/changelog/changelog-1701.yaml