none
Timesheet Problems RRS feed

  • 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


    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.


    Wednesday, December 11, 2013 1:32 AM
    Moderator

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 queries

    Tuesday, December 10, 2013 8:04 PM
    Moderator
  • 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.


    Wednesday, December 11, 2013 1:32 AM
    Moderator
  • 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=projectserver2010general

    Thanks for any extra information.


    - Dennis | Netherlands | Blog | Twitter

    Tuesday, April 29, 2014 1:02 PM