Hi, when our users try to publish a project they get an error, pretty much the following:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignmentBasel
UID". The conflict occurred in database "PWA", table "dbo.MSP_EpmAssignmentBase
line". The statement has been terminated.. Details: id='24006'
Microsoft has released a hotfix for this issue (http://support.microsoft.com/kb/2883083
) but from what I understand that prevents tasks getting corrupted again, however I've quite a few tasks that are corrupted at the moment. The users can resolve this by deleting and re-adding the tasks, but I'm wondering does anyone know why this happens and is there anything I can do to fix the corrupt task and save the PM's having to re-do their work?