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

book

Article ID: 19231

calendar_today

Updated On:

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: