none
Cannot provision a PWA site on 5 database restore giving error System.NullReferenceException mesage RRS feed

  • Question

  • We have restored 5 databases (Sql server 2008 R2) from production to Test environment for some critical tests. The PWA site has is being provisioned in a separate web application but is failing with message 'Failed - see the Application event Log'

    It is surprising as they were provisioned fine before, but due to some reason the content database got trncated and has to be restored again. Umpteenth tries and deletion and recreation of new web application has been made but it is giving the same message. The PWA is provisioning fine

    Warning :Reusing http://servername/PWA site for provisioning PWA

    Event 6051: ProjectSite not created.

    Event 6962: Provisioning 'PWA': Project site object creation failed. Exception 'System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.SharePoint.SPSite..ctor(Guid id, SPFarm farm, SPUrlZone zone, SPUserToken userToken)
       at Microsoft.SharePoint.SPSite..ctor(Guid id)
       at Microsoft.Office.Project.Server.Administration.ProjectSite..ctor(Guid webAppId, Guid siteId, String adminName, Int32 lcid, Boolean needsUpgrade, PsiServiceApplication parent)
       at Microsoft.Office.Project.Server.Administration.ProjectSiteCollection.Add(Guid webAppId, Guid siteId, String adminName, Int32 lcid, String PubDBConnString, String VerDBConnString, String WorkDBConnString, String RepDBConnString, Boolean needsUpgrade)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset)'.

    Event 6971 :Failed to provision site PWA with error: System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.SharePoint.SPSite..ctor(Guid id, SPFarm farm, SPUrlZone zone, SPUserToken userToken)
       at Microsoft.SharePoint.SPSite..ctor(Guid id)
       at Microsoft.Office.Project.Server.Administration.ProjectSite..ctor(Guid webAppId, Guid siteId, String adminName, Int32 lcid, Boolean needsUpgrade, PsiServiceApplication parent)
       at Microsoft.Office.Project.Server.Administration.ProjectSiteCollection.Add(Guid webAppId, Guid siteId, String adminName, Int32 lcid, String PubDBConnString, String VerDBConnString, String WorkDBConnString, String RepDBConnString, Boolean needsUpgrade)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset)

    Tuesday, May 15, 2012 9:07 PM

All replies

  • It inadvertently got submitted without clicking submit. It is Project Server 2010. The PWA site is provisoning fine on default Content database with the new web application. The restored content database has 3 sites: a SharePoint site , a my site and a PWA site. Any solution will be highly appreciated.
    Tuesday, May 15, 2012 9:13 PM
  • Hi Geeam,

    You may need to start from step 1. Seems  like some soft of corruption in the PWA site collection.

    1. Delete failed PWA site

    2. Detach content database

    3. Delete databases from SQL Server (Content+Project DB's)

    4. Take new backup of databases from production and restore in test

    5. Attach the content database to the web application and try to provision PWA site


    Hrishi Deshpande – DeltaBahn Senior Consultant
    Blog | < | LinkedIn

    Wednesday, May 16, 2012 1:41 AM
    Moderator
  • Hi There--

    If the PWA site provisioning is successful, You may need to attach the restored content database on the web application.
    Here is the article (step by step)
    http://technet.microsoft.com/en-us/library/ee662500.aspx#add

    For more info, Please refer to Andrew's post:
    http://azlav.umtblog.com/2011/06/09/project-server-2010-database-restore-part-ii/


    If you found this post helpful, Please "Vote as Helpful";. If it answered your question, Please "Mark as Answer". Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, May 16, 2012 5:08 AM
  • The new PWA site creation is still failing with the same error message 'Failed  - see the Application event Log' . The application log showed the same message: Event 6962: Provisioning 'PWA': Project site object creation failed. Exception 'System.NullReferenceException: Object reference not set to an instance of an object. (after issuing a warning like before 'Reusing http://servername/PWA site for provisioning PWA')

    Should we try to create the PWA site in a new Project Service Application instance?

    We did the following :

    1. Deleted failed PWA site. Deleted the web application.

    2. Detached content database

    3.Deleted all 5 databases from SQL Server (content and Project Servers)

    5. Made a new web application in test, attached the content databases to it and tried to create the PWA site in the current Project Service Application.

     It failed to create PWA site though in the logs we see the databases have been provisioned etc. but failing to create site.

    Any solution will be highly appreciated.

     

      

    It is critical for us to create the site for carrying out the tests. Surprisingly, we could create the site the PWA site(on the restored databases in test) in the past with much issue.

    4.Made new backup of databases from Production and restored in test.

    Thursday, May 17, 2012 3:14 PM
  •  step 4 somehow got dropped from the previous mail : after step 3 : deleting the 5 databases from sql server

    4) Made a fresh backup of all the 5 databases in production and restored it in test.

    Then went on to made a new web application in test which is the step 5.

    Thanks

    Thursday, May 17, 2012 3:19 PM
  • Hi geeam,

    This appears to indicate you have a NULL referenced content DB.  I'd suggest opening a support incident with Microsoft to have us work through this with you.  Depending on the urgency (and the fact that this is a test environment) you may find that rebuilding your SharePoint Configuration DB will resolve the issue - it really depends how customized your environment is.  If you do open an incident then also ping me (brian.smith@microsoft.com) so I can keep an eye on the case.

    Best regards,

    Brian.


    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page

    Friday, May 18, 2012 2:12 PM
    Owner
  • Thanks for your suggestions. We will go with rebuilding the SharePoint Configuration database approach. Any specific advise for that as there is a 

    web application now running the Project Web app with a test data?

    Friday, May 18, 2012 4:06 PM
  • If you back up with 5dbs relating to that test instance then these can be used to reprovision the test environment after re=creating the configuration DB - so the content db and the 4 Project Server DBs.

    Best regards,

    Brian


    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page

    Friday, May 18, 2012 4:10 PM
    Owner
  • Thanks Brian for your insight. We will be rebuilding the configuration database with the guidelines given by you.

    Friday, May 18, 2012 7:07 PM
  • Hi geeam.

    before restoring your environment.

    1- be sure that you have installed the same updates (SP+CU) in the test environment.

    2- restore your databases.

    3- reaprovision your PWA instance


    Monday, May 21, 2012 7:26 PM
  • As we want to make sure that the present test environment should not be lost, what steps should we follow to rebuild the configuration database( besides backing up the existing 5 databases). Should we delete the present configuration database?

    Also the content  database that we are restoring from production to test have 3 site collections: the PWA site, a my site and one more site collection. After reprovisioning the PWA site, while the reprovisioned PWA site points to test environment, the other 2 sites continue to point to production environment. What needs to be done to point them towards the test environment.

    Friday, June 1, 2012 1:01 PM