Project Server 2010 : FOREIGN KEY constraint Error

Hello again ,

Today we are having a n interesting project Server Issue , I dont have a clear idea on the cause of this Issue but Microsoft calims its a bug that will cause some of your GUID to change when you try to use the save and send feature .... anyway when you try to publish you r project you will end up with this error



General
Reporting message processor failed:
ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.



so what this error basically say that there is  foreign key want found when it was trying to insert a task with a foreign key UID from another table , in another words less technical there is some data missing from the database ...


so the bad news is you cant really know what is the cause behind this , the good news is there is a solution

actually to make it better the solution is easy
 backup ..backup..backup 


run the following script against your draft database and against your published database
select PROJ_NAME, MTB.PROJ_UID,TASK_UID,TB_BASE_NUM from MSP_TASK_BASELINES MTB


inner join MSP_PROJECTS MP on MTB.proj_uid=MP.proj_uid

where TASK_UID not in (select TASK_UID from MSP_TASKS)

    if and you should get some raws with this command those tasks are the origin of your Issue to resolve it run the following command againest your draft and puplished databes


DELETE FROM MSP_TASK_BASELINES WHERE TASK_UID not in (SELECT TASK_UID FROM MSP_TASKS)


once you run this make sure that you clean the project cashe from the user machine and republish it again

hope this help
regards

How to Overwrite a project (properly)

Hello

This is a quick post for an Issue that i have faced today (not actually an Issue but something the user couldn't do) 

Project Server 2013 good news and bad news

Hi ,

I was going through project online and looking for any changes and if any of the things that we usually struggle with have changed, I was more than happy to notice allow multiple lines in timesheet administrative tasks as you can notice below

project server 2007 migrate to project server 2010

Ok, to make a long story short we are implementing project server 2010 for a client who we have already implemented project server 2007 so typically we need to migrate the current server .

so we started by studying our options the in place upgrade was eliminated project server 2007 was installed over 2003 server so i ended up asking my college to start a core upgrade following Microsoft steps

http://technet.microsoft.com/en-us/library/ee662499.aspx

and for some reason once we provision the PWA we end up with a provision failure and no luck for 2 days , the upgrade logs showed that the data base conversion went on with 0 errors and 0 warnings . but still the PWA couldn't provision correctly we went over Microsoft instructions over and over and step by step with no luck .

so to resolve this issue i done the following

1-i followed the steps again until i got the provision error
2-provision a new 2010 PWA
3-replace the new 2010 PWA databases with the converted data bases from the 2007

and we ended up with a working project web application still we didn't fully test it but at least we have something to start with