Corrupted plans - help!

E

Ed

We're using MS Project Server 2002.
We only have about 100 plans on the server now and have
everyone on the same subnet with the server so we get 1ms
response times to pings.

And yet at least once a every other week (sometimes more
frequently) my PMs get a corrupted project plan.
The get some kind of OBDC error and end up with a plan
that has circular references, misplaced tasks, etc.

I'm looking into setting "Keep alive" and 100bps Full
Duplex settings on every machine.

NOTE: It takes a while to save/publish plans sometimes...
possibly longer than 30 seconds... is it possible that we
are experiencing ODBC timeouts?

has anyone else had this kind of problem?
Can anyone offer some assistance here?

Thanks much!

Ed
 
K

Kevin Flanagan

We had the same issue but after researching it, we found
out that this was being caused by PMs copying and pasting
tasks (the whole line and not just the task name and
data). If the plan has been published and the user then
copies and pastes tasks with the same unique ID one of
the web tables craps out and then the plan starts
throwing circular refrence errors. It is a user error
and not the program. Hope this helps.

Kevin
 
E

Ed

WOW!
I would think copying entire task lines would be
supported!

Thanks alot!

I'm sure we're copying in this manner!

How in the world did you figure that out?

I'll update our standards here!

Thanks again!

Ed
 
K

Kevin Flanagan

Just kept asking what they were doing immediately before
trying to save and each PM would say "Copying and pasting
tasks" I know it has something to do with the primary
and/or secondary keys in one or more of the tables in SQL
Server.

Kevin
 
Top