Article Content
Article Number | 000028874 |
Applies To | Affected Versions: 3.6.X |
Resolution | When 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) |