Error when open My Tasks Page Project Server SP2

[Ahmed Ghaith]

Dear All,

I show the following error when open My Tasks Page:

(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. )



This happened for few resources not all.

I sure this problem not for IE because I was try the user name and password
on my machine and appeared the same error.

We working on project server sp2 and hotfix KB977028 installed for it.

I try the following query but no result:

***
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)))
***

Please I need your advice,

Regards,
Ahmed Ghaith

 

[Barbara - Austria]

Hi Ahmed,

seems that at laest one assignment or task is corrupt. That can have
different reasons and I have no idea how to look for all of them in the
database.

First you could try to force a re-publish of all projects where your
users are member of (insert column 'Publish', change to 'No', publish,
change bach to 'Yes', publish again). One time I saw that to be
sufficient to solve that issue.

If that wasn't successful, you can identify the causing assignment/task
manually, but it will need some steps.

Identify projects were your users are team members. Change booking type
for these users in these projects to proposed and publish project. Do
that one by one with opening 'My Tasks' in between. At the moment that
you don't get the error page you have identified the project causing
your problem. You write, that only a few users have that issue. Are they
working on one project altogether? Then you could start with that one.

Change booking type back to committed for all projects and publish.

Insert column 'Publish' in the identified project, set one by one (or in
package of some tasks ... depending on project size) to 'No'. Publish
your project. Check 'My Tasks' again. At the moment you can open this
page you have found the task causing your error.

Then you need to decide what to do with this task.

Hope you can understand what I have tried to explain? Our customers had
always been successful to solve that issue with that procedure.

Good luck!
Barbara

Am 04.03.2010 17:54, schrieb Ahmed Ghaith:

 

[Ahmed Ghaith]

Thank you Barbara for your description,

I solved my problem by insert column 'Publish' and change to 'No' then
republish again for a common project of few resources.

Thanks again.
,