Error when opening My Tasks

G

Garry Billson

Hi

When using Project Server 2007 I get the error
"StatusingDataAccess.GetDataForTask could not find pre-cached data" when
clicking on the my tasks link. Other user in the organization are not gettin
an error.

Please can you point me in the direction to resolviong this issue.

Thank you
 
G

Gary L. Chefetz [MVP]

Garry:

This is a bit of a SWAG. Maybe it's referring to the local cache. In which
case you need to delete these. Before doing so, you need to save all of your
projects online. run the command %appdata% and navigate to
\microsoft\project 2007 and delete the two folders below project 2007.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
 
C

chileconjapie

I got the same problem but I don't have these folders...

Gary L. Chefetz [MVP] ha escrito:
 
N

nicolae.tarla

I got the same problem but I don't have these folders...

Gary L. Chefetz [MVP] ha escrito:





- Show quoted text -

Got the same problem here, on one user only. It's not related to the
local cache, as I have tryed on a different machine with the same
result. All other users work just fine.

Error:

StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid [GUID]

Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details:
Microsoft.Office.Project.PWA.StatusingLib.StatusingException:
StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid - [GUID]
Source Error:
Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.832;
ASP.NET Version:2.0.50727.832
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
[StatusingException: StatusingDataAccess.GetDataForTask could not find
pre-cached data. Attempted to load Guid - [GUID]]
Microsoft.Office.Project.PWA.StatusingLib.StatusingDataAccess.GetDataForTask(Guid
docGuid, Guid guidTask) +188
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.LoadNode(Guid guid)
+491
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.FindTaskNode(Guid
guid) +538
Microsoft.Office.Project.DataEdit.Document.SvrDoc.GetDataForTask(Guid
guidTask) +113
Microsoft.Office.Project.PWA.StatusingLib.XmlGridAssnNodeBinding.CreateGridRows()
+1530
Microsoft.Office.Project.PWA.CommonControls.XmlGrid.DataBind() +902
System.Web.UI.Control.DataBindChildren() +344
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +182
System.Web.UI.Control.DataBindChildren() +344
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +182
Microsoft.Office.Project.PWA.WebParts.PWAPart.PageLoadCompleteInternal(Object
sender, EventArgs e) +461
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Page.OnLoadComplete(EventArgs e) +114
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+3427
 
G

Gary L. Chefetz [MVP]

The next likely suspect is assignment corruption. The only way to hadle
this, that I know of, is to delete the offending project from the server and
re-import it.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


I got the same problem but I don't have these folders...

Gary L. Chefetz [MVP] ha escrito:









- Show quoted text -

Got the same problem here, on one user only. It's not related to the
local cache, as I have tryed on a different machine with the same
result. All other users work just fine.

Error:

StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid [GUID]

Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details:
Microsoft.Office.Project.PWA.StatusingLib.StatusingException:
StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid - [GUID]
Source Error:
Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.832;
ASP.NET Version:2.0.50727.832
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
[StatusingException: StatusingDataAccess.GetDataForTask could not find
pre-cached data. Attempted to load Guid - [GUID]]
Microsoft.Office.Project.PWA.StatusingLib.StatusingDataAccess.GetDataForTask(Guid
docGuid, Guid guidTask) +188
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.LoadNode(Guid guid)
+491
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.FindTaskNode(Guid
guid) +538
Microsoft.Office.Project.DataEdit.Document.SvrDoc.GetDataForTask(Guid
guidTask) +113
Microsoft.Office.Project.PWA.StatusingLib.XmlGridAssnNodeBinding.CreateGridRows()
+1530
Microsoft.Office.Project.PWA.CommonControls.XmlGrid.DataBind() +902
System.Web.UI.Control.DataBindChildren() +344
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +182
System.Web.UI.Control.DataBindChildren() +344
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +182
Microsoft.Office.Project.PWA.WebParts.PWAPart.PageLoadCompleteInternal(Object
sender, EventArgs e) +461
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Page.OnLoadComplete(EventArgs e) +114
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+3427
 
S

Sinek

This script will let you know which task(s) in which project are corrupted.

You will then need to delete the task(s) from the project plan, publish the
plan, recreate the task(s) and then republish the plan.


USE projectserver_published
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)))



I got the same problem but I don't have these folders...

Gary L. Chefetz [MVP] ha escrito:









- Show quoted text -

Got the same problem here, on one user only. It's not related to the
local cache, as I have tryed on a different machine with the same
result. All other users work just fine.

Error:

StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid [GUID]

Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details:
Microsoft.Office.Project.PWA.StatusingLib.StatusingException:
StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid - [GUID]
Source Error:
Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.832;
ASP.NET Version:2.0.50727.832
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
[StatusingException: StatusingDataAccess.GetDataForTask could not find
pre-cached data. Attempted to load Guid - [GUID]]
Microsoft.Office.Project.PWA.StatusingLib.StatusingDataAccess.GetDataForTask(Guid
docGuid, Guid guidTask) +188
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.LoadNode(Guid guid)
+491
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.FindTaskNode(Guid
guid) +538
Microsoft.Office.Project.DataEdit.Document.SvrDoc.GetDataForTask(Guid
guidTask) +113
Microsoft.Office.Project.PWA.StatusingLib.XmlGridAssnNodeBinding.CreateGridRows()
+1530
Microsoft.Office.Project.PWA.CommonControls.XmlGrid.DataBind() +902
System.Web.UI.Control.DataBindChildren() +344
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +182
System.Web.UI.Control.DataBindChildren() +344
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +182
Microsoft.Office.Project.PWA.WebParts.PWAPart.PageLoadCompleteInternal(Object
sender, EventArgs e) +461
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Page.OnLoadComplete(EventArgs e) +114
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+3427
 
M

mpaulo

This script will let you know which task(s) in which project are corrupted.

You will then need to delete the task(s) from the project plan, publish the
plan, recreate the task(s) and then republish the plan.

USE projectserver_published
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)))




Got the same problem here, on one user only. It's not related to the
local cache, as I have tryed on a different machine with the same
result. All other users work just fine.

StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid [GUID]
Description: An unhandled exception occurred during the execution of
the currentwebrequest. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details:
Microsoft.Office.Project.PWA.StatusingLib.StatusingException:
StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid - [GUID]
Source Error:
Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.832;
ASP.NET Version:2.0.50727.832
An unhandled exception was generated during the execution of the
currentwebrequest. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
[StatusingException: StatusingDataAccess.GetDataForTask could not find
pre-cached data. Attempted to load Guid - [GUID]]
Microsoft.Office.Project.PWA.StatusingLib.StatusingDataAccess.GetDataForTas­k(Guid
docGuid, Guid guidTask) +188
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.LoadNode(Guid guid)
+491
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.FindTaskNode(Guid
guid) +538
Microsoft.Office.Project.DataEdit.Document.SvrDoc.GetDataForTask(Guid
guidTask) +113
Microsoft.Office.Project.PWA.StatusingLib.XmlGridAssnNodeBinding.CreateGrid­Rows()
+1530
Microsoft.Office.Project.PWA.CommonControls.XmlGrid.DataBind() +902
System.Web.UI.Control.DataBindChildren() +344
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +182
System.Web.UI.Control.DataBindChildren() +344
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +182
Microsoft.Office.Project.PWA.WebParts.PWAPart.PageLoadCompleteInternal(Obje­ct
sender, EventArgs e) +461
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Page.OnLoadComplete(EventArgs e) +114
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+3427- Ocultar texto entre aspas -

- Mostrar texto entre aspas -

Hi!
I need some help here too.
There´s not too similar to the problems above, but let me tell:

I have 2 resources on a specific project that when they access PWA
2007 to assign their hours of real work at MY TAKS, an unexpected
error occurs. The error says that there´s a maintenence on the web
parts.
Does anyone know what it could be???
Regards.
 
G

Gary L. Chefetz [MVP]

mpaulo:

The answer is the same as above, and the same as I gave you in your other
post. Please try to keep one question in one post. Thanks.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


This script will let you know which task(s) in which project are
corrupted.

You will then need to delete the task(s) from the project plan, publish
the
plan, recreate the task(s) and then republish the plan.

USE projectserver_published
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)))




Got the same problem here, on one user only. It's not related to the
local cache, as I have tryed on a different machine with the same
result. All other users work just fine.

StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid [GUID]
Description: An unhandled exception occurred during the execution of
the currentwebrequest. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details:
Microsoft.Office.Project.PWA.StatusingLib.StatusingException:
StatusingDataAccess.GetDataForTask could not find pre-cached data.
Attempted to load Guid - [GUID]
Source Error:
Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.832;
ASP.NET Version:2.0.50727.832
An unhandled exception was generated during the execution of the
currentwebrequest. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
[StatusingException: StatusingDataAccess.GetDataForTask could not find
pre-cached data. Attempted to load Guid - [GUID]]
Microsoft.Office.Project.PWA.StatusingLib.StatusingDataAccess.GetDataForTas­k(Guid
docGuid, Guid guidTask) +188
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.LoadNode(Guid guid)
+491
Microsoft.Office.Project.DataEdit.Tasks.TaskCntr.FindTaskNode(Guid
guid) +538
Microsoft.Office.Project.DataEdit.Document.SvrDoc.GetDataForTask(Guid
guidTask) +113
Microsoft.Office.Project.PWA.StatusingLib.XmlGridAssnNodeBinding.CreateGrid­Rows()
+1530
Microsoft.Office.Project.PWA.CommonControls.XmlGrid.DataBind() +902
System.Web.UI.Control.DataBindChildren() +344
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +182
System.Web.UI.Control.DataBindChildren() +344
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +182
Microsoft.Office.Project.PWA.WebParts.PWAPart.PageLoadCompleteInternal(Obje­ct
sender, EventArgs e) +461
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Page.OnLoadComplete(EventArgs e) +114
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+3427- Ocultar texto entre aspas -

- Mostrar texto entre aspas -

Hi!
I need some help here too.
There´s not too similar to the problems above, but let me tell:

I have 2 resources on a specific project that when they access PWA
2007 to assign their hours of real work at MY TAKS, an unexpected
error occurs. The error says that there´s a maintenence on the web
parts.
Does anyone know what it could be???
Regards.
 

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