StatusingDataAccess.GetDataForTask could not find pre-cached data.

D

Dots

I attempted to go to my tasks this morning and receive the following error
message:
StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid - 6eb06fc5-6e23-4d72-922d-95335fc3a07e
Stack trace is as follows:
[StatusingException: StatusingDataAccess.GetDataForTask could not find
pre-cached data. Attempted to load Guid -
6eb06fc5-6e23-4d72-922d-95335fc3a07e]

Microsoft.Office.Project.PWA.StatusingLib.StatusingDataAccess.GetDataForTask(Guid docGuid, Guid guidTask) +108
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.LoadNode(Guid guid) +258
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.FindTaskNode(Guid guid)
+328
Microsoft.Office.Project.DataEdit.Document.SvrDoc.GetDataForTask(Guid
guidTask) +65

Microsoft.Office.Project.PWA.StatusingLib.XmlGridAssnNodeBinding.CreateGridRows() +3000
Microsoft.Office.Project.PWA.CommonControls.XmlGrid.DataBind() +394
System.Web.UI.Control.DataBindChildren() +216
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
System.Web.UI.Control.DataBind() +12
System.Web.UI.Control.DataBindChildren() +216
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216

Microsoft.Office.Project.PWA.WebParts.PWAPart.PageLoadCompleteInternal(Object
sender, EventArgs e) +225
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Page.OnLoadComplete(EventArgs e) +2058120
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1209

Can someone help me to identify what the issue with this is and how I can
get my task list to come back?
Thanks.
 
R

RQ

Dots,

We just installed a new instance of Project Server 2007 and have a similar
error if there is a note on a task and we click on the yellow notes icon -
how did you resolve your issue

RQ
 
D

Dots

How do you know if your Project has a corrupted tasks, simply the following
indicators will till you if so
1. One ore more of your resource report that his "My Tasks" is showing
sharepoint error message

2. If you know how to query your database (Published DB of your server) and
get unfortunately one row at lease
SELECT MSP_PROJECTS.PROJ_NAME, MSP_ASSIGNMENTS_SAVED.TASK_NAME,
MSP_RESOURCES.RES_NAME, MSP_ASSIGNMENTS_SAVED.ASSN_UID,
MSP_ASSIGNMENTS_SAVED.PROJ_UID,
MSP_ASSIGNMENTS_SAVED.TASK_UID, MSP_ASSIGNMENTS_SAVED.RES_UID
FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
MSP_PROJECTS.PROJ_UID INNER JOIN
MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
MSP_RESOURCES.RES_UID
WHERE (NOT EXISTS
(SELECT TASK_UID
FROM MSP_TASKS_SAVED
WHERE (TASK_UID =
MSP_ASSIGNMENTS_SAVED.TASK_UID)))

Then to resolve this issue do the following
• Open Gantt View, Insert "Publish" column, and select No for the task that
you got from the above query
• Publish your project
• Again Gantt View, For the "Publish" column, and select "Yes" for the task
that you got from the above query
• Publish project


RQ said:
Dots,

We just installed a new instance of Project Server 2007 and have a similar
error if there is a note on a task and we click on the yellow notes icon -
how did you resolve your issue

RQ

Dots said:
I attempted to go to my tasks this morning and receive the following error
message:
StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid - 6eb06fc5-6e23-4d72-922d-95335fc3a07e
Stack trace is as follows:
[StatusingException: StatusingDataAccess.GetDataForTask could not find
pre-cached data. Attempted to load Guid -
6eb06fc5-6e23-4d72-922d-95335fc3a07e]

Microsoft.Office.Project.PWA.StatusingLib.StatusingDataAccess.GetDataForTask(Guid docGuid, Guid guidTask) +108
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.LoadNode(Guid guid) +258
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.FindTaskNode(Guid guid)
+328
Microsoft.Office.Project.DataEdit.Document.SvrDoc.GetDataForTask(Guid
guidTask) +65

Microsoft.Office.Project.PWA.StatusingLib.XmlGridAssnNodeBinding.CreateGridRows() +3000
Microsoft.Office.Project.PWA.CommonControls.XmlGrid.DataBind() +394
System.Web.UI.Control.DataBindChildren() +216
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
System.Web.UI.Control.DataBind() +12
System.Web.UI.Control.DataBindChildren() +216
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216

Microsoft.Office.Project.PWA.WebParts.PWAPart.PageLoadCompleteInternal(Object
sender, EventArgs e) +225
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Page.OnLoadComplete(EventArgs e) +2058120
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1209

Can someone help me to identify what the issue with this is and how I can
get my task list to come back?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top