I am trying out SQL Watch for the first time (v4.2 - 188.8.131.52234). I am using SQL Server 2019 Dev edition but I cannot get the blocked process report to email.
There seems to be a mismatch between the report definition and the view vw_sqlwatch_report_fact_xes_blockers. This mismatch also appears to affect the Blocking tab in the dashboard with all the panels showing an error “Something’s wrong with one or more fields”.
All I have done to the installation is change the email address in action_exec field for action id -1 and set the action to enabled. Database mail is enabled and is verified as working with the command text in the action_exec field.
When I force some blocking to occur the app log has the following errors
usp_sqlwatch_internal_process_checks - Errors when processing Action (Id: -8) for Check (Id: -2)
usp_sqlwatch_internal_process_actions - Action (Id:-8) calling Report (Id: -3)|
usp_sqlwatch_internal_process_reports- Error when executing Template Report (usp_sqlwatch_internal_query_to_html_table), @report_batch_id: NULL, @report_id: -3
usp_sqlwatch_internal_action_queue_update - Incorrect syntax near ‘,’. (@queue_item_id: 1)