none
PWA 2010 Can't add a task in a Timesheet RRS feed

  • Question

  • Hello,

     

    We have a Project Server 2010 environment with the SP1 and the June and August CU2011 installed.

     

    We use this environment for more than one year with success, and suddenly one of our users has the following error message when he creates a new timesheet “The Timesheet creation failed, because of problems with the project server or with data validations, such as resources not being valid work resources or users. Check your environment, and try again.” . After a refresh of the page, the timesheet is created but the user can’t add any task in his timesheet. When he tries, he obtains the following error message “The view failed to load. Press Ok to reload this view with the default settings. Press cancel to select another view”.

     

    If he clicks “OK”, the message continues to appear. If he clicks “Cancel” the timesheet seems to be locked.

     

     

    On the server logs, we find the following message: “10/20/2011 15:28:13.74 w3wp.exe (0x1474)                       0x1718  Project Server                   General                                0000                Exception            Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.TimeSheetGetTimesheetForGridJsonFromViewUid System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.     at System.Data.DataSet.EnableConstraints()     at System.Data.DataSet.set_EnforceConstraints(Boolean value)     at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(Boolean allowCache, DataSet typedDataSet, String[] tables, SqlCommand sqlCommand, Boolean enforceConstraints)     at Microsoft.Office.Project.Server.DataAccessLayer.StatusingDal.ReadTimePhasedDataForAssignments(Guid residForSecurity, Guid[] vAssnUids)     at Microsoft.Office.Project.Server.BusinessLayer.Statusing.ReadTimePh...                37e3c3d1-64cc-47b2-a46c-0fc600e77486

    10/20/2011 15:28:13.74*               w3wp.exe (0x1474)                       0x1718  Project Server                   General                                0000                Exception            ...asedDataForAssignments(Guid[] vAssnUids)     at Microsoft.Office.Project.Server.BusinessLayer.Statusing.ReadStatusTimephasedDataForTimesheet(Guid projid, IEnumerable`1 assnids, DateTime start, DateTime end, Int64 intervalInMinutes)     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheets.TimeSheetAndStatusingData.SynchronizeAssignmentsWithLineInformation(TimesheetDataSet ds, ViewOptions viewOptions, DataTable dtAdmin, DataTable dtAssns, DataTable dtTasks, DataTable dtPeriod, DataTable dtCFDefinition, DataTable dtLineClass, Boolean importTasks)     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheets.TimeSheetAndStatusingData.UpdateTimesheetDataSetFromStatusing(TimesheetDataSet ds, ViewOptions viewOptions)     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheets.TimeShe...          37e3c3d1-64cc-47b2-a46c-0fc600e77486

    10/20/2011 15:28:13.74*               w3wp.exe (0x1474)                       0x1718  Project Server                   General                                0000                Exception            ...etAndStatusingData.Load()     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.GetTimesheetForGridJsonFromViewUid(JsGridSerializerArguments gridSerializerArgs, Guid tsUid, Guid viewUid, String changesJson, String viewOptionsJson)     at Microsoft.Office.Project.Server.Wcf.Implementation.PWAImpl.TimeSheetGetTimesheetForGridJsonFromViewUid(JsGridSerializerArguments gridSerializerArgs, Guid tsUid, Guid viewUid, String changesJson, String viewOptionsJson)            37e3c3d1-64cc-47b2-a46c-0fc600e77486

    10/20/2011 15:28:13.74 w3wp.exe (0x1474)                       0x1718  Project Server                   Unified Logging Service                 c91s                Monitorable       Watson bucket parameters: Microsoft Project Server 2010, ULSException14, 070f6ea0 "project server", 0e00178d "14.0.6029.0", ea364808 "system.data", 0200c627 "2.0.50727.0", 4a274a01 "thu jun 04 06:13:53 2009", 0000087d "0000087d", 000000d8 "000000d8", 2fb64168 "constraintexception", 30303030 "0000"  37e3c3d1-64cc-47b2-a46c-0fc600e77486”.

     

    I tried to re-publish all the projects on which the resource is assigned, to delete the unsubmitted timesheet and to re-create it but the problem is still here.

     

    Could you please help on this problem?

     

    Many thanks in advance

     

    Aline B.M.E

    Thursday, October 27, 2011 12:26 PM

Answers

  • Hello everybody,

    We opened a case with Microsoft Premier and the case was resolved. There was a corrumpted task.

    Best regards

    • Marked as answer by Aline B M E Tuesday, November 29, 2011 11:21 AM
    Tuesday, November 29, 2011 11:20 AM

All replies