Inconsistencies in projectserver 2003 (timephased actual work)

[Michael]

Hello,

we are using Project Server 2003 SP2a and SQL Server 2000 SP4 with managed
periods (monthly). We experienced errors in the “actual work – protectedâ€
timephased data in the ms project client. There are two constellations:
1. The project client show more “actual work – protected†than was accepted
in web access. For example in May suddenly show the project plan new “actual
work – protected†in January. The wrong “actual work – protected†stands
always at the assignment start.
2. The project client show not all actual work that was accepted in web
access. For example 17 h are accepted in web access but only 9 h are in the
project plan in the timephased “actual work – protectedâ€.

We find the errors by using a view (at the end of this question) which show
the difference between the actual work of the assignment in the project plan
(ASSN_ACT_WORK) and in web access (WASSN_ACT_WORK).

As workaround makes the administrator an assignment actualisation in web
access. The acceptance updates the timephased “actual work – protected†for
the whole assignment.

Has anyone an idea what we could do to avoid this errors?

Thanks,
Michael

####################
SELECT TOP 100 PERCENT dbo.MSP_TASKS.PROJ_ID,
dbo.MSP_WEB_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_UID,
dbo.MSP_TASKS.TASK_NAME,
dbo.MSP_WEB_ASSIGNMENTS.WASSN_ID,
dbo.MSP_ASSIGNMENTS.ASSN_ACT_WORK / 60000 AS ASSN_ACT_WORK,
dbo.MSP_WEB_ASSIGNMENTS.ASSN_ACT_WORK / 60000 AS
WASSN_ACT_WORK,
dbo.MSP_WEB_ASSIGNMENTS.ASSN_ACT_WORK / 60000 -
dbo.MSP_ASSIGNMENTS.ASSN_ACT_WORK / 60000 AS ACT_DIFF,
dbo.MSP_ASSIGNMENTS.ASSN_ACT_WORK_PROT / 60000 AS
ASSN_ACT_PROT, dbo.MSP_ASSIGNMENTS.ASSN_WORK / 60000 AS ASSN_WORK,
dbo.MSP_WEB_ASSIGNMENTS.ASSN_WORK / 60000 AS
WASSN_WORK,
dbo.MSP_WEB_ASSIGNMENTS.ASSN_REM_WORK / 60000 AS
WASSN_REM_WORK, dbo.MSP_WEB_RESOURCES.RES_NAME,
dbo.MSP_WEB_RESOURCES.RES_EUID,
dbo.MSP_ASSIGNMENTS.ASSN_START_DATE, dbo.MSP_ASSIGNMENTS.ASSN_FINISH_DATE,
dbo.MSP_WEB_ASSIGNMENTS.WASSN_UPDATE_STATUS
FROM dbo.MSP_WEB_RESOURCES INNER JOIN
dbo.MSP_WEB_ASSIGNMENTS ON
dbo.MSP_WEB_RESOURCES.WRES_ID = dbo.MSP_WEB_ASSIGNMENTS.WRES_ID INNER JOIN
dbo.MSP_ASSIGNMENTS ON
dbo.MSP_WEB_ASSIGNMENTS.ASSN_UID = dbo.MSP_ASSIGNMENTS.ASSN_UID AND
dbo.MSP_WEB_ASSIGNMENTS.ASSN_ACT_WORK <>
dbo.MSP_ASSIGNMENTS.ASSN_ACT_WORK INNER JOIN
dbo.MSP_PROJECTS INNER JOIN
dbo.MSP_TASKS ON dbo.MSP_PROJECTS.PROJ_ID =
dbo.MSP_TASKS.PROJ_ID ON
dbo.MSP_ASSIGNMENTS.PROJ_ID = dbo.MSP_TASKS.PROJ_ID
AND dbo.MSP_ASSIGNMENTS.TASK_UID = dbo.MSP_TASKS.TASK_UID INNER JOIN
dbo.MSP_WEB_PROJECTS ON dbo.MSP_PROJECTS.PROJ_ID =
dbo.MSP_WEB_PROJECTS.PROJ_ID AND
dbo.MSP_WEB_ASSIGNMENTS.WPROJ_ID =
dbo.MSP_WEB_PROJECTS.WPROJ_ID
WHERE (dbo.MSP_WEB_ASSIGNMENTS.WASSN_UPDATE_STATUS = 0) AND
(dbo.MSP_WEB_ASSIGNMENTS.ASSN_ACT_WORK / 60000 > 0) AND
(dbo.MSP_WEB_ASSIGNMENTS.ASSN_ACT_WORK / 60000 -
dbo.MSP_ASSIGNMENTS.ASSN_ACT_WORK / 60000 < - 0.05) OR
(dbo.MSP_WEB_ASSIGNMENTS.WASSN_UPDATE_STATUS = 0) AND
(dbo.MSP_WEB_ASSIGNMENTS.ASSN_ACT_WORK / 60000 > 0) AND
(dbo.MSP_WEB_ASSIGNMENTS.ASSN_ACT_WORK / 60000 -
dbo.MSP_ASSIGNMENTS.ASSN_ACT_WORK / 60000 > 0.05)
ORDER BY dbo.MSP_PROJECTS.PROJ_NAME