Project Server 2007: PWA Provisioning issue after February CU – Cannot insert duplicate key row

re: Project Server 2007: PWA Provisioning issue after February CU – Cannot insert duplicate key row

RAMON ALVAREZ — Sat, 20 Aug 2011 00:03:10 GMT

Excellent!!!!!

re: Project Server 2007: PWA Provisioning issue after February CU – Cannot insert duplicate key row

ShaiWa — Tue, 12 Jan 2010 11:01:12 GMT

Had the same error when i created a new PWA site.

Found out that the same sitename was used in the past and was removed.

Looking in the Sharepoint_config database i removed the old link in dbo.SiteMap and my propplem was solved.

Hope this could help someone.

Regards,

ShaiWa

re: Project Server 2007: PWA Provisioning issue after February CU – Cannot insert duplicate key row

Trutz-Sebastian Stephani — Tue, 07 Jul 2009 17:28:36 GMT

Hi Filipe,

I think the solution to your problem is that you have to execute option, but afterwards delete the PWA entry from the Provision Project Web Access page and also delete the databases created by the SSP. Afterwards navigate to Central Administration -> Application Management -> Delete Site Collections. There you might find still an entry of the PWA site collection. Delete it. Afterwards run "iisreset /noforce" from the command prompt and try again to provision a new PWA instance.

Cheers,

Trutz

re: Project Server 2007: PWA Provisioning issue after February CU – Cannot insert duplicate key row

Brian Smith - MSFT — Mon, 08 Jun 2009 18:04:06 GMT

Sorry Filipe you still have issues. This is a bug and you will not be charged if you open a support incident to help you resolve it. Incidentally it was introduced with the Feb CU and not the SP - although that does not reduce the gravity of the situation.

Best regards,

Brian.

re: Project Server 2007: PWA Provisioning issue after February CU – Cannot insert duplicate key row

Filipe de C. Ferreira — Sun, 07 Jun 2009 06:30:37 GMT

I tried both options and didnt work.

Isn´t it grave to MS release this bug in a SP?

re: Project Server 2007: PWA Provisioning issue after February CU – Cannot insert duplicate key row

Brian Smith - MSFT — Sat, 30 May 2009 21:30:25 GMT

Hi Martin,

Thanks for the feedback - I wasn't aware of this scenario. I am out of the office until Monday but will review the case you reference on my return.

Best regards,

Brian.

re: Project Server 2007: PWA Provisioning issue after February CU – Cannot insert duplicate key row

Martin Winzig — Sat, 30 May 2009 16:17:49 GMT

This article is not complete.

My environment

W2003en32b (regional settings czech) + MPS 2007en+ Sp2 + Czech MUI.

approaches

1) Provisioning -> Failed - see the Event Log & Existing MPS instances do not work !!!

2)changed OS regional settings to EN -> Provisioning -> Failed - see the Event Log & Existing MPS instances do not work .

(and of cour I dont know how to fix it, i try to delete timers but i didn't succed)

3rd approach Delete Timer -> Provisioning -> MPS Instance Created -> Provisioning -> error - Failed - see the Event Log( but Existing MPS instances works so it's better than first 2 scenarios )

So you shoud add information to you article that existing MPS instances should be corrupted

==================

PS my incident no is SRZ090529000376