PS2007 to PS2010 Migration - Project Site URL Issue RRS feed

  • Question

  • Greetings,

    After the migration from PS2007 to PS2010 in two separate environments, upon completing the post-migration configuration (including the "Bulk Update Project Sites" process to re-link the Project Sites), everything seemed to be working just fine. The Project Sites are rendering correctly from any of the usual PWA links and the linking within the sites to PWA (Task, Issues, Risks, etc...), are working also.

    However, upon attempting to generate reports using data from the ProjectServer_Reporting database, we noticed in the Database View 'dbo.MSP_EpmProject_UserView', the column 'ProjectWorkspaceInternalHRef' contains the old PS2007 URL's in one of the PS2010 Instances and null values in the other.

    It appears as though the ProjectServer_Reporting database (at least the 'ProjectWorkspaceInternalHRef' field in that database), is not getting updated. As mentioned, the links to the Project Sites in PWA are all working just fine.

    Does anyone know what would prevent this field from updating?

    Can anyone provide suggestions on how we can go about correcting this issue?



    Wednesday, July 27, 2011 11:02 PM


All replies