This type of error is related to data issues within the KT SKELETONS MDB tables.

The READ_PGROUP and WRITE_PGROUP fields contain the groups of CA SDM groups that are eligible to read/edit the Knowledge Document.

If the groups identified by the READ_PRGROUP and WRITE_PGROUP values are not found within the control P_GROUPS MDB table, then the Knowledge Document cannot be accessed since the security validation cannot be performed.

The proposed solution will identify and address KT Documents where the group security permissions are out of sync.

Environment:

Service Desk Manager

All Supported Operating Systems

Resolution:

Run the following SQL queries against the MDB

select id from SKELETONS where READ_PGROUP !=0 AND READ_PGROUP NOT IN (select id from P_GROUPS)

select id from SKELETONS where WRITE_PGROUP !=0 AND WRITE_PGROUP NOT IN (select id from P_GROUPS)

select id from O_INDEXES where READ_PGROUP !=0 AND READ_PGROUP NOT IN (select id from P_GROUPS)

select id from O_INDEXES where WRITE_PGROUP !=0 AND WRITE_PGROUP NOT IN (select id from P_GROUPS)

If any rows are returned from the above queries, perform the following

1. Take a backup of the SKELETONS and O_INDEXES MDB tables by running the following commands via a command prompt on the SDM server