When trying to delete a calendar, an error is received "PRJ-8144: Cannot delete a calendar which is referenced by a resource." How can I determine who has this calendar?
Release : 16.0.2
Component : CA PPM APPLICATION
A query like this may help you in identifying which calendar is associated to each user:
SELECT r.last_name , r.first_name , C1.prname , c2.prname FROM srm_resources r JOIN prj_resources p on p.prid = r.id JOIN prcalendar C1 on C1.prid = p.prcalendarid LEFT JOIN prcalendar C2 on C2.prid = C1.prbasecalendarid
Use this information to disassociate the calendar from the user.