none
View Failure on Timesheet page after SP1 and October 2011 CU RRS feed

Answers

All replies

  • Hi,

    What error do you see in the ULS logs when the view fails to load? Are you running in SEM?

    The error mentioned in Brian's post is around the schedule web part, but I am experiencing a similar issue with a customer on the timesheet page also and am keen to see if there are any similarities?

     


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Thursday, November 10, 2011 10:27 AM
    Moderator
  • Hi there,

    As Brian mentioned "The resolution is to load one of the August CUs that contains sts-x-none.msp, which would be any of the following." & Listed Aug CUs. probably, SharePoint Foundation 2010 Cumulative Update should be good.
    http://support.microsoft.com/kb/2352346
    File name           File version          File size            Date Time               Platform
    Sts-x-none.msp  Not Applicable     20,525,056      12-Aug-2010 23:28 Not Applicable


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Thursday, November 10, 2011 10:37 AM
  • Thanks for your reply, Amit!

    When we updated the system with the October 2011 CU (after the SP1 was installed) it also included the update of SharePoint Foundation 2010, this one http://support.microsoft.com/kb/2596484. This CU include an updated version of the sts-x-none.msp:

    Due to that this is a CU, I assume that the content in the CU you describe (12-Aug 2010) is included in the CU almost one year after!

    Best regards,

    Per

    Thursday, November 10, 2011 1:24 PM
  • Hello Alexander,

    We switched on additonal logg function and this is what the ULS logg says:

    --------------------------------------------------------------

    MSP_WEB_SP_QRY_ReadTimeSheetAssignmentsAndCustomFieldData). Execution Time=286.65486814665                             16626d7b-7602-4a26-b4b3-a39636f0bb1d

    11/10/2011 15:20:10.41            w3wp.exe (0x1084)                                               0x1960               Project Server                                             Timesheet                                    ei5f                     Verbose            PWA:http://hbg-epm/PWA, ServiceApp:Project Server, User:Nisse, PSI: Start UpdateTimesheetDataSetFromStatusing                             16626d7b-7602-4a26-b4b3-a39636f0bb1d

    11/10/2011 15:20:10.68            w3wp.exe (0x1084)                                               0x1960               Project Server                                             Timesheet                                    ei5g                     Verbose            PWA:http://hbg-epm/PWA, ServiceApp:Project Server, User:Nisse, PSI: End UpdateTimesheetDataSetFromStatusing  16626d7b-7602-4a26-b4b3-a39636f0bb1d

    11/10/2011 15:20:10.88            w3wp.exe (0x1084)                                               0x1960               Project Server                                             Timesheet                                    d8jv                    Verbose            PWA:http://hbg-epm/PWA, ServiceApp:Project Server, User:Nisse, PSI: End GetTimesheetForGridJsonFromViewUid for tsUid='b19e6062-8f39-4345-a384-95a8f06bade0'.                           16626d7b-7602-4a26-b4b3-a39636f0bb1d

    11/10/2011 15:20:10.88            w3wp.exe (0x1084)                                               0x1960               Project Server                             General                                                    0000                    Exception         Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.TimeSheetGetTimesheetForGridJsonFromViewUid System.InvalidCastException: Cannot cast DBNull.Value to type 'System.Decimal'. Please use a nullable type.     at System.Data.DataRowExtensions.UnboxT`1.ValueField(Object value)     at System.Data.DataRowExtensions.Field[T](DataRow row, String columnName)     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.<GetTimesheetForGridJsonFromViewUid>b__52(DataRow row)     at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()     at Microsoft.SharePoint.JsonUtilities.Serializer.SerializeToJson(IEnumerable enmbl)     at Microsoft.SharePoint.JsonUtilities.Serializer.SerializeToJson(Object o)     at Microsoft.SharePoint.JsonUtilities.Serializer.Wri...               16626d7b-7602-4a26-b4b3-a39636f0bb1d

    11/10/2011 15:20:10.88*         w3wp.exe (0x1084)                                               0x1960               Project Server                             General                                                    0000                    Exception         ...teKeyValuePair[T,U](T key, U value)     at Microsoft.SharePoint.JsonUtilities.Serializer.SerializeToJson(IDictionary dict)     at Microsoft.SharePoint.JsonUtilities.Serializer.SerializeToJson(Object o)     at Microsoft.SharePoint.JsonUtilities.Serializer.WriteKeyValuePair[T,U](T key, U value)     at Microsoft.SharePoint.JsonUtilities.Serializer.SerializeToJson(IDictionary dict)     at Microsoft.SharePoint.JsonUtilities.Serializer.SerializeToJson(Object o)     at Microsoft.SharePoint.JSGrid.GridSerializer.ToJson(Serializer s)     at Microsoft.SharePoint.JsonUtilities.Serializer.SerializeToJson(Object o)     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.GetTimesheetForGridJsonFromViewUid(JsGridSerializerArguments gridSerializerArgs, Guid tsUid, Guid viewUid, String changesJson, ...          16626d7b-7602-4a26-b4b3-a39636f0bb1d

    11/10/2011 15:20:10.88*         w3wp.exe (0x1084)                                               0x1960               Project Server                             General                                                    0000                    Exception         ...String viewOptionsJson)     at Microsoft.Office.Project.Server.Wcf.Implementation.PWAImpl.TimeSheetGetTimesheetForGridJsonFromViewUid(JsGridSerializerArguments gridSerializerArgs, Guid tsUid, Guid viewUid, String changesJson, String viewOptionsJson)                       16626d7b-7602-4a26-b4b3-a39636f0bb1d

    11/10/2011 15:20:10.88            w3wp.exe (0x1084)                                               0x1960               Project Server                             Unified Logging Service                           c91s                    Monitorable    Watson bucket parameters: Microsoft Project Server 2010, ULSException14, 070f6ea0 "project server", 0e00178d "14.0.6029.0", 5c1ea27d "system.data.datasetextensions", 03057809 "3.5.30729.0", 4ca2d7fc "wed sep 29 08:09:00 2010", 0000006f "0000006f", 00000012 "00000012", eb3236fa "invalidcastexception", 30303030 "0000"      16626d7b-7602-4a26-b4b3-a39636f0bb1d

    11/10/2011 15:20:10.88            w3wp.exe (0x1084)                                               0x1960               SharePoint Foundation                                      Monitoring                                   b4ly                     Medium            Leaving Monitored Scope (ExecuteWcfServerOperation). Execution

    ------------------------------------------

    Any help/advice is valuable! :-)

    Thursday, November 10, 2011 2:52 PM
  • Hi,

    This is the exact same error that my customer is getting. Can I confirm you are running in Single Entry Mode as well?  They are in currently progressing a support ticket on this. 

    As soon as I have something to share I will advise.


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Friday, November 11, 2011 1:10 AM
    Moderator
  • Hello Alexander,

    Yes, we are running Single Entry Mode!

    It would be fantastic if you could share the information you receive.

    Thanks!

    Friday, November 11, 2011 7:28 AM
  • I'm getting the same thing but I see it when the Schedule webpart is shown (clicking on a project name from Project Center). I'm not using Timesheets so I didn't test if I get this on Timesheets as well. I did a new install with a slipstreamed SP1 and the October 2011 CU server rollup packages.
    Monday, November 14, 2011 6:44 PM
  • Hi there

    I am also getting the same error in the Schedule WebPart and it happened with all projects and views. My project server 2010 farm is a new environment with SP1 and AUgust 2011 Cu applied. Following are what the ULS log says:

    11/11/2011 12:24:26.70  w3wp.exe (0x1A7C)                        0x1DEC Project Server                 General                        0000 Exception Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.Project.ProjectGetProjectDetailsForGridJson System.NullReferenceException: Object reference not set to an instance of an object.     at Microsoft.Office.Project.Server.BusinessLayer.Project.TaskTableQueryInfo.Query()     at Microsoft.Office.Project.Server.Utility.JsGridPopulationManager.InitializeSerializer(TableQueryInfo tableInfo, OrderInfo orderInfo, SliceInfo sliceInfo, Guid groupSchemeUid, Nullable`1 ganttSchemeUid, Boolean serializeStyles, Func`1 getChanges, Boolean serializeUnfilteredHierarchy, Boolean serializeLookupTableInfo, Boolean showTimeWithDates, String rowFilter)     at Microsoft.Office.Project.Server.Utility.JsGridPopulationManager.InitializeSerializer(TableQueryInfo tableInfo, ViewPropertyGroup pro... ebaae94d-711c-49ae-8f55-bee4c9e73338
    11/11/2011 12:24:26.70* w3wp.exe (0x1A7C)                        0x1DEC Project Server                 General                        0000 Exception ...perties, JsGridSerializerArguments gridSerializerArgs, Func`1 getChanges)     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 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 expandS... ebaae94d-711c-49ae-8f55-bee4c9e73338
    11/11/2011 12:24:26.70* w3wp.exe (0x1A7C)                        0x1DEC Project Server                 General                        0000 Exception ...ubprojects, Boolean clearPersistedProperties) ebaae94d-711c-49ae-8f55-bee4c9e73338

     

     Any help is appreciated.

    Thanks,

    Vu

    Tuesday, November 15, 2011 2:12 AM
  • Hi everyone,

    I am also experiencing this error.  So far, only one customer has reported this issue when trying to access open timesheets (closed timesheets open without issue).  It replicates as a delegate.  We have the Oct CU installed. 

     

    Any updates?

    Wednesday, November 16, 2011 3:00 PM
  • PeYI,

    Apologies for the delay in responding, we only confirmed this is fixed this week.

    My customer's issue required a direct change to the published DB to fix in their specific case. I would suggest you raise a call with MS Support in order to progress your specific error as I don't want to provide steps that are wrong, put you in a worse position than you are now, or are unsupported.

     


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Saturday, November 19, 2011 9:47 PM
    Moderator
  • Thanks Per. I resolved my issue by also installing the SharePoint Foundation Hotfix from http://support.microsoft.com/kb/2596484. This CU includes an updated version of the sts-x-none.msp. I'll look for this updated file when the December CU comes out.

    Wednesday, November 23, 2011 10:01 PM
  • Hi everyone,

    I am also getting the same error in the Resource center. It happened on view all resources. Our Project server 2010 farm running with SP1 and October 2011 Cu applied. The error flom ULS:

    Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.Resource.ResourceGetResourceCenterResourcesForGridJson System.NullReferenceException: Object reference not set to an instance of an object.   
     at Microsoft.Office.Project.Server.Utility.FilterDalQueryInfo.<BuildFields>b__ee(FieldDataElement el)   
     at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)   
     at System.Linq.Enumerable.ToDictionary[TSource,TKey](IEnumerable`1 source, Func`2 keySelector)   
     at Microsoft.Office.Project.Server.Utility.FilterDalQueryInfo.BuildFields()   
     at Microsoft.Office.Project.Server.Utility.FilterDalQueryInfo.get_Fields()   
     at Microsoft.Office.Project.Server.Utility.JsGridPopulationManager.LoadCustomFieldsDefinitions(TableQueryInfo tableInfo, CustomFieldDefinitionCollection& originalCfDefs, IDictionary`2& aggregateCfDefs)   
     at Microsoft.Office.Project.Server.Utility.JsGridPopulationManager.InitializeSerializer(TableQueryInfo tableInfo, OrderInfo orderInfo, SliceInfo sliceInfo, Guid groupSchemeUid, Nullable`1 ganttSchemeUid, Boolean serializeStyles, Func`1 getChanges, Boolean serializeUnfilteredHierarchy, Boolean serializeLookupTableInfo, Boolean showTimeWithDates, String rowFilter)   
     at Microsoft.Office.Project.Server.Utility.JsGridPopulationManager.InitializeSerializer(TableQueryInfo tableInfo, ViewPropertyGroup properties, JsGridSerializerArguments gridSerializerArgs, Func`1 getChanges)   
     at Microsoft.Office.Project.Server.BusinessLayer.Resource.GetResourceCenterResourcesForGridJson(JsGridSerializerArguments gridSerializerArgs, Guid viewUid, Int32 store, String webPartId, Boolean clearPersistedProperties)   

    Any help?

    Thanks,

    Tom

    Tuesday, February 7, 2012 3:09 PM