Skip to main content
P
putlurus9219
September 25, 2023
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

  • September 25, 2023
  • 3 replies
  • 0 views

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
    mathieud0001
    September 26, 2023

    Is this on a Record or a Data Type?

    P
    putlurus9219Author
    September 26, 2023

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

    mathieud0001
    mathieud0001
    September 26, 2023

    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.

    Terms & ConditionsAccessibility statement