SQL Query to cleanup Management Reporter Failed Report Queue Status
Use the ManagementReporter database
Next look at the “SubMessage” column and see if it is blank. Any of the failed reports will have content in the submessage column as to why it failed. Do a simple query to find any rows where the Submessage column is not BLANK.
This will give you a list...
select * from RepositoryMessage where SubMessage <> ''
This will delete them...
delete from RepositoryMessage where SubMessage <> ''