J
jkrall
I previously asked a question about not being able to delete a calendar in
the Resource Pool & the ensuing duplicating calendars. But the suggestion I
got was not the fix. See my post "Unable to Delete a Calendar in the
Enterprise Resource Pool"
As I try to research this furthur, I got a peek into the MSP_CALENDARS table
& found, to my dismay, over 600,000 rows in the table. Of those, over
400,000 have the flag in CAL_IS_BASE_CAL set to 1(YES).
Has anyone run into this issue before, Is this normal & how do you SAFELY
clean this stuff out if it's not. I would guess there should be the Standard
Base Calendars & 1 calendar for each resource.
There are around 4000 projects in the database, 140,000 rows in the Tasks
Column & ~ 700 generic, active & inactive resources combined.
I'm to the point where I'm ready to delete all the resources in the
Enterprise Resource Pool & rebuild it from scratch.
We're running Project Server 2002 with all the current service packs &
patches on top of SQL Server 2000.
Any insight will be most appreciated.
the Resource Pool & the ensuing duplicating calendars. But the suggestion I
got was not the fix. See my post "Unable to Delete a Calendar in the
Enterprise Resource Pool"
As I try to research this furthur, I got a peek into the MSP_CALENDARS table
& found, to my dismay, over 600,000 rows in the table. Of those, over
400,000 have the flag in CAL_IS_BASE_CAL set to 1(YES).
Has anyone run into this issue before, Is this normal & how do you SAFELY
clean this stuff out if it's not. I would guess there should be the Standard
Base Calendars & 1 calendar for each resource.
There are around 4000 projects in the database, 140,000 rows in the Tasks
Column & ~ 700 generic, active & inactive resources combined.
I'm to the point where I'm ready to delete all the resources in the
Enterprise Resource Pool & rebuild it from scratch.
We're running Project Server 2002 with all the current service packs &
patches on top of SQL Server 2000.
Any insight will be most appreciated.