locked
An unknown error has occurred in My Tasks for specific user RRS feed

  • Question

  • the following error appears everytime when i open My Tasks Page:
    "An unexpected error has occurred"

    i checked ULS log and i found Sql Error (Timeout expired) when excuting the sql statement. this happens for only 1 user and all others are ok.

    this is the full log:

    03/28/2012 11:43:51.88  w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        8ym5 Monitorable PWA:http://intranet:100/PWA, ServiceApp:Project Web Service Application, User:OG\XXXX, PSI: SqlException occurred in DAL:  <Error><Class>0</Class><LineNumber>0</LineNumber><Number>-2</Number><Procedure></Procedure>  <Message>  System.Data.SqlClient.SqlError: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.  </Message>  <CallStack>     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 Sys... 33104c68-fb66-47f1-8799-667ed8996796
    03/28/2012 11:43:51.88* w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        8ym5 Monitorable ...tem.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)     at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)     at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)     at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)     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 ma... 33104c68-fb66-47f1-8799-667ed8996796
    03/28/2012 11:43:51.88* w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        8ym5 Monitorable ...xRecords, 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)  </CallStack>  </Error> 33104c68-fb66-47f1-8799-667ed8996796
    03/28/2012 11:43:51.88  w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        0000 Exception Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.Statusing.StatusingGetMyWorkForGridJson Microsoft.Office.Project.Server.DataAccessLayer.FilterDal+FilterException: Error during filter query execution.   Query:     declare @ResUid UniqueIdentifier; set @ResUid = a65a7629-abd9-42bf-9622-7de9baf35639;  declare @ViewUid UniqueIdentifier; set @ViewUid = a20480ef-c755-4da7-a36f-5fe92fed0c68;  declare @P0 UniqueIdentifier; set @P0 = a65a7629-abd9-42bf-9622-7de9baf35639;    SET NOCOUNT ON    SELECT      MAS.ASSN_UID ,      MAS.PROJ_UID   INTO #T0   FROM dbo.MSP_ASSIGNMENTS_SAVED AS MAS      INNER JOIN dbo.MSP_PROJECTS AS MP ON MP.PROJ_UID = MAS.PROJ_UID     INNER JOIN dbo.MSP_TASKS_SAVED AS T ON T.PROJ_UID = MAS.PROJ_UID AND T.TASK_UID = MAS.TASK_UID     INNER JOIN dbo.MS... 33104c68-fb66-47f1-8799-667ed8996796
    03/28/2012 11:43:51.88* w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        0000 Exception ...P_PROJECT_RESOURCES AS R ON R.PROJ_UID = MAS.PROJ_UID AND R.RES_UID = MAS.RES_UID     INNER JOIN dbo.MSP_RESOURCES AS R2 ON R2.RES_UID = R.RES_DEF_ASSN_OWNER     LEFT JOIN dbo.MSP_RESOURCES AS R3 ON R3.RES_UID = MAS.RES_UID_OWNER     LEFT JOIN dbo.MSP_RESOURCES AS R4 ON R4.RES_UID = MAS.WRES_UID_MANAGER  WHERE MAS.WASSN_LOCKDOWN_BY_MANAGER = 0AND T.TASK_IS_ACTIVE = 1 AND  ( (MAS.RES_UID_OWNER = @P0) )   CREATE CLUSTERED INDEX PK_#T0 ON #T0 (ASSN_UID, PROJ_UID)    SET NOCOUNT OFF    SELECT      MAS.ASSN_UID ,      MAS.PROJ_UID ,      MAS.TASK_NAME ,      MAS.ASSN_START_DATE ,      MAS.ASSN_FINISH_DATE ,      ASSN_REM_WORK ,      MAS.ASSN_PCT_WORK_COMPLETE ,      ASSN_WORK ,      ASSN_ACT_WORK ,      MAS.TASK_UID ,      PROJ_NAME ,      WASSN_IS_NEW_ASSN ,      MAS.WASSN_REMOVED_BY_RES ,    ... 33104c68-fb66-47f1-8799-667ed8996796
    03/28/2012 11:43:51.88* w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        0000 Exception ...  case when exists ( select * from MSP_ASSIGNMENT_TRANSACTIONS t where MAS.ASSN_UID = t.ASSN_UID and t.ASSN_TRANS_STATE_ENUM = 1) then 1 else 0 end AS ASSN_RESPONSE_PENDING ,      MAS.WASSN_MGR_UPDATED ,      MAS.WASSN_ACTUALS_PENDING ,      MAS.WASSN_SEND_UPDATE_NEEDED ,      MAS.WASSN_LOCKDOWN_BY_MANAGER ,      MAS.WASSN_DELETED_IN_PROJ ,      MAS.WASSN_COMMENTS ,      R.RES_NAME ,      T.TASK_IS_MILESTONE ,      WASSN_UPDATE_TRACKING_MODE ,      T.TASK_NOTES ,      T.TASK_IS_MANUAL ,      T.TASK_HIERARCHY ,      T.TASK_DUR_TXT ,      T.TASK_FINISH_TXT ,      T.TASK_START_TXT ,      MAS.TASK_IS_SUMMARY ,      WO.WOBJ_UID ,      MP.PROJ_OPT_MINUTES_PER_DAY ,      MP.PROJ_OPT_MINUTES_PER_WEEK ,      MP.PROJ_OPT_DAYS_PER_MONTH ,      MP.PROJ_OPT_CURRENCY_CODE ,      MAS.ASSN_STOP_DATE ,    ... 33104c68-fb66-47f1-8799-667ed8996796
    03/28/2012 11:43:51.88* w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        0000 Exception ...  T.TASK_IS_SUBPROJ ,      T.TASK_IS_ACTIVE ,      T.TASK_START_DATE ,      T.TASK_FINISH_DATE ,      T.TASK_DUR ,      MAS.RES_UID ,      R.RES_MATERIAL_LABEL ,      R.RES_TYPE ,      ASSN_UPDATE_NEEDED   FROM dbo.MSP_ASSIGNMENTS_SAVED AS MAS      INNER JOIN dbo.MSP_PROJECTS AS MP ON MP.PROJ_UID = MAS.PROJ_UID     INNER JOIN dbo.MSP_TASKS_SAVED AS T ON T.PROJ_UID = MAS.PROJ_UID AND T.TASK_UID = MAS.TASK_UID     INNER JOIN dbo.MSP_PROJECT_RESOURCES AS R ON R.PROJ_UID = MAS.PROJ_UID AND R.RES_UID = MAS.RES_UID     INNER JOIN dbo.MSP_RESOURCES AS R2 ON R2.RES_UID = R.RES_DEF_ASSN_OWNER     LEFT JOIN dbo.MSP_RESOURCES AS R3 ON R3.RES_UID = MAS.RES_UID_OWNER     LEFT JOIN dbo.MSP_RESOURCES AS R4 ON R4.RES_UID = MAS.WRES_UID_MANAGER     INNER JOIN #T0 AS keys ON keys.ASSN_UID = MAS.ASSN_UID AND... 33104c68-fb66-47f1-8799-667ed8996796
    03/28/2012 11:43:51.88* w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        0000 Exception ... keys.PROJ_UID = MAS.PROJ_UID     LEFT JOIN dbo.MSP_WEB_OBJECTS AS WO ON WO.WOBJ_PROJ_UID = T.PROJ_UID AND WO.WOBJ_TASK_UID = T.TASK_PUBLISHED_UID AND WO.WOBJ_TYPE = 2  WHERE MAS.WASSN_LOCKDOWN_BY_MANAGER = 0AND T.TASK_IS_ACTIVE = 1    DROP TABLE #T0;     ---> 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)     ... 33104c68-fb66-47f1-8799-667ed8996796
    03/28/2012 11:43:51.88* w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        0000 Exception ...at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)     at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)     at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)     at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)     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, In... 33104c68-fb66-47f1-8799-667ed8996796
    03/28/2012 11:43:51.88* w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        0000 Exception ...t32 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.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, SqlCommand sqlCommand, Boolean enforceConstraints)     at Microsoft.Office.Project.Server.DataAccessLayer.FilterDal.FillDataSet(QueryState queryState)     --- End of inner exception stack trace ---     at Microsoft.Office.Project.Server.DataAccessLayer.FilterDal.FillDataSet(QueryState queryState)     at Microsoft.Office.Project.Server.Utility... 33104c68-fb66-47f1-8799-667ed8996796
    03/28/2012 11:43:51.88* w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        0000 Exception ....FilterDalQueryInfo.Query()     at Microsoft.Office.Project.Server.BusinessLayer.MyWorkQueryInfo.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 properties, JsGridSerializerArguments gridSerializerArgs, Func`1 getChanges)     at Microsoft.Office.Project.Server.BusinessLayer.Statusing.GetMyWorkForGridJson(JsGridSerializerArguments gri... 33104c68-fb66-47f1-8799-667ed8996796
    03/28/2012 11:43:51.88* w3wp.exe (0x3A3C)                        0x24F8 Project Server                 General                        0000 Exception ...dSerializerArgs, String gridChangesJson, String projectAssignmentsMap, Guid viewUid, String timephasedStart, String timephasedEnd, Byte pane, Int32 durationType, Int32 workType, Int32 dateFormat, Boolean clearPersistedProperties, Nullable`1 rowFilterType)     at Microsoft.Office.Project.Server.Wcf.Implementation.PWAImpl.StatusingGetMyWorkForGridJson(JsGridSerializerArguments gridSerializerArgs, String gridChangesJson, String projectAssignmentsMap, Guid viewUid, String timephasedStart, String timephasedEnd, Byte pane, Int32 durationType, Int32 workType, Int32 dateFormat, Boolean clearPersistedProperties, Nullable`1 rowFilterType) 33104c68-fb66-47f1-8799-667ed8996796

    Any help ?

    Thanks


    Regards, Mohamed Abdel Ghaffar | http://sharepointfoundation2010.blogspot.com

    Wednesday, March 28, 2012 10:59 AM

All replies

  • Hi there,

    Execute the following against the Project Server published database then ask the user to retest:

    exec sp_updatestats

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Wednesday, March 28, 2012 12:11 PM
  • If you have access to the SQL server hosting the Project Server db's, have a look at the MSP_TASKS table. It would be interesting to see how many tasks this user is actually assigned to. Maybe the My Tasks view would return too many rows, therefore causing the timeout?

    Wednesday, March 28, 2012 12:13 PM
  • Guys, Thanks for your fast responses

    we solved the issue by tracking user tasks and guaranteed the proper sequence of tasks linking then republish the project. Everything is ok now :)


    Regards, Mohamed Abdel Ghaffar | http://sharepointfoundation2010.blogspot.com

    Wednesday, March 28, 2012 12:46 PM
  • Thank you PWMather! This helped resolve our issue.
    Friday, August 17, 2012 1:32 PM
  • Hi Paul

    I too facing same issue ("An unknown error has occurred" while loading mytask page). i could not find any error in log file. 430 task assinged to me from 21 projects, which i have worked.  Could you help me to solve this issue?


    Thanks
    salahudeen A

    Thursday, September 13, 2012 8:16 AM