mdb Tables for Knowledge Categories Role Permissions

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

When knowledge administrator tries to modify the knowledge category permissions to role based and gets into some errors like Error 1 attempting to
set READ_GROUP_LIST to "10016,400003": AHD04507:Trigger Error,

What are the mdb tables that store the these info in order to trouble shoot the problem. Sometime the data integrity issue is the reason the error occurs and in that case, DBA would need to perform data clear-up. 

What mdb tables store info for new Knowledge Category with role based permissions?

Environment

Release:  All Releases
CA Service Desk Manager

Resolution

The info is stored in two mdb tables: usp_role_pgroup and P_GROUPS with this schema in usp_role_pgroup 

pgroup               SREL -> P_GROUPS.id TENANCY_UNRESTRICTED

This means, for every entry in P_GROUPS table, there should be an entry in usp_role_pgroup table and vice versa.

If this is not true, errors like "Error 1 attempting to set READ_GROUP_LIST to "10016,400003": AHD04507:Trigger Error" will occur when knowledge administrator performs knowledge category role permission changes.

Additional Information

Please take a full back up of the database before making any changes, and test the changes in non-prod environment before attempting in prod.