000028874 - KB-1163 - No records displayed on Unified User tab

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 Number000028874
Applies ToAffected Versions: 3.6.X
ResolutionWhen certain table counts are greater than 1 in value, no data will be displayed.
Query used to identify the issue –
 
SELECT OBJECT_ID FROM (SELECT OBJECT_ID, COUNT(*) AS COUNT FROM T_AV_OBJECT_CERTIFICATION WHERE OBJECT_TYPE = 'User' GROUP BY OBJECT_ID ) WHERE COUNT > 1

Query to fix the issue –
 
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)

Attachments

    Outcomes