000028184 - Z: ARCHIVE THIS ARTICLE. KB-1187 - User records under user tab and people pickers do not display

Document created by RSA Customer Support Employee on Jun 15, 2016Last modified by RSA Customer Support on Sep 12, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000028184
Applies ToARCHIVE THIS ARTICLE.

Affected Versions: 3.6.X
IssueARCHIVE THIS ARTICLE. 
ResolutionThis problem has been resolved in versions 3.6.3 and above.


To verify the problem (as AVUSER) run this sql: (as the Aveksa user)

SQL> select count(*) from T_AV_OBJECT_CERTIFICATION WHERE ID IN (SELECT ID FROM (SELECT
MIN(ID) AS ID, COUNT(*) AS COUNT FROM T_AV_OBJECT_CERTIFICATION WHERE
OBJECT_TYPE = 'User' GROUP BY OBJECT_ID ) WHERE COUNT > 1);

If the query returns anything other than zero then the solution is to run this query,

SQL> DELETE FROM T_AV_OBJECT_CERTIFICATION WHERE ID IN (SELECT ID FROM (SELECT
MIN(ID) AS ID, COUNT(*) AS COUNT FROM T_AV_OBJECT_CERTIFICATION WHERE
OBJECT_TYPE = 'User' GROUP BY OBJECT_ID ) WHERE COUNT > 1);

You may have to run the delete SQL twice to remove the incorrect records

Attachments

    Outcomes