The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

[Stephen]

We upgraded from sitefinity 4.3 to 4.4 and i get an error on a custom module that was outsourced

  personConfiguration.HasAssociation(p => p.Functions).WithOpposite(f => f.Persons)
                 .MapJoinTable("PM_Person_Function", (person, function) => new
                 {
                     PM_Person_ID = person.Id,
                     PM_Function_ID = function.Id
                 }).HasSequenceColumn("PM_Person_Function_ID", "Int"); 

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "ref_PM_Prsn_Function_PM_Person". The conflict occurred in database "PromaxBDA", table "dbo.PM_Person", column 'PM_Person_ID'.

[Stanislav Velikov]

Hello,

 Review the tables created by the custom modules in the database (the error indicates pm_person). The foreign key constraint prevents the table to be updated or deleted. Check if there are any constraints in the Fluent Mapping of the module and check which entry in the database is conflicting with the foreign key. I suppose it is one module item creating the problem.

Greetings,
Stanislav Velikov
the Telerik team