Hi,
I am trying out SQL Watch for the first time (v4.2 - 4.2.0.28234). 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)
Version 4.3 has fixed the Blocking tab in the dashboard. But the blocked process report is still broken. Any ideas, anyone see the same or similar behaviour?
Apologies for that. You probably noticed the blockers have been redesigned recently and I’m making few more tweaks for version 5 so it’s currently work in progress.
If you have requests or ideas what you’d like to see in the blocked process report or how you’d want it to work I’m all ears.