We are occasionally running into an issue when we save a record via SOA (using the EntityManager.Add method).
The exception message is: The DELETE statement conflicted with the REFERENCE constraint "FK_Institute_GroupMain_Institute". The conflict occurred in database "ClientDBName", table "dbo.Institute", column 'InstituteGroupKey'.
The statement has been terminated.
It seems as though SOA is trying to delete a record from the Institute table, but it fails because of a foreign key referencing a corresponding row in the GroupMain table.