PWA "My Tasks" unexpected error.

[beto6971]

We have had Project Server 2007 (SP1) installed for a couple of months and
working happly... until now!!...

One user, out of 9, is now having problems, when trying to open the My Tasks
page it gets:

"An unexpected error has occurred.

Web Parts Maintenance Page: If you have permission, you can use this page to
temporarily close Web Parts or remove personal settings. For more
information, contact your site administrator.
Troubleshoot issues with Windows SharePoint Services. "

When I go to the "Web Part Maintenance Page: tasks" as suggested, I can
Reset it for the specific user, but still doesn´t work.

I think I have discarded a WebPart problem. All other users can open it
without problem, I removed the WebPart and added it again (for all users) and
no change, I exported the WebPart and imported it and still no change.

I guess it could be a data problem with this user's tasks, however, I opened
all projects the user is assigned in, checked them (no obvious problems at
least) saved and publish them again. Still, all users can see their tasks
except this one!.

Any suggestion? Is there a way to check what the heck is PWA looking for in
the database when this happens? Any other idea?....

Help is well appreciated!

 

[Paul Conroy]

I've seen this problem when the user is set as the assignment owner on an
assignment which is assigned to a generic resource.

This also used to happen when additional assignments where added to tasks
which already had actuals entered, however I believe this was resolved in SP1.

This issue is almost certainly related to assignment data. You need
identify which project/assignment is causing the issue and remove it.

Running this script against the published database may help identify the
corrupt assignment

SELECT COUNT(MSP_TASKS_SAVED.TASK_UID) AS CountTasks, MSP_PROJECTS.PROJ_NAME,
MSP_TASKS_SAVED.TASK_NAME, MSP_RESOURCES.RES_NAME
into #MultiAssn
FROM MSP_TASKS_SAVED INNER JOIN
MSP_ASSIGNMENTS_SAVED ON MSP_TASKS_SAVED.PROJ_UID =
MSP_ASSIGNMENTS_SAVED.PROJ_UID AND
MSP_TASKS_SAVED.TASK_UID = MSP_ASSIGNMENTS_SAVED.TASK_UID
INNER JOIN
MSP_PROJECTS ON MSP_TASKS_SAVED.PROJ_UID =
MSP_PROJECTS.PROJ_UID INNER JOIN
MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID_OWNER =
MSP_RESOURCES.RES_UID
where MSP_TASKS_SAVED.TASK_UID=MSP_TASKS_SAVED.TASK_PUBLISHED_UID
GROUP BY MSP_TASKS_SAVED.TASK_UID, MSP_TASKS_SAVED.PROJ_UID,
MSP_PROJECTS.PROJ_NAME, MSP_ASSIGNMENTS_SAVED.RES_UID_OWNER,
MSP_RESOURCES.RES_NAME, MSP_TASKS_SAVED.TASK_NAME
ORDER BY CountTasks DESC
select * from #MultiAssn
where CountTasks > 1
Order by RES_NAME
Drop Table #MultiAssn

HTH

Paul
--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

 

[quyen nguyen]

Hi,
Try the hotfix at: http://support.microsoft.com/kb/950816

GOOD LUCK!
Quyen Nguyen