User Can't See Task Page

[Gregg Richie]

PS 2007, MSP 2007 Pro, IE 7

The gremlins seem to keep coming...

I have a user that can no longer see his task page in PWA. He gets the
following error message:

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 happens to also be one of the systems that had the active x control go
belly up and I cannot seem to get it functioning again (see my next posting
for today).

For the task problem, I double checked to ensure he was logged on correctly
and verified that no one has messed with his permissions.


Gregg D. Richie
Engineering Project Manager
LeRoy Surveyors & Engineers, Inc.

 

[Marc Soester [MVP]]

Hi Gregg,

I have experienced the same in the past and believe it is a known issue. you
will need to find out on what task the resource has been assinged to latetly
and will need to take him/her of the task(s).

He/She was more then likely assinged to a task which had existing resources
that already entered time againt the task. I know that this is a nasty issue
and so far this is the only way how I was able to solve it.

Let me know how yo go

 

[Gregg Richie]

Marc,

Trying to find a little known species of fish in the Pacific Ocean would be
an easier task! We have over 120 projects totaling some 50,000 individual
activities. This particular individual several hundred of those activities
assigned.

Although I have seen stranger things happen with MS products, I cannot
imagine that something as simple as deleting a task or a deleting a resource
from a task would have this type of effect, especially since we are not using
the timecard functionality of Project Server.

Thanks for the information though.

Gregg D. Richie
Engineering Project Manager
LeRoy Surveyors & Engineers, Inc.

 

[James Fraser]

Marc,

Trying to find a little known species of fish in the Pacific Ocean would be
an easier task! We have over 120 projects totaling some 50,000 individual
activities. This particular individual several hundred of those activities
assigned.

Although I have seen stranger things happen with MS products, I cannot
imagine that something as simple as deleting a task or a deleting a resource
from a task would have this type of effect, especially since we are not using
the timecard functionality of Project Server.

I will echo the advice Marc gave. I have seen many instances of a
corrupt task causing the SharePoint errors for the particular user's
My Task page. In some cases this was tracked down to an assignment to
a summary task, other times other apparently corrupt assignments. The
following query might help to track down the corrupt assignment. It
has helped on some of the instances I have seen but not on others:

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

 

[James Fraser]

... The
following query might help to track down the corrupt assignment. It
has helped on some of the instances I have seen but not on others:

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

I should have added that this query needs to be run against the
published database.


James Fraser

 

[Gary L. Chefetz [MVP]]

Greg:

You really can't believe that Microsoft releases software containing bugs?
SP1 is right around the corner.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Marc Soester [MVP]]

Yes Greg, you would believe that some things just work, but sometimes it just
happens that this is not the case. I will try the sql queries to see how they
work.
--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com