The enterprise outline code lookup tables are incorrect after you install Project Server 2003 Service Pack 2

When you use Microsoft Office Project Server 2003, you check out and then save the enterprise global template file. Then, you notice that the lookup tables that are associated with enterprise outline codes are incorrect. For example, the lookup tables have missing nodes. Alternatively, items in the list are disordered.

For example, suppose that you have an outline lookup table structure that looks similar to the following example before you install Project Server 2003 Service Pack 2 (SP2):After you install Project Server 2003 SP2, the outline lookup table structure may look similar to the following example:Additionally, you may not be able to expand or collapse the nodes of the outline lookup table structure.

This problem occurs after you install Project Server 2003 SP2.

To resolve this issue, download and install Project Server 2003 SP2a.

For more information about how to obtain Project Server 2003 SP2a, click the following article number to view the article in the Microsoft Knowledge Base: Note Project Server 2003 SP2 was released on September 27, 2005. Project Server 2003 SP2a was released on December 13, 2005. Project Server 2003 SP2a resolves the issue that is mentioned in the "Symptoms" section.

After you install Project Server 2003 SP2a, follow these steps:

1. Run the following SQL query against the project database that experiences this issue:
   

   UPDATE MSP_PROJECTS
   SET PROJ_EXT_EDITED = 0
   WHERE PROJ_TYPE = 2
   

2. Open the enterprise global template file by using Microsoft Office Project Professional 2003.
   
   To do this, follow these steps:
   1. Connect to Project Server 2003 by using Project Professional 2003.
   2. In Project Professional 2003, click Tools, point to Enterprise Options, and then click Open Enterprise Global.
3. Verify that the enterprise outline code lookup tables are displayed the way that you expect. If they are not displayed the way that you expect, collapse the outline by clicking the minus sign (-) and then re-expanding the outline.
   
   To re-expand the outline, follow these steps:
   1. Click Tools, point to Customize, and then click Enterprise Fields.
   2. Click the Custom Outline Codes tab in the Customize Enterprise Fields dialog box, select the field that you want to view, and then click View Lookup Table.
4. On the File menu, click Save. Then, click Close to close the enterprise global template file.

Note If you did not try to fix the original problem by trying to add back nodes that were missing or by re-ordering nodes that were disordered, you should only have to run the script.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Microsoft is researching this problem and will post more information in this article when the information becomes available.