Answered by:
Project Server 2010 Tasks Page - An unknown error has occurred

Question
-
We have one resource facing an issue in open tasks page it fires "An Unknown Error has occured" error.
I have searched ULS log on the error and found the below error (After enable callstack):
An SPRequest object was not disposed before the end of this thread. To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it. This object will now be disposed. Allocation Id: {2E9F6598-D9F4-4B98-A6D8-E757FAADB389} This SPRequest was allocated at at Microsoft.SharePoint.Library.SPRequest..ctor() at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(SPSite site, String name, Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous) at Microsoft.SharePoint.SPWeb.InitializeSPRequest() at Microsoft.SharePoint.SPWeb.InitWebPublic() at Microsoft.SharePoint.SPWeb.get_CurrentUser() at Microsoft.Office.Project.PWA.PJContext.get_RegionalSettings() at Microsoft.Office.Project.PWA.PJContext.get_LocaleCulture() at Microsoft.Office.Project.PWA.PJContext.AuthenticateUserForPWA(Boolean newCookie) at Microsoft.Office.Project.PWA.PJContext.GetContext(Boolean isWebServiceCall, Boolean newCookie, Guid siteId, Nullable`1 zone, Boolean useCache) at Microsoft.Office.Project.PWA.PJContext.GetContext(Boolean isWebServiceCall, Boolean newCookie, Guid siteId, Nullable`1 zone) at Microsoft.Office.Project.PWA.PJBaseWebPartPage..ctor() at ASP.TASKS_ASPX_1438945606..ctor() at __ASP.FastObjectFactory_app_web_tasks_aspx_1438945606_aawalshj.Create_ASP_TASKS_ASPX_1438945606() at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.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)
Thanks & Regards Ahmed Amin
Saturday, July 6, 2013 1:12 PM
Answers
-
Hi Ahmed,
The PROP_STRING value represents a serial date. The PROP_STRING value for the PROP_NAME TimephasedStartJSGridControl should have a lower number than the PROP_STRING value for the PROP_NAME TimephasedEndJSGridControl
This issue seems to be due to PROP_NAME TimephasedStartJSGridControl and TimephasedEndJSGridControl records for the user in the MSP_WEB_USERPROPERTIES table which has incorrect values for the PROP_STRING field.
To resolve, we have to delete these entries from the table. As this requires change in DB, needs to be done under expert supervision and assistance. Advise you to open a support case with Microsoft Project support team to assist you on the issue.
Regards,
Dinesh Rai
Cheers. Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management
- Proposed as answer by Dinesh S. RaiMicrosoft employee Saturday, July 6, 2013 8:45 PM
- Marked as answer by Ahmed Amin Ahmed Saturday, July 6, 2013 10:56 PM
Saturday, July 6, 2013 8:45 PM
All replies
-
Hi Ahmed,
The PROP_STRING value represents a serial date. The PROP_STRING value for the PROP_NAME TimephasedStartJSGridControl should have a lower number than the PROP_STRING value for the PROP_NAME TimephasedEndJSGridControl
This issue seems to be due to PROP_NAME TimephasedStartJSGridControl and TimephasedEndJSGridControl records for the user in the MSP_WEB_USERPROPERTIES table which has incorrect values for the PROP_STRING field.
To resolve, we have to delete these entries from the table. As this requires change in DB, needs to be done under expert supervision and assistance. Advise you to open a support case with Microsoft Project support team to assist you on the issue.
Regards,
Dinesh Rai
Cheers. Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management
- Proposed as answer by Dinesh S. RaiMicrosoft employee Saturday, July 6, 2013 8:45 PM
- Marked as answer by Ahmed Amin Ahmed Saturday, July 6, 2013 10:56 PM
Saturday, July 6, 2013 8:45 PM -
Thanks Dinesh,
i have followed your advice and delete the values for these two enteries (Change it to NULL), and it worked fine.
Thanks again.
Thanks & Regards Ahmed Amin
Saturday, July 6, 2013 10:58 PM