Article ID: 835172 - View products that this article applies to.
If you use MSP_WEB_ASSIGNMENTS in an SQL statement in Microsoft SQL Analyzer to query against the resource’s timesheet directly, the query may return a value that is less than the value that appears on the resource's timesheet in Microsoft Project Web Access.
This problem occurs because the timesheet may not calculate the Actual Work field hours correctly, and this may affect the Sync to Protected Actual feature in Microsoft Office Project Professional 2003.
This problem was first fixed in a hotfix that is now contained in a service pack. If you installed the latest Project Server 2003 service pack, you do not have to install the hotfix.
Service pack informationThis problem is corrected in Project Server 2003 Service Pack 1.
To resolve this problem, obtain the latest service pack for Project Server 2003. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/873458/ )How to obtain the latest service pack for Project Server 2003
How to obtain the hotfixThis issue is fixed in the Microsoft Project Server 2003 Hotfix Package that is dated January 22, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
835217Important Applying this hotfix will prevent new data from exhibiting the behavior that is described in the "Symptoms" section.
(http://support.microsoft.com/kb/835217/ )Description of Microsoft Office Project Server 2003 hotfix package: January 22, 2004
After you apply this hotfix, see the "More Information" section to correct the data that exhibits this problem.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem was first corrected in Project Server 2003 Service Pack 1.
To correct the data that exhibits the problem that is described in the "Symptoms" section, follow these steps: