Skip to main content
Known Participant
Sep 25, 2023 7:27 PM UTC
Question

#1452 - Cannot add or update a child row: a foreign key constraint fails (`Appian`.`ISR_j_Product_TherapeuticArea`, CONSTRAINT `j_taProduct_fk` FOREIGN KEY (`therapeuticAreaId`) REFERENCES `ISR_TherapeuticArea` (`therapeuticAreaId`) ON DELETE NO ACTI

Hi All,

I am getting this error while adding new column record the table.

#1452 - Cannot add or update a child row: a foreign key constraint fails (`Appian`.`ISR_j_Product_TherapeuticArea`, CONSTRAINT `j_taProduct_fk` FOREIGN KEY (`therapeuticAreaId`) REFERENCES `ISR_TherapeuticArea` (`therapeuticAreaId`) ON DELETE NO ACTION ON UPDATE NO )

Could you please let me know how can we resolve this, 

    3 replies

    mathieud0001
    Genius
    Sep 26, 2023 1:01 AM UTC

    Is this on a Record or a Data Type?

    Known Participant
    Sep 26, 2023 1:54 AM UTC

    I am getting this error in data base while adding new column into the table

    mathieud0001
    Genius
    Sep 26, 2023 2:15 AM UTC

    Normally you would that type of message on an insert where the id in a column designated as a foreign key doesn't exist in the referenced table, not when you try to add a column to a record.