A view definition has been created:
select cn, uid_adsgroup
from adsgroup
where (cn like 'c%')
The consistency check on this view results in the following error:
"Table of type U or R with wrong PK definition"
When in SchemaExtension.exe and creating a new view, one may first specify any SQL query. On the next wizard page columns can be made into Foreign Keys (FKs). On the following page properties of the columns may be viewed and changed. Initially, the Schema Extension wizard takes the first column as Primary Key (PK) of the view (as noted by the key icon!)
The PK is important so that the object layer has a selection criterion. Of course, this must be unique and correspond to the PK syntax (i.e. a UID format of type nvarchar(38)).
The view should be deleted and created again, so that the UID_ADSGroup coulmn is first and not a FK but a PK. Finally, ADSGroups should be selected here and not be referred to:
select uid_adsgroup, cn
from adsgroup
where (cn like 'c%')
© 2025 One Identity LLC. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center