2012. február 16. 18:18
I'm trying to provision a new Project Web application site and the job is stuck. Never had issues before, we already have 3 PWA sites. We're at the Dec 2011 CU. I've rebooted, restarted the project server application service, the SP Timer job, and lastly (probably not a good thing) deleted the db's created for that In Progress site in hopes to get it to throw an error and stop. I've disabled/renabled the project provisioning job, too. It still said it was running, even when I disabled it.
I tried to create another site, and it sits at "waiting for resources," probably because it's waiting for the other site to finish. How can I kill this job?
All servers (2 WFE/App Servers) and a SQL Server are on Windows 2008 R2. There are no messages related to this in the ULS logs or the app or system logs.
I've also reset IIS.
I removed the instance via Powershell
after which it said "successfully deleted provisioning job", but it is not removed--When I run the command to
Get-SPProjectWebInstance -Url http://server/pwa --it still shows as "provisioning"
Az összes válasz
2012. február 17. 16:37
The partner site gave me a good recommendation on what to try:
From your description, I understand that you have a PWA instance stuck in Provisioning and been “In Progress” for a long time.
As you have tried to remove the related databases and disable the provisioning Jobs even restart the server, but it’s still “In Progress”. I think this could be caused by the some cache configurations. To clear the Cache file may be a good point to troubleshoot this problem, please refer to the following articles for details:
Clearing sharepoint Configuration cache for timer job and psconfig errors
Clear the SharePoint Configuration Cache
After cleaning the cache, please restart server to see if the issue remains. In addition, please ensure that if the SQL server is running on the default port.
>>>But what I found worked was taking the entire farm down and starting up with most services off--then running Powershell to delete the instance.
- Megjelölte válaszként: Donia Strand 2012. április 27. 22:00
2012. február 19. 13:21Moderátor
As a last resort, follow the process carefully.
Note : Take the SPS farm backup for safer side.
Select * from objects where properties= 'A Database name which is used in the PWA instance'
For Ex: select * from objects where properies='DEV_ProjectServer_Published'
stsadm -o deleteconfigurationobject -id 'ID from the above Query'
This will remove that entry from the SPS farm
Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
2012. február 24. 18:38Is that a good script to try if the powershell commands don't work? If not, which is preferable? Thanks!