AnsweredAssumed Answered

Deleting Base Calendars

Question asked by pjromano on Jul 23, 2012
Latest reply on Jul 23, 2012 by pjromano
We have 17 base calendars in our Clarity environment - most of which we no longer use or need (due to many historical mergers and de-mergers). We'd like to delete many of these, but am unable to, due to the error:

"PRJ-8144: Cannot delete a calendar which is referenced by a resource."

We have thousands of inactive resources that we're willing to set their base calendar to the standard calendar, in order to eliminate any kind of relationship to a calendar we'd like to delete... But, I'm having little success figuring out where to find these associations.

I tried doing this query, in the hopes of identifying resources that were tied to a specific calendar I was trying to delete. The query returned 0 results, even though I get the above error when I try to delete the base calendar.

SELECT PRCALENDAR.PRBASECALENDARID, SRM_RESOURCES.LAST_NAME, SRM_RESOURCES.FIRST_NAME
FROM SRM_RESOURCES INNER JOIN
PRCALENDAR ON SRM_RESOURCES.ID = PRCALENDAR.PRRESOURCEID
WHERE PRBASECALENDARID = '5001203'


Any suggestions?

Outcomes