Repeating resources

J

Jack

We received and witnessed a few cases where project managers found out that
they were timing out from saving a project via project pro. The reason was
that their resource sheet showed thousands of resources (same person/role)
that repeats through the bottom of their resource sheet.

Did anyone else had a similar occurrence? Is there a patch for this?

We heard from a consultant that there was another customer that witnessed
the same scenario. So, we're pretty sure it's not just out setup. All
project managers were on Project Pro SP1 and mostly on XP. The server is
using SQL Server 2000 SP2 & Project Server 2003 SP1 (plus the latest updates).
 
D

Dale Howard [MVP]

Jack --

This is generally a consequence of a corrupted project. To correct the
problem, you can try the following:

1. Save the project as an .xml file (to fix the corruption)
2. Delete the corrupted project from the Project Server database
3. Manually delete the extra resources in the Resource Sheet view of the
..xml file
4. Import the project again using the Import Projects to Enterprise wizard

Hope this helps.
 
J

Jack

Dale,

Thanks for the quick response. Yes, we did that and it did solve the
problem. My question is, why and how did it get corrupted in the first
place? Is there a way to avoid it? Or will Project Server SP2 resolve this?

-Jack
 
D

Dale Howard [MVP]

Jack --

I do not know what caused the corruption or any way to avoid it. This type
of corruption has been reported a couple of times in the newsgroup, but it
does not appear to be widespread. Hope this helps.
 
G

Gary L. Chefetz \(MVP\)

Jack:

Your SQL server should be at SP3a, nothing less.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

-
Jack said:
We received and witnessed a few cases where project managers found out that
they were timing out from saving a project via project pro. The reason was
that their resource sheet showed thousands of resources (same person/role)
that repeats through the bottom of their resource sheet.

Did anyone else had a similar occurrence? Is there a patch for this?

We heard from a consultant that there was another customer that witnessed
the same scenario. So, we're pretty sure it's not just out setup. All
project managers were on Project Pro SP1 and mostly on XP. The server is
using SQL Server 2000 SP2 & Project Server 2003 SP1 (plus the latest
Click to expand...
updates).
 
Top