Project Server 2013 - Status Update History error "General Unhandled Exception in _Statusing.ReadStatusApprovalHistoryForGridJson_" RRS feed

  • Question

  • I have a problem where a user has accepted status updates and then when the user went to the History > Status Updates page to publish the updates the page displayed with the following error:

    General Unhandled Exception in _Statusing.ReadStatusApprovalHistoryForGridJson_

    This is a project server 2013 environment, on-prem, running the July 2015 CU.

    Has anyone seen this before or know a resolution for it?

    Wednesday, January 13, 2016 6:37 PM

All replies

  • Hi Aaron,

    We faced similar issue in 2010 environment. I checked ULS logs and underlying exception was “Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.Statusing.StatusingReadStatusApprovalHistoryForGridJson System.OverflowException: Value was either too large or too small for an Int32”.

    We opened support ticket with microsoft and resolution was to modify the stored proc MSP_WEB_SP_QRY_ReadStatusApprovalHistory in published database to select top N records to get rid of error record. It is limitation and there was no alternate option to fix this issue.

    Hope this helps.


    Vedika Sawant

    Thursday, January 14, 2016 9:48 AM
  • Hi Aaron.

    Could you fix this issue?. I have Project Server 2013 with June 2015 CU and the same message is displayed to a project manager.

    Checking in ULS the exception shows:

    [bucketHash:DF4E3BB8] Exception occured in method 'Statusing.ReadStatusApprovalHistoryForGridJson' System.OverflowException: Value was either too large or too small for an Int32.     at System.Convert.ToInt32(Double value)     at Microsoft.Office.Project.Server.BusinessLayer.Statusing.FixHistoryDataSet(StatusApprovalsRow row, ChangeLog changes)     at Microsoft.Office.Project.Server.BusinessLayer.Statusing.FixHistoryDataSet(StatusApprovalDataSet history, Boolean forGrid)     at Microsoft.Office.Project.Server.BusinessLayer.Statusing.ReadStatusApprovalsHistoryCore(Guid projectID, Guid userID, StatusTransactionState state1, StatusTransactionState state2, Boolean forGrid, Nullable`1 startDate, Nullable`1 endDate)     at Microsoft.Office.Project.Server.BusinessLayer.Statusing.StatusApprovalsHistoryQueryInfo.Query()     at Microsoft.Office.Project.Server.Utility.JsGrid.ProjectGridSerializerPopulator.PopulateSerializer()     at Microsoft.Office.Project.Server.BusinessLayer.Statusing.ReadStatusApprovalHistoryForGridJson(JsGridSerializerArguments gridSerializerArgs, String filter, String fromDate, String toDate)     at Microsoft.Office.Project.Server.Wcf.Implementation.PWAImpl.<>c__DisplayClass1cc.<StatusingReadStatusApprovalHistoryForGridJson>b__1cb()     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=ad0ca0fd-3c62-4564-9144-b6fd1f587187|2|, offset=3C16) at Microsoft.Office.Project.Server.Native.dll: (offset=1265D)

    Thank you for your help.

    Monday, January 9, 2017 9:32 PM