Enterprise Calendar DELETE

[VP]

Hello,

My attempt to delete an enterprise calendar in MS Project Server 2007 failed.
One calendar accidently got created into enterprise list & while deleting it
failed with IE popup message saying some of the schedules are associated to
it.

Ran sql query to identify those list of schedules & removed specific
calendar by save & publish on those schedules. However, when attempt to
delete the calendar from enterprise list in PWA failed with same IE message &
SQL query is not showing up any more schedules associated with that
calendar...

Any thoughts...plz reply

 

[Sean Hanson]

Basically, the database query will expose only if a Project is using the
calendar, and this can be different in Draft and Published DB's so you have
to query each. However, we have seen, a calendar not used by the Project nor
as a Task calendar, but only in the Organizer, and this is not exposed in the
DB, you have to open the project, delete it from Organizer and publish. These
are likely stored in the BLOB, Binary Large Object data. Do the list of four
in the popup error message, then try to delete again, then do next four.

We have reversed engineered the delete calendar function and were able to
see a more complete of projects, and this is where we found that Draft has
more projects in it than Published with the calendar we were trying to delete.

You need to look at both calendar guids and base calendar guids.
--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for 2007
Project Server 2007 Archive Tool
2007 ULS Log Reporting
SRS Report Packs

 

[nagamanim]

Basically, thedatabasequery will expose only if aProjectis using thecalendar, and this can be different in Draft and Published DB's so you have
to query each. However, we have seen, acalendarnot used by theProjectnor
as a Taskcalendar, but only in the Organizer, and this is not exposed in the
DB, you have to open theproject, delete it from Organizer and publish. These
are likelystoredin the BLOB, Binary Large Object data. Do the list of four
in the popup error message, then try to delete again, then do next four.

We have reversed engineered the deletecalendarfunction and were able to
see a more complete of projects, and this is where we found that Draft has
more projects in it than Published with thecalendarwe were trying to delete.

You need to look at bothcalendarguids and basecalendarguids.
--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for2007ProjectServer2007Archive Tool2007ULS LogReporting
SRS Report Packs








- Show quoted text -

Hi,

I am trying to find the Enterpise calendar in the database. Looks like
you guys have already done some work on that. COuld you please either
pass me the query or the tables where the enterprise calendar will be
stored.

Thanks.