Project server - MyTasks unexpected error

[Frank]

Problem description:

ProjectServer MyTasks Page give an unexpected error

Cause:

When a second resource is being assigned to a task that has a Work%
Completed > 0.

Behaviour:

The second resource will be presented the unexpected error

Solution:

STEP 1

Execute the following SQL Select Query to Project Server Published database

USE PROJECTSERVER_PUBLISHED
SELECT MSP_PROJECTS.PROJ_NAME, MSP_ASSIGNMENTS_SAVED.TASK_NAME,
MSP_RESOURCES.RES_NAME, MSP_ASSIGNMENTS_SAVED.ASSN_UID,
MSP_ASSIGNMENTS_SAVED.PROJ_UID,
MSP_ASSIGNMENTS_SAVED.TASK_UID, MSP_ASSIGNMENTS_SAVED.RES_UID
FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
MSP_PROJECTS.PROJ_UID INNER JOIN
MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
MSP_RESOURCES.RES_UID
WHERE (NOT EXISTS
(SELECT TASK_UID FROM MSP_TASKS_SAVED WHERE (TASK_UID =
MSP_ASSIGNMENTS_SAVED.TASK_UID)))

STEP 2

Open the project mentioned in column 1 of the query result

Lookup the project in the Gantt View and insert the column Publish

Now adjust the Publish value of the relevant Task (2nd column from the query
result) to No.

Choose File->Publish (and wait until the publish action has fully succeeded)

Repeat this but then with a value 'yes' in the Publish column
--
Frank Jutte
frank...@winvision.nl
f.j...@orange.nl