Run Migration Script 10 to correct multilanguage lookup table upgrade issues
Applies to: Project Server 2010
Topic Last Modified: 2010-05-18
Run Script 10 to check your Microsoft Office Project Server 2007 data for a known issue in which multi-language lookup tables are not updated correctly after migration from Microsoft Office Project Server 2003 to Office Project Server 2007. This script corrects and updates the Office Project Server 2007 Published database if the issue is detected.
Warning
This script is one of several post-migration scripts included in the Project Server virtual migration environment (VME). Running the scripts is optional, but highly recommended for helping to detect issues that may prevent a successful migration of your data. For more information about the post-migration scripts that are available, see Project Server VME: Run post-migration scripts (optional).
To run Script 10
On the VME desktop, click Start Migration Process. This opens a Windows Explorer window that displays the contents of drive E.
In Windows Explorer, double-click the following folder:
If you have one Project 2003 database, open the Migrate_Proj_2003_Single_DB folder.
If you have split Project Server 2003 databases, open Migrate_Proj_2003_Split_DB.
Open the Verification Scripts folder, and then click VME Script 10.sql. This opens SQL Server Management Studio and displays Script 10.
Click Execute to run the script.
Script 10
Script 10 contains the following code:
Use ProjectServer_Published
DELETE FROM dbo.MSP_LOOKUP_TABLE_LANGUAGES WHERE LT_UID NOT IN (SELECT LT_UID FROM dbo.MSP_LOOKUP_TABLES)
DELETE FROM dbo.MSP_LOOKUP_TABLE_MASK_VALUES WHERE LT_UID NOT IN (SELECT LT_UID FROM dbo.MSP_LOOKUP_TABLES)
DELETE FROM dbo.MSP_LOOKUP_TABLE_MASK_STRUCTURES WHERE LT_UID NOT IN (SELECT LT_UID FROM dbo.MSP_LOOKUP_TABLES)
DELETE FROM dbo.MSP_LOOKUP_TABLE_VALUES WHERE LT_UID NOT IN (SELECT LT_UID FROM dbo.MSP_LOOKUP_TABLES)
DELETE FROM dbo.MSP_LOOKUP_TABLE_STRUCTURES WHERE LT_UID NOT IN (SELECT LT_UID FROM dbo.MSP_LOOKUP_TABLES)