000028184 - 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 Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000028184
Applies ToAffected Versions: 3.6.X
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