Quality rules violations are not loading in AED

If violations are not loading for almost all the rules in AED as shown below then please check the points mentioned:

This can be due to corruption in table - VIEWER_ACTION_PLANS_LOG

This table is suppose to have one entry i.e. last log date/time entry. Run the below query in CB:

Select * from VIEWER_ACTION_PLANS_LOG;

If above query returns more than one row then this table data is corrupted. To remove this corruption please delete one of the entry from this table data and make sure only one entry is there in the particular table.

Cause of this issue is, when Rest-Api loads violation details it will load action plan data as well. If there is any issue with these action plan data it will affect the data loaded by Rest-Api.