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

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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?

Environment

Release : 16.0.2

Component : CA PPM APPLICATION

Resolution

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.