RBS values are unexpectedly missing after you install Microsoft Project Server 2002 Service Pack 1 (843409)


The information in this article applies to:

  • Microsoft Project Server 2002

SYMPTOMS

When you check out resources from the Enterprise Resource Pool in Microsoft Project Server 2002 after you install Microsoft Project 2002 Server Service Pack 1 (SP1) on the server, the Resource Breakdown Structure (RBS) values of the resources are unexpectedly missing.

CAUSE

This problem occurs because during the upgrade operation to Microsoft Project Server 2002 SP1, the value of the WRES_RBS_UID_P10SP1 field in the MSP_CODE_FIELDS table is not copied to the corresponding field in the MSP_WEB_RESOURCES table. The stored procedure that checks whether the value of the WRES_RBS_UID_P10SP1 field in both tables match determines that the value is not present in the MSP_WEB_RESOURCES table, and then deletes the corresponding record from the MSP_CODE_FIELDS table. Therefore, the RBS values of resources are set to use a NULL value.

WORKAROUND

Note Use the following method after you apply Microsoft Project Server 2002 SP1 to the server to avoid this problem. If you already checked resources from the Enterprise Resource Pool, the RBS values for those resources are lost. The RBS values for the resources are lost even if you do not save the Enterprise Resource Pool after you check out the resources. In this situation, you can either reset the RBS values for those resources whose RBS values are missing, or reinstall Microsoft Project Server 2002 SP1 and perform the following procedure before you check out a resource from the Enterprise Resource Pool.

To work around this problem and to prevent the RBS values from being reset to NULL, use SQL Query Analyzer in Microsoft SQL 2000 Server to run the following SQL script after you install Microsoft Project Server 2002 SP1 on the server: 
update wr 
set wr.WRES_RBS_UID_P10SP1 = cf.CODE_UID
from MSP_WEB_RESOURCES wr inner join MSP_CODE_FIELDS cf on wr.RES_EUID = cf.CODE_REF_UID
where cf.PROJ_ID = 1 and CODE_CATEGORY = 1 and CODE_FIELD_ID = 205521540
To do this, follow these steps:
  1. On the server that is running SQL Server, start SQL Query Analyzer.
  2. In the Connect to SQL Server dialog box, specify the name of the server that you want to connect to, specify the type of authentication, and then click OK.
  3. In the Query pane, type the following lines:

    update wr
    set wr.WRES_RBS_UID_P10SP1 = cf.CODE_UID
    from MSP_WEB_RESOURCES wr inner join MSP_CODE_FIELDS cf on wr.RES_EUID = cf.CODE_REF_UID where cf.PROJ_ID = 1 and CODE_CATEGORY = 1 and CODE_FIELD_ID = 205521540

  4. On the Query menu, click Execute to run the query.

STATUS

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

MORE INFORMATION

For additional information about RBS in Microsoft Project 2002 Server, click the following article number to view the article in the Microsoft Knowledge Base:

831611 A description of the Resource Breakdown Structure and how it is used in Project Server 2002

For additional information about Microsoft Project Server Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

830240 Description of Microsoft Project Server 2002 Service Pack 1

For more information about Microsoft Project Server 2002, visit the following Microsoft Web site:

http://www.microsoft.com/office/previous/project/default.asp

Modification Type:MajorLast Reviewed:6/6/2004
Keywords:kbnofix kbBug kbprb KB843409 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.