none
Project Server 2010 Approval Center: An unhandled exception occurred in Microsoft.Office.Project.Server.BusinessLayer.Statusing.StatusingReadStatusApprovalsForProjectForGridJson when one user access to Approval Center RRS feed

  • Question

  • Hi all,

    One user receive an error when he access to "Approval Center":

    An unhandled exception occurred in Microsoft.Office.Project.Server.BusinessLayer.Statusing.StatusingReadStatusApprovalsForProjectForGridJson

    I have detected this error in Project Server Logs:

    Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.Statusing.StatusingReadStatusApprovalsForProjectForGridJson 
    System.ArgumentException: Object must be of type String.     
    at System.Double.CompareTo(Object value)     
    at System.StringComparer.Compare(Object x, Object y)     
    at Microsoft.Office.Project.Server.Utility.PJLocalStringComparer.Compare(Object x, Object y, Boolean strict)     
    at Microsoft.SharePoint.JSGrid.GridField.Compare(Object left, Object right, Boolean strict)     
    at Microsoft.SharePoint.JSGrid.GridSerializer.DataRowComparer`1.Compare(T x, T y)     
    at System.Linq.EnumerableSorter`2.CompareKeys(Int32 index1, Int32 index2)     
    at System.Linq.EnumerableSorter`1.QuickSort(Int32[] map, Int32 left, Int32 right)     
    at System.Linq.EnumerableSorter`1.Sort(TEle.ment[] elements, Int32 count)     
    at System.Linq.OrderedEnumerable`1.<GetEnumerator>d__0.MoveNext()     
    at Microsoft.SharePoint.JSGrid.GridSerializer.GroupedSet..ctor(GridSerializer serializer, IEnumerable`1 unfilteredRows, IEnumerable`1 filteredRows)     
    at Microsoft.SharePoint.JSGrid.GridSerializer.ExpandRows(IEnumerable`1 unfilteredRows, IEnumerable`1 filteredRows, Boolean onlyMakingAutoFilterEntries, HierarchySet& hierarchySet)     
    at Microsoft.SharePoint.JSGrid.GridSerializer.BuildOutput()     
    at Microsoft.SharePoint.JSGrid.GridSerializer.ToJson(Serializer s)     
    at Microsoft.SharePoint.JsonUtilities.Serializer.SerializeToJson(Object o)     
    at Microsoft.Office.Project.Server.BusinessLayer.Statusing.ReadStatusApprovalsForProjectForGridJson(JsGridSerializerArguments gridSerializerArgs, String fromDate, String toDate, Int32 durationFormat, Int32 workFormat)     
    at Microsoft.Office.Project.Server.Wcf.Implementation.PWAImpl.StatusingReadStatusApprovalsForProjectForGridJson(JsGridSerializerArguments gridSerializerArgs, String fromDate, String toDate, Int32 durationFormat, Int32 workFormat)

    I searched orphans projects (https://social.technet.microsoft.com/Forums/en-US/cbca6bac-6199-4707-b2e9-a88573793581/projec-server-2010-error-in-approval-center) and have found none.

    Has anyone had the same issue?

    Thank you in advance and best regards,

    Sunil Kumar G.

    Monday, January 16, 2017 7:51 PM

All replies

  • Hi Sunil,

    It seems to be related to a filter applied to the view. If you have an integrated filter in the view definition, you can remove it from the view and see if it helps.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Tuesday, January 17, 2017 8:31 AM
    Moderator