Hello Experts, My purge database job is failing with below error message since today morning. Message : DELETE statement conflicted with COLUMN REFERENCE constraint 'MANIA_AED_fk'. The conflict occurred in database 'ARIA', table 'MANIA', column 'AED'. [SQLSTATE 23000] (Error 547) PurgeAllData: failed to delete DataHeader where dataid = 15467 [SQLSTATE 42000] (Error 50000) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed. can you please assist. rgds,
You're attempting to delete data that has a foreign key reference to another table. You have to delete the data in the child table first. Then you'll be able to delete the other data. Take a look at the definition of the foreign key constraint MANIA_AED_fk to know which table you need to worry about.