locked
PS2010, Project Fields Web Part timeout RRS feed

  • Question

  • Hello all,

    Please help me in solving the Timeout for the Project Fields webpart on a Project Detail Page for an existing project in PWA. The message reads: "The webpart was unable to load. Information that may be useful is written to the ULS...."

    I have run the SharePoint Developer Dashboard on this page and the results are:

    Details

    Name: ExecuteWcfOperation:http://schemas.microsoft.com/office/project/server/webservices/PWA/WorkflowGetProjectFieldPartInformation

    Duration: 30036.61 ms

    Callstack

    at Microsoft.SharePoint.SPServiceContextBehavior.System.ServiceModel.Dispatcher.IClientMessageInspector.AfterReceiveReply(Message& reply, Object correlationState)

       at System.ServiceModel.Dispatcher.ImmutableClientRuntime.AfterReceiveReply(ProxyRpc& rpc)

       at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)

       at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

       at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

       at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

       at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

       at Microsoft.Office.Project.Server.Interfaces.IPWA.WorkflowGetProjectFieldPartInformation(Guid projectUid, Guid[] fieldUids, Guid pdpUid, Guid storageKey, Int32 pageLCID)

       at Microsoft.Office.Project.Server.WebServiceProxy.PWA.WorkflowGetProjectFieldPartInformation(Guid projectUid, Guid[] fieldUids, Guid pdpUid, Guid storageKey, Int32 pageLCID)

       at Microsoft.Office.Project.PWA.WebParts.ProjectFieldPartBase.GatherAndLoadCFList(Boolean bForceRefresh)

       at Microsoft.Office.Project.PWA.WebParts.ProjectFieldPartBase.RebindGrid(Boolean forceRefresh)

       at Microsoft.Office.Project.PWA.WebParts.ProjectFieldPartBase.PWA_OnLoad(EventArgs e)

       at Microsoft.Office.Project.PWA.WebParts.PWAResiliencyPart.OnLoad(EventArgs e)

       at System.Web.UI.Control.LoadRecursive()

       at System.Web.UI.Control.LoadRecursive()

       at System.Web.UI.Control.LoadRecursive()

       at System.Web.UI.Control.LoadRecursive()

       at System.Web.UI.Control.LoadRecursive()

       at System.Web.UI.Control.LoadRecursive()

       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

       at System.Web.UI.Page.ProcessRequest()

       at System.Web.UI.Page.ProcessRequest(HttpContext context)

       at ASP.SPSTD2_ASPX__1152337926.ProcessRequest(HttpContext context)

       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

       at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)

       at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)

       at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)

       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

    So the webpart tries to load data for about 30 seconds an then a timeout happens. The callstack does not provide any usefull information as it is the same for another PWA environment that is running fine. We are not using any Workflows in Project Server, but it seems that the webpart is trying to access certain workflow data. The SQL server is almost idle.

    ULS log shows:

    01-31-2013 10:23:11.36  w3wp.exe (0x0D54)       0x168C  SharePoint Foundation   Monitoring      b4ly    High    Leaving Monitored Scope (FillTypedDataSet -- MSP_PROJECT_ReadPDPIntrinsicAndCustomFieldValues). Execution Time=30082.2227405997 3af08db4-d29e-473d-a5da-3dbf2b40e91d

    01-31-2013 10:23:11.49  w3wp.exe (0x0D54)       0x168C  Project Server  General 0000    Exception       Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.Workflow.WorkflowGetProjectFieldPartInformation System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()     at System.Data.SqlClient.SqlDataReader.get_MetaData()     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)     at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)     at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)     at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)     at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)     at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)     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.Generated.ProjectDalBase.ReadPDPIntrinsicAndCustomFieldValuesTyped(Guid proj_uid, String propUids)     at Microsoft.Office.Project.Server.BusinessLayer.Project.ReadPDPIntrinsicAndCustomFieldsForProject(Guid projectUid, Guid[] propUids, Guid pdpUid, Guid webPartUid)     at Microsoft.Office.Project.Server.BusinessLayer.Workflow.GetProjectFieldPartInformation(Guid projectUid, Guid[] fieldUids, Guid pdpUid, Guid storageKey, Int32 pageLCID)     at Microsoft.Office.Project.Server.Wcf.Implementation.PWAImpl.WorkflowGetProjectFieldPartInformation(Guid projectUid, Guid[] fieldUids, Guid pdpUid, Guid storageKey, Int32 pageLCID) Source: .Net SqlClient Data Provider Server: Nlcl3000301\cl3000301  3af08db4-d29e-473d-a5da-3dbf2b40e91d

    Any suggestions are welcome.


    Marcel Visscher QS solutions

    Thursday, February 7, 2013 10:14 AM

All replies

  • Try deleting the web part and adding it back into the page.

    Also, when you edit the PDP page with the project field, make sure you check it back in.

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries


    Thursday, February 7, 2013 4:45 PM
  • Hello Micheal,

    Thanks for your response. Unfortunately it had no success. I even created a new Project Detail Page and added the Project Field webpart, but still the timeout occurs. Also the same timeout exists for the Project Fields (backwards compatibility mode) webpart.

    Any other suggestions are welcome.

    Marcel.


    Marcel Visscher QS solutions

    Thursday, February 7, 2013 8:54 PM
  • What version of Project Server are you running.  Have you applied all the service packs?

    Is it just this particular web part?

    Does it happen when logged in as the FarmAdmin?

    Did you recently add some new EPM codes?  Can you exclude or delete them from the list?

    cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Friday, February 8, 2013 5:15 AM
  • We are running PS2010, SP1 CU June 2012.

    It happens only with the Project Fields webpart and the Project Fields (backwards compatibility mode) webpart. These two webparts retrieve Enterprise Custom field data for a project. Because it is possible to link Project Custom fields to a certain workflow stage I assume that this webpart is also making a inquiry for the workflow that is attached to the Enterprise Project Type. However we do no use any workflows for any Enterprise Project Type.

    The Project Field webpart gets a timeout even if NO Enterprise Custom Fields are selected to be shown in the webpart.

    I am logged in as the EPMadmin, which is a PS administrator with all privileges. Also this account is used as the Default Proxy User. This account has dbreader rights on the draft, published and reporting DB.

    Yes we have recently added new Enterprise Custom fields for projects. I will try to remove them one by one from the Enterprise Custom Fields and Lookup Tables menu and retry the performance.

    Thanks again.


    Marcel Visscher QS solutions

    Friday, February 8, 2013 6:14 AM
  • Unfortunately, removing all new custom fields and lookup tables didn't solve the problem.

    Marcel Visscher QS solutions

    Friday, February 8, 2013 12:10 PM