Page 99623 not available error when creating a threshold profile

Document ID : KB000033544
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue: 

When creating a threshold profile in CA Performance Center the following error is seen: page 99623 not available.  Also the owner of the threshold profile is read only.

 

Environment:  

CAPM 2.x and 3.x

 

Resolution:

1. Stop all processes 

  • service caperfcenter_eventmanager stop 
  • service caperfcenter_console stop 
  • service caperfcenter_devicemanager stop 
  • service caperfcenter_sso stop 

 

2. Backup the database 

/opt/CA/MySql/bin/mysqldump netqosportal > /tmp/netqosportal.sql 

 

3. Connect to mysql

mysql netqosportal 

 

4. Run the following queries:


a) REPLACE INTO access_rights(AccessRightName, CategoryID, DisplayName, Description) VALUES ('CreateThresholdProfile', 1, 'Create DA Threshold Profiles', 'Lets users create threshold profiles.'), ('AdministerThresholdProfile', 1, 'Administer DA Threshold Profiles', 'Lets users perform threshold profile administration.');


b) REPLACE INTO role_access_rights (RoleID, CategoryID, AccessRightName, Enabled) VALUES

(1, 1, 'CreateThresholdProfile', 'N'),

(2, 1, 'CreateThresholdProfile', 'N'),

(3, 1, 'CreateThresholdProfile', 'Y'),

(3, 1, 'AdministerThresholdProfile', 'Y'),

(4, 1, 'CreateThresholdProfile', 'N'),

(5, 1, 'CreateThresholdProfile', 'N'),

(6, 1, 'CreateThresholdProfile', 'N'),

(7, 1, 'CreateThresholdProfile', 'N'),

(8, 1, 'CreateThresholdProfile', 'N'),

(9, 1, 'CreateThresholdProfile', 'N'),

(10, 1, 'CreateThresholdProfile', 'Y');

 

c) REPLACE INTO access_rights(AccessRightName, CategoryID, DisplayName, Description) VALUES ('AdministerDeviceLifeCycle', 1, 'Admin', 'Lets users perform device life cycle operations.');

 

d) REPLACE INTO role_access_rights (RoleID, CategoryID, AccessRightName, Enabled) VALUES

(1, 1, 'AdministerDeviceLifeCycle', 'N'),

(2, 1, 'AdministerDeviceLifeCycle', 'N'),

(3, 1, 'AdministerDeviceLifeCycle', 'Y'),

(4, 1, 'AdministerDeviceLifeCycle', 'N'),

(5, 1, 'AdministerDeviceLifeCycle', 'N'),

(6, 1, 'AdministerDeviceLifeCycle', 'N'),

(7, 1, 'AdministerDeviceLifeCycle', 'N'),

(8, 1, 'AdministerDeviceLifeCycle', 'N'),

(9, 1, 'AdministerDeviceLifeCycle', 'N'),

(10, 1, 'AdministerDeviceLifeCycle', 'Y');

 

e) INSERT IGNORE INTO role_access_rights (RoleID, CategoryID, AccessRightName, Enabled) SELECT DISTINCT RoleID, 1, 'AdministerDeviceLifeCycle', 'N' FROM role_access_rights;

 

f) INSERT IGNORE INTO role_access_rights (RoleID, CategoryID, AccessRightName, Enabled) SELECT DISTINCT RoleID, 1, 'AdministerDeviceLifeCycle', 'Y' 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);

 

Run the following commands to ensure rights will not be removed again:

  • mysql netqosportal -e "update access_rights set updatedon = unix_timestamp() where updatedon = 0;"
  • mysql netqosportal -e "update role_access_rights set updatedon = unix_timestamp() where updatedon = 0;"

 

5. Start all processes 

  • service caperfcenter_sso start 
  • service caperfcenter_devicemanager start 
  • service caperfcenter_console start 
  • service caperfcenter_eventmanager start 

 

6. Log into CAPC and Retest 

 

You should now be able to successfully create Threshold Profiles and change the associated owner if desired