Project Server 2007 Timesheet web part error

[Joseph Cook]

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
Creating a WPF Application Using MVVM Pattern
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/creating-a-wpf-applicatio.aspx

 

[Joseph Cook]

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
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx

 

[Joseph Cook]

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
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx

 

[Gary Chefetz]

Thanks for sharing your solution Joseph.

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
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx

 

[Dale Howard [MVP]]

Joseph --

You are The Man! Thank you for taking the time to fully troubleshoot this
problem and to post the solution so that we can all learn from you!

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
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx