Thanks for the response jbfraser.
I wound up enabling stacktrace and turning off custom errors in the web.config file, which gave me a better error message. Here was the message:
[InvalidCastException: Specified cast is not valid.]
Microsoft.Office.Project.P
Microsoft.Office.Project.P
System.Web.UI.Control.Load
System.Web.UI.Control.Load
System.Web.UI.Control.Load
System.Web.UI.Control.Load
System.Web.UI.Control.Load
System.Web.UI.Control.Load
System.Web.UI.Page.Process
As it turned out, there were a few assignments that had null assn_start_date and assn_finish_date. I used this query to find them:
select a.assn_uid, a.proj_uid, a.task_uid, p.proj_name, t.task_name, a.assn_start_date, a.assn_finish_date, t.task_start_date, t.task_finish_date
from dbo.msp_projects as p inner join dbo.msp_assignments as a
on p.proj_uid = a.proj_uid inner join dbo.msp_tasks as t
on a.task_uid = t.task_uid
where assn_start_date is null
Once I got a list of projects, I opened each project and published (they had start/finish dates for each of the tasks), and the dates updated in the assignments table. Once that was done, I was able to open the problem timesheets.
Main Topics
Browse All Topics
by: jbfraserPosted on 2009-09-22 at 18:40:05ID: 25399412
A few thoughts:
1. You should start a case with Microsoft Support, especially if this issue has a fix coming out in the December CU. The support team will try to reproduce the problem, and may be able to give you specifics on causes and how to avoid it. They may also be able to test upcoming fixes before they go public. If the problem is determined to be a bug (which an "unexpected error" will almost certainly be, unless you've been doing funky things to the server) then the charges for support will be refunded.
2. I haven't run into this problem with several server instances and several thousand users running SP2 and the April CU.
3. Sometimes Timesheet errors are caused by a problematic/corrupt assignment. Do the affected users have any tasks in common?
4. The details of the error should be logged to the "Unified Logging Service (ULS)." Search on "SharePoint ULS" for details on how to enable these logs and look through them. Be careful, many options for using these can consume disk space quickly, so you need to watch disk space and set the settings back to their defaults.
I know theses don't give you a direct answewr, but hopefully they give you some directions to continue...
James Fraser
Hoper these help...