Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 843409 - Last Review: September 18, 2011 - Revision: 3.0
RBS values are unexpectedly missing after you install Microsoft Project Server 2002 Service Pack 1
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.
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.
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:
- On the server that is running SQL Server, start SQL Query
Analyzer.
- 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.
- 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
- On the Query menu, click
Execute to run the query.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=830240/
)
Description of Microsoft Project Server 2002 Service Pack 1
For more information about Microsoft Project Server
2002, visit the following Microsoft Web site:
APPLIES TO
- Microsoft Project Server 2002
| kbnofix kbbug kbprb KB843409 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate