User cannot access TimeSheet

[ziwez0]

Is it me or is Project Server so buggy.....

anyhow

I have a user who has been updating his timesheet fine until
yesterday, he clicks on his timesheet and gets Unknown Error, this
happens on all the existing timesheets he has submitted.

any ideas>?

thanks

 

[ziwez0]

Found out bit more, he can access some of his timesheets, but when he
clicks on the current and 2 older ones,
comes up with An unexpected error has occured.

when I gointo Web parts its shows timesheet, i have reset with no
luck, should I delete??? or will this actually delete the page it self?

 

[JennPenn07]

Don't delete it from webparts, it will delete it from that page. You could
have the user delete the problem timesheet then recreate it if your
environment allows resources to to this.

 

[Seth Gillespie]

We had webpart issues like you describe, even after SP2 + April CU -
the only way to get rid of them is to find the offending tasks in the
corrupted project plans and delete them or set publish = no for these
tasks.

Regards,

 

[ziwez0]

Thanks for the reply, how do I know which are the offending Tasks?

 

[ziwez0]

Anyone?

 

[Gary Chefetz]

If this is, in fact, a regression error as someone has suggested, then you
might identify the tasks with the SQL at this FAQ:
http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/Unknown Error My Tasks Page.aspx

You might also try removing the user from their current security groups,
save the user, then add the user back to the security groups.

 

[ziwez0]

Ive ran the query
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)))

with no results returned.
Ive then removed the user from team memeber security group then re
added.

still no change.

next?

 

[Gary Chefetz]

How about deleting the problem timesheets and recreating them?

 

[ziwez0]

How can I delete only 1 persons timesheet? - only 1 person is affected.