Workaround for corrupt look-up tables in MOPS 2007

If you have installed Microsoft Office Project Server 2007 in your organization (MOPS 2007), you will sooner or later run across some product bugs that will hopefully be resolved with SP1 (availability unknown). This article describes a workaround for one of these bugs around Enterprise Custom Fields and Look-up Tables.



As you know with MOPS 2007 you can now create your Enterprise Custom Fields in PWA rather than in Project Professional as it was the case with Project Server 2003. To me, this is definitely much more convenient and a nice improvement. However, you will soon find that not all changes you apply to a look-up table linked to a custom field will be represented in Project Professional 2007. This is obviously caused by the new Active Cache feature in Project Pro 2007. Here is how you can work around that issue until a hotfix or service pack is available

1. Open Windows Explorer
2. Navigate to the following directory:
   C:\Documents and Settings\\Application Data\Microsoft\MS Project\Cache\
3. In \Cache you will find several subfolders labeled with long GUIDs
4. Within each GUID subfolder you will find a file named 'global[1].mpc'
   
5. Delete the 'global[1].mpc' from each subfolder. Alternatively you could also the entire subfolder for each GUID

Note: Make sure that the Project Professional 2007 application is not running at the moment you're performing the above steps.

Keep in mind that you will have to follow these steps for all clients.