Project site associations do not appear after Project instance migration

Thi issue is caused by the database restore. When restoring the database the associated server for the project site does not get rewritten. Due to the query SharePoint performs only sites with the correct server UID will be associated to projects.

To fix this the Server UID will have to be updated in the [MSP_PROJECTS] table.

To update the project site associations run the following query on the database:

update  [!!INSTANCENAME!!_Published].[dbo].[MSP_PROJECTS] SET wsts_server_uid = 'UID'
        WHERE WSTS_SERVER_UID IS NOT NULL

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

About the author

Hi! I'm Marcell Mikolcsó, SharePoint and Enterprise Administrator, System Architect.

Month List

Page List