none
Restore Project Server 2010 Database RRS feed

  • Question

  • Hi All,

    I've created new farm with Project Server2010 and tried to attach databases from another farm.

    I moved databases using this instruction:

    1. Backup the SQL databases (ProjectServer_Archive_ITT, ProjectServer_Draft_ITT,ProjectServer_Published_ITT, ProjectServer_Reporting_ITT,WSS_Content_ITT ) from the source environment.
    2. Restore the SQL databases to the target environment.
    3. Create a new Web Application if one does not exist already.  You need to provision the new PWA site with the same URL as the old one, so if your source URL washttp://source/PWA then you need to provision this to a Web App using the PWA address.  You may use something like http://target/PWA or evenhttp://target:81/PWA, but it helps to use a Web App that doesn’t already have a PWA site provisioned already as that may have already used the default PWA URL.
    4. Use STSADM (or whatever tool you’d like) to add the content database to your new Web App.
      STSADM.EXE -o addcontentDB -url http://itt -databaseserver DBS67 -databasename WSS_Content_ITT
    5. Provision a new PWA site with the same URL and databases that you restored.

    And... when i'm trying to create new PWA it shows an error "Failed - see the Application event Log".

    Event viewer show 3 errors

    1) "Provisioning 'ITT': Membership synchronization failed."

    2)

    Provisioning 'ITT': Post provisioning setup failed. Exception 'Microsoft.Office.Project.Server.Administration.ProvisionException: Membership synchronization failed. ---> Microsoft.SharePoint.SPException: A domain group cannot be the owner of a group.
       at Microsoft.SharePoint.SPGroupCollection.AddInternal(String name, SPMember owner, SPUser defaultUser, String description)
       at Microsoft.SharePoint.SPGroupCollection.Add(String name, SPMember owner, SPUser defaultUser, String description)
       at Microsoft.Office.Project.Server.BusinessLayer.SharePointSecurityHelper.CreateGroup(SPWeb web, SPMember owner, String groupName, String groupDesc, Boolean isAdmin)
       at Microsoft.Office.Project.Server.BusinessLayer.SharePointSecurityHelper.CreatePWAWSSGroups(SPWeb web, SPMember owner)
       at Microsoft.Office.Project.Server.BusinessLayer.SharePointSecurityHelper.ConfigureDefaultPWAWSSSecurityModel(SPSite topSite, SPWeb web)
       at Microsoft.Office.Project.Server.BusinessLayer.Admin.<>c__DisplayClass18.<QueueUpdateUsersAddRemoveStatusOnPwaRootsAndWorkspaces>b__17()
       at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()
       at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
       at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
       at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
       at Microsoft.Office.Project.Server.BusinessLayer.Admin.QueueUpdateUsersAddRemoveStatusOnPwaRootsAndWorkspaces(Dictionary`2 deletedUserUidsLoginNames, Guid[] addedUserUids, Boolean isFullSync, Boolean syncWorkspaces)
       at Microsoft.Office.Project.Server.BusinessLayer.Admin.SynchronizeMembershipForPwaAppRootSite()
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.SynchronizePwaMembership(ProjectProvisionSettings provset, ProjectSite projectSite)
       --- End of inner exception stack trace ---
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.SynchronizePwaMembership(ProjectProvisionSettings provset, ProjectSite projectSite)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset)'.


    3) 

    Failed to provision site ITT with error: Microsoft.Office.Project.Server.Administration.ProvisionException: Membership synchronization failed. ---> Microsoft.SharePoint.SPException: A domain group cannot be the owner of a group.
       at Microsoft.SharePoint.SPGroupCollection.AddInternal(String name, SPMember owner, SPUser defaultUser, String description)
       at Microsoft.SharePoint.SPGroupCollection.Add(String name, SPMember owner, SPUser defaultUser, String description)
       at Microsoft.Office.Project.Server.BusinessLayer.SharePointSecurityHelper.CreateGroup(SPWeb web, SPMember owner, String groupName, String groupDesc, Boolean isAdmin)
       at Microsoft.Office.Project.Server.BusinessLayer.SharePointSecurityHelper.CreatePWAWSSGroups(SPWeb web, SPMember owner)
       at Microsoft.Office.Project.Server.BusinessLayer.SharePointSecurityHelper.ConfigureDefaultPWAWSSSecurityModel(SPSite topSite, SPWeb web)
       at Microsoft.Office.Project.Server.BusinessLayer.Admin.<>c__DisplayClass18.<QueueUpdateUsersAddRemoveStatusOnPwaRootsAndWorkspaces>b__17()
       at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()
       at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
       at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
       at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
       at Microsoft.Office.Project.Server.BusinessLayer.Admin.QueueUpdateUsersAddRemoveStatusOnPwaRootsAndWorkspaces(Dictionary`2 deletedUserUidsLoginNames, Guid[] addedUserUids, Boolean isFullSync, Boolean syncWorkspaces)
       at Microsoft.Office.Project.Server.BusinessLayer.Admin.SynchronizeMembershipForPwaAppRootSite()
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.SynchronizePwaMembership(ProjectProvisionSettings provset, ProjectSite projectSite)
       --- End of inner exception stack trace ---
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.SynchronizePwaMembership(ProjectProvisionSettings provset, ProjectSite projectSite)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset)

    Could you please help with this issue?

    Monday, March 17, 2014 6:57 AM

All replies

  • What is the site ITT?

    Hrishi Deshpande Senior Consultant

    Monday, March 17, 2014 4:07 PM
    Moderator
  • When i create new PWA site - ITT is "Project Web App path".
    Tuesday, March 18, 2014 3:12 AM
  • Make sure that the database owner for all the project databases is the same as the Farm account that is provisioning the PWA.

    Also, were the source project databases in the same domain as the destination?

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Tuesday, March 18, 2014 3:31 AM
    Moderator
  • Michael,

    I use account which has sysadmin role on database server.

    Source database and destination DB are in the same domain.

    Tuesday, March 18, 2014 6:57 AM
  • From above information my understand is your source Project Web App address is http://servername/ITT and you are trying to provision as http://servername/pwa, correct me if I am wrong.


    Hrishi Deshpande Senior Consultant

    Tuesday, March 18, 2014 5:44 PM
    Moderator
  • Hrishi.

    The sourse Project Web app is http://servername/ITT and i'm trying to provision http://newserver/ITT

    Wednesday, March 19, 2014 3:32 AM
  • One of my clients had a similar problem today and server reboots solved it.

    the general steps you have outlined are correct.  check that you have given your install / setup account (the one you are using to do all this work) access to the site collection after attaching the CDB to the Web App - typically, I make the account site collection admin.

    also, in SQL Server, be sure the Farm and other important accounts have DBO on the restored DB's.

    finally, in some cases, run the IE SPCA windows with "Run as Administrator" rights.

    your error is curious: Membership synchronization failed. ---> Microsoft.SharePoint.SPException: A domain group cannot be the owner of a group.

    can you figure out what this means in your farm? 

    http://www.tek-tips.com/viewthread.cfm?qid=1482402

    http://choxblog.wordpress.com/2009/02/05/cannot-add-group-domain-to-sharepoint-group/

    Hope this helps,


    Thanks, Eric S. Pcubed

    Thursday, March 20, 2014 4:54 AM
  • ErockP3, 

    I use account with sysadmin role on DB server and it has Farm admin permissions on application server.

    I've tried tu run the IE SPCA, but result is the same.


    Saturday, March 22, 2014 5:27 AM