Assignment datagrid is blank for one of the resources in Resource

[Karnphong]

In PWA 2007, one of our resources is unable to view his assignments in
Resource Assignments page (under Resource Center -> View Assignments).
Specifically, the datagrid on Resource Assignment page
(/pwa/ResourceAssignments.aspx) is blank if that "bad" resource is selected.
Moreover, if that resource and others are selected, the same blank datagrid
happens.

Here are error messages from our logfile:
Exception occurred in method PWA.ResourceGetResourceAssignmentsForGrid
System.Collections.Generic.KeyNotFoundException: The given key was not
present in the dictionary. at
System.ThrowHelper.ThrowKeyNotFoundException() at
System.Collections.Generic.Dictionary`2.get_Item(TKey key) at
Microsoft.Office.Project.Server.BusinessLayer.Resource.CollectParentTasks(Guid
taskGuid, Dictionary`2 parentTaskMap, Dictionary`2 addedTasks) at
Microsoft.Office.Project.Server.BusinessLayer.Resource.AddSummaryTasks(ResourceAssignmentDataTable
restbl, DataSet summaryTasks) at
Microsoft.Office.Project.Server.BusinessLayer.Resource.ReadResourceAssignments(String
xmlFilter, String entityUIDs, Boolean includeSummaryTasks) at
Microsoft.Office.Project.Server.BusinessLayer.Resource.GetResourceA... a77d246c-e134-48fd-b1db-80247a2d6605
....ssignmentsForGrid(String filter, String entityUIDs, Boolean
includeSummaryTasks) at
Microsoft.Office.Project.Server.WebService.PWA.ResourceGetResourceAssignmentsForGrid(String
filter, String entityUIDs, Boolean
includeSummaryTasks) a77d246c-e134-48fd-b1db-80247a2d6605

Anyone has the same issue? How can this be fixed?

 

[Gary Chefetz]

Karnphong:

I have not seen this exact error before, but my guess is some corruption in
the database, more specifically a problem with indexing. Do you have
database maintenance plan running? You should be updating the statistics on
your database at least once a week on an active system, more often on a very
large system. If running that procedure doesn't solve your problem, try this
procedure:

http://www.projectserverexperts.com...erebuildofprojectserverreportingdatabase.aspx

Let us know if this helps.