This error occurs when a REG_ENQUIRY_SESSION_STEP records is referenced by REG_ENQUIRY_SEARCH_RESULTS for another person_id but with the same ID as REG_ENQUIRY_SESSION.
It's unclear if this is a bug in the person delete process or this is related to data being migrated incorrectly, which appears to be the case in the examples reviewed to date.
If you encounter this error, please raise a new case listing the affected person records and we will investigate.
Error: 'The DELETE statement conflicted with the REFERENCE constraint "RGENQSTPSRCHSRS_ENQSESTP_FK'
In this article, we look at why when deleting a person records you get an error.
Y
Written by Yusef Abulaynain
Updated over 2 months ago