Reply to thread

Message: [QUOTE="Joseph Cook, post: 5008192"] 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.PWA.WebParts.TimesheetPart.LoadTimesheetData(GetTSDataModeEnum LoadingMode, Guid resUID, Guid prdUID, Navigation ps) +11592 Microsoft.Office.Project.PWA.WebParts.TimesheetPart.OnLoad(EventArgs e) +1825 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436 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. Joseph Cook wrote: Project Server 2007 Timesheet web part error 22-Sep-09 Hello, I just recently applied SP2 and the August CU for Project Server 2007. Now I have a handful of users who get the following error when trying to access a saved timesheet or create a timesheet: 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. If I go to the web parts maintenance page, I can delete the shared Timesheet web part, then go in (even as the user in question - i made them an administrator on my test box just to test/troubleshoot) to the timesheet page, add the timesheet web part (at this point it opens fine), then exit the web part edit mode. When I try to go back into a timesheet I get the same error. Again, just seems to be a problem for a few select users. I found one post that said this is a known problem w/ SP2 and those that use the Timesheet functionality, and that MS is working on a fix but won't be available publicly until the December CU. Has anyone heard anything about this, or have any suggestions/workarounds? Thanks Joseph EggHeadCafe - Software Developer Portal of Choice WPF And The Model View View Model Pattern [URL]http://www.eggheadcafe.com/tutorials/aspnet/ec832ac7-6e4c-4ea8-81ab-7374d3da3425/wpf-and-the-model-view-vi.aspx[/URL] [/QUOTE]

Verification