When attempting to inactivate a Role via the CA Service Desk Manager (CA SDM) web interface, receive following error: AHD05481:Cannot inactivate this Role; it is currently assigned to a Contact

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

In order to inactivate a Role, there cannot be any users/contacts assigned to the role.

Perform the following from the CA SDM Primary server:

1. From a command prompt, run the following command to determine the ID of the role you wish to inactivate
   
   pdm_extract -f "select id from usp_role where name = '<ROLE NAME>' "
   For example: pdm_extract -f "select id from usp_role where name = 'L1 Analyst' "
   It will return the id - for example 10008.
   
   
2. Run the following command to list all contacts with this assigned role
   
   pdm_extract -f "select contact from usp_cnt_role where role_obj = 10008"
   
   
3. Use the UUID from the list above to determine the actual userid
   
   pdm_extract -f "select userid from ca_contact where id = U'9B06B4F05C394045BFB936DD410258EB'"
   
   
4. Via the CA SDM web interface select the above user via Contact Search, and unassign the role from the user(s). You will then be able to inactivate the Role successfully.

Environment

Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration
Component: