The error message is returned for a referential constraint definition with ON DELETE SET NULL specification, if a column of the referencing column does not allow the NULL value.
Choose another action in the DELETE rule or admit the NULL value for the corresponding column(s) in the referencing table.