Skip to main content

Error: 'Person delete fails with FK_PERSON_NOTES_ALERT error'

In this article, we explain an error when deleting or merging a person, including FK_PERSON_NOTES_ALERT and records reappearing later.

Y
Written by Yusef Abulaynain
Updated over 2 months ago

Error:

β€˜The DELETE statement conflicted with the REFERENCE constraint "FK_PERSON_NOTES_ALERT". Error message: FK_PERSON_NOTES_ALERT.’

This is due to a legacy Frameworki code populating ALERT.ORG_MESSAGE_ID with the PERSON_NOTE.ID, even though the same ID is recorded in ALERT_TRIGGER_CONDITIONS.
​
This has been fixed in Mosaic version 22.2.4.0 and later.

Did this answer your question?