Disassociate Department and Location being in use in resources

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

You need to transfer some locations from department X to department Y.
You tried to remove locations from department X but got error message 'REVMGR-20161:Cannot disassociate location and department because they are being used in the resources'.

Resolution

1. This error indicates that the location and department association has been used for one or more resources. To find out which resources have references of this association, please run the following query:

select id from PAC_MNT_RESOURCES
where LOCATIONID = 'THE_ID_FOR_YOUR_LOCATION'
and DEPARTCODE = 'THE_ID_FOR_YOUR_DEPARTMENT'

2. Note the id returned. Then for each one of the ids from the results above, run the following query, this will list the resource details.

select * from SRM_Resources
where id = 'one of your resource id'

3. Navigate to the Clarity - Resource - Financial Properties of the resource from the above queries and choose a different location or department. Once this has been done for all the resources returned from the first query above, you will be able to disassociate the location and the department.