Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
PWA 2010 site stuck "In Progress" for 24 hours

Traitée PWA 2010 site stuck "In Progress" for 24 hours

  • 2012. február 16. 18:18
     
      Kódot tartalmaz
    Bejelentkezés a szavazáshoz
    0

    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
    http://technet.microsoft.com/en-us/library/ff607528.aspx

    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
     
     Válasz
    Bejelentkezés a szavazáshoz
    0

    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
    http://blogs.technet.com/b/raymond_ris/archive/2010/04/02/clearing-sharepoint-configuration-cache-for-time-job-and-psconfig-errors.aspx

    Clear the SharePoint Configuration Cache
    http://blogs.msdn.com/b/josrod/archive/2007/12/12/clear-the-sharepoint-configuration-cache-for-timer-job-and-psconfig-errors.aspx

    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:21
    Moderátor
     
     
    Bejelentkezés a szavazáshoz
    1

    As a last resort, follow the process carefully.

    Note : Take the SPS farm backup for safer side.

    Use Sharepoint_config

    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:38
     
     
    Bejelentkezés a szavazáshoz
    0
    Is that a good script to try if the powershell commands don't work? If not, which is preferable? Thanks!