Answered by:
Timesheet Problems

Question
-
Hello,
We have installed Project Server 2013, and since the beginning when someone try to access to their old timesheets it occurs the following problem "The view failed to load. Press Ok to reload this view with default settings. Press Cancel to select another view" but not in every timesheet.
One of the problems to it occur its having some deleted task in those timesheets (checked by me), but not everytime is due to it.
Today i checked better the ULS Logs and I have seen this error:
12/10/2013 14:41:37.67 w3wp.exe (0x16D0) 0x06F0 Project Server General aeby7 Exception [bucketHash:F7E90F55] Exception occured in method 'TimeSheet.GetTimesheetForGridJsonFromViewUid' System.InvalidOperationException: GetDataForAssignment: Did not find data for assignment. ProjUid=ce36bfcc-0717-e311-b7af-dc85de920b86 AssnUid=0ab8a40d-0446-e311-8ba3-dc85de920b86 at Microsoft.Office.Project.Server.BusinessLayer.TimePhasedDataAccess.GetDataForAssignment(Guid docGuid, Guid guidAssn) at Microsoft.Office.Project.DataEdit.Assignments.AssnCntr.LoadAssnData(ISvrDataAccess dataAccess, Guid docGuid, Guid assnGuid) at Microsoft.Office.Project.DataEdit.Assignments.AssnCntr.LoadNode(Guid guid) at Microsoft.Office.Project.DataEdit.Assignments.AssnCntr.FindAssnNode(Guid guid) at Microsoft.Office.Project.Server.BusinessLayer.Statusing.<>c__DisplayClass43.<ReadStatusTimeph... 19f25e9c-ceae-90be-94f4-aa43a775c366
12/10/2013 14:41:37.67* w3wp.exe (0x16D0) 0x06F0 Project Server General aeby7 Exception ...asedDataForTimesheet>b__41(KeyValuePair`2 projAssn) at Microsoft.Office.Project.Server.Library.PSUtility.Apply[T](IEnumerable`1 enumerable, Action`1 fn) at Microsoft.Office.Project.Server.BusinessLayer.Statusing.ReadStatusTimephasedDataForTimesheet(IDictionary`2 projAssignments, DateTime start, DateTime end, Int64 intervalInMinutes) at Microsoft.Office.Project.Server.BusinessLayer.Timesheet.ImportActuals(ISet`1 assignmentUids, ISet`1 userImported, Boolean acceptChanges) at Microsoft.Office.Project.Server.BusinessLayer.Timesheet.ImportActualsAndCustomFields(IEnumerable`1 assignmentUids, ISet`1 userImported) at Microsoft.Office.Project.Server.BusinessLayer.TimesheetLoaderForGrid.Load() at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.GetTimesheetForGridJsonF... 19f25e9c-ceae-90be-94f4-aa43a775c366
12/10/2013 14:41:37.67* w3wp.exe (0x16D0) 0x06F0 Project Server General aeby7 Exception ...romViewUid(JsGridSerializerArguments gridSerializerArgs, Guid tsUid, Guid viewUid, String changesJson, String viewOptionsJson) at Microsoft.Office.Project.Server.Wcf.Implementation.PWAImpl.<>c__DisplayClass2f5.<TimeSheetGetTimesheetForGridJsonFromViewUid>b__2f4() at Microsoft.Office.Project.Server.Wcf.Implementation.WcfMethodInvocation.InvokeBusinessObjectMethod(String businessObjectName, String methodName, IEnumerable`1 actions) StackTrace: at Microsoft.Office.Project.Server.Native.dll: (sig=85ae470f-554c-4a8c-992e-92aeb657c829|2|microsoft.office.project.server.native.pdb, offset=3C1E) at Microsoft.Office.Project.Server.Native.dll: (offset=1255D) 19f25e9c-ceae-90be-94f4-aa43a775c366
12/10/2013 14:41:37.67 w3wp.exe (0x16D0) 0x06F0 Project Server Unified Logging Service c91s Monitorable Watson bucket parameters: Microsoft Project Server 2013, ULSException14, 070f6ea0 "project server", 0f001181 "15.0.4481.0", 9c2bade2 "microsoft.office.project.server", 0f001199 "15.0.4505.0", 51481b12 "tue mar 19 08:00:18 2013", 00004817 "00004817", 00000047 "00000047", 54e7243f "invalidoperationexception", 00101621 "aeby7" 19f25e9c-ceae-90be-94f4-aa43a775c366
12/10/2013 14:41:37.67 w3wp.exe (0x16D0) 0x06F0 Project Server General aeby8 Medium Error is: GeneralUnhandledException. Details: General Unhandled Exception in _TimeSheet.GetTimesheetForGridJsonFromViewUid_ Attributes: System.InvalidOperationException: GetDataForAssignment: Did not find data for assignment. ProjUid=ce36bfcc-0717-e311-b7af-dc85de920b86 AssnUid=0ab8a40d-0446-e311-8ba3-dc85de920b86 at Microsoft.Office.Project.Server.BusinessLayer.TimePhasedDataAccess.GetDataForAssignment(Guid docGuid, Guid guidAssn) at Microsoft.Office.Project.DataEdit.Assignments.AssnCntr.LoadAssnData(ISvrDataAccess dataAccess, Guid docGuid, Guid assnGuid) at Microsoft.Office.Project.DataEdit.Assignments.AssnCntr.LoadNode(Guid guid) at Microsoft.Office.Project.DataEdit.Assignments.AssnCntr.FindAssnNode(Guid guid) at Microsoft.Office.Project.Server.BusinessLayer.Statusi... 19f25e9c-ceae-90be-94f4-aa43a775c366
12/10/2013 14:41:37.67* w3wp.exe (0x16D0) 0x06F0 Project Server General aeby8 Medium ...ng.<>c__DisplayClass43.<ReadStatusTimephasedDataForTimesheet>b__41(KeyValuePair`2 projAssn) at Microsoft.Office.Project.Server.Library.PSUtility.Apply[T](IEnumerable`1 enumerable, Action`1 fn) at Microsoft.Office.Project.Server.BusinessLayer.Statusing.ReadStatusTimephasedDataForTimesheet(IDictionary`2 projAssignments, DateTime start, DateTime end, Int64 intervalInMinutes) at Microsoft.Office.Project.Server.BusinessLayer.Timesheet.ImportActuals(ISet`1 assignmentUids, ISet`1 userImported, Boolean acceptChanges) at Microsoft.Office.Project.Server.BusinessLayer.Timesheet.ImportActualsAndCustomFields(IEnumerable`1 assignmentUids, ISet`1 userImported) at Microsoft.Office.Project.Server.BusinessLayer.TimesheetLoaderForGrid.Load() at Microsoft.Office.Project.Server.Business... 19f25e9c-ceae-90be-94f4-aa43a775c366
12/10/2013 14:41:37.67* w3wp.exe (0x16D0) 0x06F0 Project Server General aeby8 Medium ...Layer.TimeSheet.GetTimesheetForGridJsonFromViewUid(JsGridSerializerArguments gridSerializerArgs, Guid tsUid, Guid viewUid, String changesJson, String viewOptionsJson) at Microsoft.Office.Project.Server.Wcf.Implementation.PWAImpl.<>c__DisplayClass2f5.<TimeSheetGetTimesheetForGridJsonFromViewUid>b__2f4() at Microsoft.Office.Project.Server.Wcf.Implementation.WcfMethodInvocation.InvokeBusinessObjectMethod(String businessObjectName, String methodName, IEnumerable`1 actions) . Standard Information: PSI Entry Point: Project User: i:0#.w|domain\user Correlation Id: deba642a-a961-e311-93ff-00155d1e2127 PWA Site URL: http://portal/PWA SA Name: ProjectWebApp PSError: GeneralUnhandledException (42), LogLevelManager Warning-ulsID:0x00101622 has no entities explicitly speci... 19f25e9c-ceae-90be-94f4-aa43a775c366
12/10/2013 14:41:37.67* w3wp.exe (0x16D0) 0x06F0 Project Server General aeby8 Medium ...fied. 19f25e9c-ceae-90be-94f4-aa43a775c366
To solve that error I disabled Single Entry Mode from server, and problem seems fixed but this is not a solution since SEM its needed for dailly work. Someone can say me what could going wrong? Since i dont have more ideas about whats happening, and yes server is full patched atm.
Regards
- Edited by Andre Filipe C Tuesday, December 10, 2013 5:34 PM
Tuesday, December 10, 2013 5:29 PM
Answers
-
This can come up if the timesheet contains one or more missing assignments or the task for that assignment was deleted form the project plan, or possibly the resource was unassigned and then re-assigned causing the assignment_uid to change and it no longer matches the assignment_uid in the timesheet.
In case the issue is only for one user then you can ask him to recall, delete and recreate his Timesheets but if the issue has spread across multiple users then I would suggest that you raise a support ticket with Microsoft to help identify the list of affected users and fix their Timesheet issue.
Cheers! Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management
Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can be beneficial to other community members reading the thread.
- Edited by Dinesh S. RaiMicrosoft employee Wednesday, December 11, 2013 1:32 AM
- Proposed as answer by Dinesh S. RaiMicrosoft employee Wednesday, December 11, 2013 1:32 AM
- Marked as answer by Andre Filipe C Wednesday, December 11, 2013 9:46 AM
Wednesday, December 11, 2013 1:32 AM
All replies
-
Hi,
1.Have you modified the View?
2.Timesheet has been approved then task got deleted?
kirtesh
- Edited by Kirteshtiw Tuesday, December 10, 2013 5:37 PM
Tuesday, December 10, 2013 5:36 PM -
Hi Kirteshtiw,
1. The view remains default.
2. As said some of timesheets problems were due that problem, after timesheet a project manager deleted some taks.
But others timesheets had the same problem and they hadnt deleted timesheets.
I know I can recall and delete the timesheets and recreate them again but doing it every is annoying since I have to repair all organization timesheets.
Best regards
Tuesday, December 10, 2013 5:46 PM -
Have you upgraded your farm with latest Cu.
as Apr Cu is consisting resolution for this issue. Hot fix is also available please check below link
http://support.microsoft.com/kb/2760261/en-us
kirtesh
Tuesday, December 10, 2013 5:57 PM -
hi,
The last one I have installed here it was http://support.microsoft.com/kb/2737990/en-us so I suppose it haves that.
I thought I had installed october CU in production.
Regards
Tuesday, December 10, 2013 6:09 PM -
Please install latest oct cu it will certainly resolve the issue.
kirtesh
Tuesday, December 10, 2013 6:14 PM -
When that issue occurs to me, I just recall and delete the timesheet and recreate. It's messy, but it gets rid of the error message.
Cheers!
Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
Website http://www.WhartonComputer.com
Blog http://MyProjectExpert.com contains my field notes and SQL queriesTuesday, December 10, 2013 8:04 PM -
This can come up if the timesheet contains one or more missing assignments or the task for that assignment was deleted form the project plan, or possibly the resource was unassigned and then re-assigned causing the assignment_uid to change and it no longer matches the assignment_uid in the timesheet.
In case the issue is only for one user then you can ask him to recall, delete and recreate his Timesheets but if the issue has spread across multiple users then I would suggest that you raise a support ticket with Microsoft to help identify the list of affected users and fix their Timesheet issue.
Cheers! Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management
Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can be beneficial to other community members reading the thread.
- Edited by Dinesh S. RaiMicrosoft employee Wednesday, December 11, 2013 1:32 AM
- Proposed as answer by Dinesh S. RaiMicrosoft employee Wednesday, December 11, 2013 1:32 AM
- Marked as answer by Andre Filipe C Wednesday, December 11, 2013 9:46 AM
Wednesday, December 11, 2013 1:32 AM -
Thanks for everyone for your support.
It occurs just to members of one project, I will speak with project managers to understand if it was what you said.
In last case will open the support ticket.
Regards
Wednesday, December 11, 2013 9:49 AM -
Hello Andre Fillipe C,
Have you opened a support ticket? Got any news on your situation?
I got the same thing also described in this thread:
http://social.msdn.microsoft.com/Forums/en-US/77d52bf3-aa53-49bd-8b6d-2a90d6a65171/errors-with-timesheet-approvals-after-unpublishing-or-deleting-tasks?forum=projectserver2010generalThanks for any extra information.
Tuesday, April 29, 2014 1:02 PM