Migrating Project Server 2007 to 2010 RRS feed

  • Question

  • Hello,

    We were doing migration from Project Server 2007 to 2010. We have tried to use the database backup and restore technique. We backup the 5 databases from PS 2007 and then restored in PS 2010. When we tried to Provosion PS 2010 it always failed. But when we tried to use blank 4 database i.e. Draft, Archive, Published and Reporting and used WSS_Content from PS 2007 it got provisioned. All the Project Workspace are coming but none of the Projects are appearing in Project Center.


    Project Server 2007: Windows 2003, SQL 2005 SP3, PS 2007

    Project Sever 2010: Windows 2008, SQL 2008 R2, PS 2010

    We are using different servers for PS 2007 and PS 2010 and the Server names are also different.




    Thanks & Regards, Benno
    Sunday, May 15, 2011 5:04 AM


All replies

  • Hi Benno,

    The reason you are getting no projects in Project Center is that the Project information is stored in the draft and published databases that you mentioned above you used blank versions of for the provision.

    What you are trying to do is called a DB Full Attach upgrade, taking the content db and the four project databases and provisioning the PWA instance to leverage them. The full details for this procedure are outlined at http://technet.microsoft.com/en-us/library/ee662500.aspx. If you follow the steps in that article it should all work for you.

    If you run into issues, please post the error you see in this forum and we'll see what we can do for you :)

    good luck,


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Sunday, May 15, 2011 7:34 AM
  • Hi Alex,

    I have tried earlier to do the DB Full Attach upgrade, but it failed so i tried the other option. I again followed the steps and tried to do DB Full Attach upgrade. Again it failed and below is the Log for the same:

    0x1408 SharePoint Foundation          General                        erv2 Medium   Updating X.509 certificate validation policy 
    05/15/2011 22:20:34.56  w3wp.exe (0x0970)                        0x1408 SharePoint Foundation          General                        erv3 Medium   Adding X.509 certificate thumbprint '3CAA5F863156E6BEF92D90E9BB71AF35A786AAB3' to root authority trust 
    05/15/2011 22:20:34.56  w3wp.exe (0x0970)                        0x1410 SharePoint Foundation          General                        erv3 Medium   Adding X.509 certificate thumbprint '3CAA5F863156E6BEF92D90E9BB71AF35A786AAB3' to root authority trust 
    05/15/2011 22:20:34.56  w3wp.exe (0x0970)                        0x1410 SharePoint Foundation          General                        erv2 Medium   Updating X.509 certificate validation policy 
    05/15/2011 22:20:34.57  OWSTIMER.EXE (0x0A6C)                    0x0AF0 Project Server                 Provisioning                   7074 Information Finished removing ProjectSite object for 'SharePoint - 80:PWA_Migration'. 6011d0b6-68f1-4be5-88c2-193ef50c13ba
    05/15/2011 22:20:34.57  OWSTIMER.EXE (0x0A6C)                    0x0AF0 Project Server                 Provisioning                   6971 Critical Failed to provision site PWA_Migration with error: Microsoft.Office.Project.Server.Administration.ProvisionException: Post provisioning setup failed.     at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset) 6011d0b6-68f1-4be5-88c2-193ef50c13ba
    05/15/2011 22:20:34.57  OWSTIMER.EXE (0x0A6C)                    0x0AF0 SharePoint Foundation          Topology                       8xqz Medium   Updating SPPersistedObject ProjectProvisionSettings Name=2e6a459e-31b3-457f-bbaa-c91f3dafb49a. Version: 77295 Ensure: False, HashCode: 19776872, Id: 190cdc67-c546-47c4-9e61-b4c02b0f3660, Stack:    at Microsoft.SharePoint.Administration.SPPersistedObject.BaseUpdate()     at Microsoft.Office.Project.Server.Administration.ProjectProvisionSettings.SetStatus(ProjectProvisionStatusType status, String updateInfo)     at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset)     at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.RunProvisionJob(ProjectProvisionSettings provset)     at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.AdminSynchronize()     at Microsoft.Office.Project.Server.Administr... 6011d0b6-68f1-4be5-88c2-193ef50c13ba
    05/15/2011 22:20:34.57* OWSTIMER.EXE (0x0A6C)                    0x0AF0 SharePoint Foundation          Topology                       8xqz Medium   ...ation.ProjectPSISharedApplicationTimerJob.Execute(Guid targetInstanceId)     at Microsoft.SharePoint.Administration.SPTimerJobInvokeInternal.Invoke(SPJobDefinition jd, Guid targetInstanceId, Boolean isTimerService, Int32& result)     at Microsoft.SharePoint.Administration.SPTimerJobInvoke.Invoke(TimerJobExecuteData& data, Int32& result)   6011d0b6-68f1-4be5-88c2-193ef50c13ba
    05/15/2011 22:20:34.57  w3wp.exe (0x13D8)                        0x02E4 SharePoint Foundation          General                        erv2 Medium   Updating X.509 certificate validation policy 


    Thanks & Regards, Benno
    Monday, May 16, 2011 5:52 AM