Project Server corruption: any thoughts on the cause?

[Joel P.]

Background
The initial report of a problem was after accepting time, one task (fixed
units) in the plan was showing:
- A duration in excess of 10,000 days

- Task start in 1984, finish in 2049, leading to a project completion in 2049.

- 1,666,667 hours actual work

- Time entered for a resource who started a month ago, somehow got posted to
a locked down time period of the week starting Jan 1, 06, which is not
possible, given he started recently, and the time periods are all locked down

- Errors about database rows when opening the plan

- Actuals appearing to change when the task was adjusted (it was changed to
a shorter duration, start/finish and fixed duration)

- All server projects give the following error when we attempt to open them:
“There was an error opening the enterprise resource pool, you may not have
sufficient permission to access the selected resource(s). Would you like to
Retry?â€

- Users then being unable to see the list of projects

Environment :
We are running MS-Project Server 2003 with Service Pack SP2 (not SP2a); and
MS-Project Professional SP2.

The only patch recently applied is:Update for Windows Server 2003 (KB922582)
Description: A problem has been identified in Filter Manager that can
prevent you from installing updates from Windows update. You can help protect
your computer by installing this update from Microsoft. After you install
this item, you may have to restart your computer.



Any thoughts on the cause of the corruption issue?

Thanks,


Joel

 

[Robin Roe]

Al

What we do is put the Budgeted Cost (or agreed fee with client) into a
custom cost field. We then then have a second custom cost field showing
Remaing Budget, which is a calculation of Budget Cost (as mentioned above)
minus the Actual Costs field.

It's much the same idea as Gary has mentioned just done in a different way.