Can't unretire a device in CAPC

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Under certain conditions including removing data sources in CAPC the "Administrator Life Cycle" role right can end up being removed. The issue is fixed in the current release and should not occur again. if the issue has already occurred the solution in this article will put the role back in the CAPC system. 

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Resolution

1) Backup the CAPC netqosportal database 

2) Stop the CAPC processes.

3) Log into the netqosportal database

4) Run the following SQL commands:

REPLACE INTO access_rights(AccessRightName, CategoryID, DisplayName, Description, UpdatedOn) VALUES ('AdministerDeviceLifeCycle', 1, 'Admin', 'Lets users perform device life cycle operations.', UNIX_TIMESTAMP()); REPLACE INTO role_access_rights (RoleID, CategoryID, AccessRightName, Enabled, UpdatedOn) VALUES (1, 1, 'AdministerDeviceLifeCycle', 'N', UNIX_TIMESTAMP()), (2, 1, 'AdministerDeviceLifeCycle', 'N', UNIX_TIMESTAMP()), (3, 1, 'AdministerDeviceLifeCycle', 'Y', UNIX_TIMESTAMP()), (4, 1, 'AdministerDeviceLifeCycle', 'N', UNIX_TIMESTAMP()), (5, 1, 'AdministerDeviceLifeCycle', 'N', UNIX_TIMESTAMP()), (6, 1, 'AdministerDeviceLifeCycle', 'N', UNIX_TIMESTAMP()), (7, 1, 'AdministerDeviceLifeCycle', 'N', UNIX_TIMESTAMP()), (8, 1, 'AdministerDeviceLifeCycle', 'N', UNIX_TIMESTAMP()), (9, 1, 'AdministerDeviceLifeCycle', 'N', UNIX_TIMESTAMP()), (10, 1, 'AdministerDeviceLifeCycle', 'Y', UNIX_TIMESTAMP()); INSERT IGNORE INTO role_access_rights (RoleID, CategoryID, AccessRightName, Enabled, UpdatedOn) SELECT DISTINCT RoleID, 1, 'AdministerDeviceLifeCycle', 'N', UNIX_TIMESTAMP() FROM role_access_rights; INSERT IGNORE INTO role_access_rights (RoleID, CategoryID, AccessRightName, Enabled, UpdatedOn) SELECT DISTINCT RoleID, 1, 'AdministerDeviceLifeCycle', 'Y', UNIX_TIMESTAMP() FROM role_access_rights WHERE RoleID IN (SELECT rd.RoleID FROM role_definitions rd INNER JOIN role_definitions_i18n rdi18n ON (rd.RoleID = rdi18n.RoleID) WHERE rdi18n.CultureID = 'en-US' AND rdi18n.Name = 'Administrator') ON DUPLICATE KEY UPDATE RoleID = VALUES(RoleID), CategoryID = VALUES(CategoryID), AccessRightName = VALUES(AccessRightName), Enabled = VALUES(Enabled), UpdatedOn = UNIX_TIMESTAMP();

5) restart CAPC processes