Cascade Skyline - with Microsoft Logo and Project Support header - author Brian Smith

Project Server 2010: Applied August CU and having problems with JSGrid?

Project Server 2010: Applied August CU and having problems with JSGrid?

  • Comments 13

Thanks to Donald for his forum posting and Marius for his swift response highlighting the resolution to this one.  If you have loaded the August CU for Project Server 2010 – KB 2276341, but have not loaded either the SharePoint Foundation 2010 August CU (KB 2266423), or any of the rollup packages (KB 2352346, KB 2352342 or KB 2352345) then you will get an error loading the schedule web part and drilling down into a project - or other pages that us the JSGrid.  The error will be this one: “The view failed to load.  Press OK to reload this view with the default settings.  Press Cancel to select another view.”  Neither will resolve the problem.

image

As there can be many other potential reasons for this error you should also check the ULS logs – and confirmation of this problem is seeing this error:

  • w3wp.exe (0x14D8)                           0x11C0    Project Server                    General                           0000    Exception    Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.Project.ProjectGetProjectDetailsForGridJson System.MissingMethodException: Method not found: 'Void Microsoft.SharePoint.JSGrid.GridSerializer.ApplyPostViewIncrementalInsertsAndDeletes(System.Collections.Generic.IEnumerable`1<Microsoft.SharePoint.JSGrid.Change>, System.Func`2<System.Object,System.Collections.Generic.Dictionary`2<System.String,System.Object>>)'.     at Microsoft.Office.Project.Server.BusinessLayer.Project.GetProjectDetailsForGridJson(JsGridSerializerArguments gridSerializerArgs, Guid projUid, Guid[] subProjUids, Int32 storeId, String changesJson, String postViewInsertsAndDeletesJson, Boolean firstTaskViewLoad, Boolean showProjectSummaryTask, Guid viewUid, Nullable`1 expandSubprojects, Boolean clearPer...   

The resolution is to load one of the August CUs that contains sts-x-none.msp, which would be any of the following.

Although JSGrid is a component initially developed for Project Server 2010 it was shared with other teams for the “14” release and is also used by Access Services.  It is shipped as part of SharePoint Foundation, and this is where we slipped up in not also having the fix in the Project Server CU too.  Apologies for any inconvenience this may have caused, and we will ensure with future CUs that this dependency will be avoided. 

Technorati Tags: ,
Leave a Comment
  • Please add 1 and 5 and type the answer here:
  • Post
  • Hey Brian,

    Area there any further updates on this.  I've done the CU update from August and I'm having this same problem in the approval center on just some of my plans.  The plans that are just plain vanillia views it seems to work fine but others that have some unique text fields it pushes this error out.  Does this have anything to do with what table is being used when you publish this from project pro?  If you have any further updates/ideas on this one please let me know.

    Thanks!

  • Hi Brian,

    I have a similar problem. The environment is with all updates (Hotfix, CU and SP). Can you help me?

    Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.Project.ProjectGetProjectDetailsForGridJson System.InvalidOperationException: There was a cycle in the hierarchy of nodes: either a node with its parent set to itself or multi-level cycle.

    Full Log

    5/22/2012 16:05:27.30 w3wp.exe (0x1048)                       0x2708 Project Server                 General                       0000 Exception Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.Project.ProjectGetProjectDetailsForGridJson System.InvalidOperationException: There was a cycle in the hierarchy of nodes: either a node with its parent set to itself or multi-level cycle.     at Microsoft.SharePoint.JSGrid.GridSerializer.CompleteHierarchyProvider`1.GetOutlineLevel(T key)     at Microsoft.SharePoint.JSGrid.GridSerializer.HierarchySet.<PopulateOutlineLevels>b__b4(HierarchyNode node, Int32 outlineLevel)     at Microsoft.SharePoint.JSGrid.GridSerializer.HierarchySet.ForEachNode(HierarchyNodeFunction nodeFn, HierarchyNodeListFunction nodesFn, HierarchyNodePredicate pred, IList`1 nodes, Int32 outlineLevel)     at Microsoft.SharePoint.JSGrid.GridSerializer.HierarchySet.ForEachNode(HierarchyNodeFunction no... 09f4327e-a319-4d52-a915-1774ba6ab831

    05/22/2012 16:05:27.30* w3wp.exe (0x1048)                       0x2708 Project Server                 General                       0000 Exception ...deFn, HierarchyNodeListFunction nodesFn, HierarchyNodePredicate pred, IList`1 nodes, Int32 outlineLevel)     at Microsoft.SharePoint.JSGrid.GridSerializer.HierarchySet.ForEachNode(HierarchyNodeFunction nodeFn, HierarchyNodeListFunction nodesFn, HierarchyNodePredicate pred, IList`1 nodes, Int32 outlineLevel)     at Microsoft.SharePoint.JSGrid.GridSerializer.HierarchySet.PopulateOutlineLevels()     at Microsoft.SharePoint.JSGrid.GridSerializer.HierarchySet.Init()     at Microsoft.SharePoint.JSGrid.GridSerializer.ExpandRows(IEnumerable`1 unfilteredRows, IEnumerable`1 filteredRows, Boolean onlyMakingAutoFilterEntries, HierarchySet& hierarchySet)     at Microsoft.SharePoint.JSGrid.GridSerializer.<>c__DisplayClass7e.<ComputeAutoFilterEntries>b__77(String columnKey)     at System.Linq.Enumerable.... 09f4327e-a319-4d52-a915-1774ba6ab831

    05/22/2012 16:05:27.30* w3wp.exe (0x1048)                       0x2708 Project Server                 General                       0000 Exception ...ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)     at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector)     at Microsoft.SharePoint.JSGrid.GridSerializer.ComputeAutoFilterEntries(IEnumerable`1 unfilteredRows, IEnumerable`1 partiallyFilteredRows)     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.Utility.JsGridPopulationManager.SerializeWithCompressedGuids(Serializer baseSerializer, Object toSerialize)     at Microsoft.Office.Project.S... 09f4327e-a319-4d52-a915-1774ba6ab831

    05/22/2012 16:05:27.30* w3wp.exe (0x1048)                       0x2708 Project Server                 General                       0000 Exception ...erver.BusinessLayer.Project.GetProjectDetailsForGridJson(JsGridSerializerArguments gridSerializerArgs, Guid projUid, Guid[] subProjUids, Int32 storeId, String changesJson, String postViewInsertsAndDeletesJson, Boolean firstTaskViewLoad, Boolean showProjectSummaryTask, Guid viewUid, Nullable`1 expandSubprojects, Boolean clearPersistedProperties)     at Microsoft.Office.Project.Server.Wcf.Implementation.PWAImpl.ProjectGetProjectDetailsForGridJson(JsGridSerializerArguments gridSerializerArgs, Guid projUid, Guid[] subProjUids, Int32 storeId, String changesJson, String postViewInsertsAndDeletesJson, Boolean firstTaskViewLoad, Boolean showProjectSummaryTask, Guid viewUid, Nullable`1 expandSubprojects, Boolean clearPersistedProperties) 09f4327e-a319-4d52-a915-1774ba6ab831

    05/22/2012 16:05:27.30 w3wp.exe (0x1048)                       0x2708 Project Server                 Unified Logging Service       c91s Monitorable Watson bucket parameters: Microsoft Project Server 2010, ULSException14, 070f6ea0 "project server", 0e00178d "14.0.6029.0", 1f65804a "microsoft.sharepoint", 0e0017e5 "14.0.6117.0", 4f4def78 "wed feb 29 06:27:20 2012", 000070e3 "000070e3", 0000008a "0000008a", 54e7243f "invalidoperationexception", 30303030 "0000" 09f4327e-a319-4d52-a915-1774ba6ab831

  • Hi Diego, I haven't seen that error before, and couldn't find a record of it in other cases.  It sounds like it refers to a circulr reference in a project.  Does the project open OK in Project Professional?  I am assuming from the error that this occurs when drilling down, and not just in the Project Center view listing all the plans?  If it looks OK in Pro then you might try publishing again.

    Best regards,

    Brian.

  • Brian, i'm sorry for resurrecting this post, but, how can we simulate that error message?

    I want to generate this error at the QA environment, apply the updates and thry again.

    Could you help me out?

    Regards,

    Mike

  • Hi Maicco - for this very specific occurrence of that error message you should never be in a position to see it.  This was a problem in the very early days of 2010 - and the August 2010 CU - when we didn't have the contents of the Cumulative Updates sorted out correctly.

    Not sure I understand the purpose of doing anything with such an old CU when we'd expect you to be at least at SP1 (around June 2011).

    Best regards,

    Brian.

  • Perfect - I had that "View Failure" error, ran the 2352345 hotfix in your list, now works fine.

    Thanks very much

  • One thing I have found on this error was we had Single Entry Mode turned on AND were using manually scheduled tasks (as a test to show the functional group that manually scheduling isn't what they wanted).

    You either have to turn off single entry mode, or get rid of manually scheduled tasks.

  • Hello Brian,

    currently we are recovering from a disaster were the HDDs were burned...

    and was used about a 1 year old db backup, and don't know for sure which DBs

    anyway, the person whom recovered this have installed the CU of Feb 2011, and Sp1.

    for some users, this error message “The view failed to load..." is shown for their timesheets,

    however I don't see the error you mentioned in the ULS Log.

    and I'm working on patching the server with the CUs and Sp2 to the latest CUs.

    I was planning on starting from the CUs that were announced after SP1, starting from June 2011.

    and I'm seeing here you suggesting using the CUs of August 2010.

    so, do you think I would be needing to install these first?, or go ahead with CUs announced after the SP1

    and thanks in advance

  • HI Hany, the Cumulative Updates are cumulative, so you can just load the Service Pack and the latest one - which for 2010 was in June 2014.  The error could be due to something other than that mentioned in the blog - so if you still have issues I'd suggest opening a support incident so we can help track down the issue.  Sorry to hear about your bad HDD problems too.

    Brian.

  • Thanks Brian for your reply...

    anyway, i've already installed the SP2, the package for the Sharepoint and project server 2010.

    and no, that didn't solve it, so i've had another look to the ULS on both servers (moss and Prjsrv).

    i've fired the error and went into the server for logs, and i've found in the Prjsrv server logs, the following 3 entries, and I understand that it is related to an issue with the project, if u have further suggestions would be much appreciated:

    1- 08/15/2014 22:41:06.84 w3wp.exe (0x1804) 0x118C Project Server Task Statusing and Updates btw9 High CacheProjectBaseCalendars: could not locate data for calendar CalGUID for project ProjGUID AnotherGUID

    2- 08/15/2014 22:41:06.84 w3wp.exe (0x1804) 0x118C Project Server General 0000 Exception Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.TimeSheetGetTimesheetForGridJsonFromViewUid System.InvalidOperationException: CacheProjectBaseCalendars could not find project calendar for project. CalUid=GUID

       at Microsoft.Office.Project.Server.BusinessLayer.TimePhasedDataAccess.CacheProjectBaseCalendars()

       at Microsoft.Office.Project.Server.BusinessLayer.TimePhasedDataAccess..ctor(StatusingPageLoadDataSet dataset)

       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.TimeSheetAndStatusingData.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) GUID

    3- 08/15/2014 22:41:06.84 w3wp.exe (0x1804) 0x118C Project Server Unified Logging Service c91s Monitorable Watson bucket parameters: Microsoft Project Server 2010, ULSException14, 070f6ea0 "project server", 0e00178d "14.0.6029.0", 9c2bade2 "microsoft.office.project.server", 0e001bcc "14.0.7116.0", 52cbce05 "tue jan 07 11:51:01 2014", 00003e56 "00003e56", 000000c5 "000000c5", 54e7243f "invalidoperationexception", 30303030 "0000" GUID

  • Hello Again Brian,

    just to follow up with my comments, i've found your other post, where u are solving the errors i sent for the timesheet: blogs.msdn.com/.../project-server-2010-orphan-baselines-breaking-the-reporting-publish.aspx

    so basically, as i've installed the SP2, which should contains the CUs of June 2012, all i need is to:

    1- Clear the MS project client cache.

    2- install the MS Project Sp2.

    3- re-publish the project. and to this step, the error should be fixed.

    and to speed up testing this fix, i can follow the 1st step in your other post to test the existance of the orphan baseline task records that can cause reporting publish job failures

    am i right??

    thank you

  • this Hany Zayed, to follow up again,

    Querying the Draft DB to detect for orphan baseline task records, returned null...

    so i will be waiting for to test with the PM after installing the Client Sp2

  • Hou might be best opening a support case Hany - your first error isn't anything to do with baselines, but calendars.  This should be resolved by opening the Project found from the above GUID using Project Professional, then publish the project.

    Then close and check in the project.

    You should be able to open and create the timesheets successfully. If this doesn't work then open a case.

    Best regards,

    Brian.

Page 1 of 1 (13 items)