Hi,

This query below is frequently causing a head block in our Workflow database:

(@bps_report_id nvarchar(36))select count(*), SUM (Convert(bigint, datediff(ss, bps_start_date, bps_end_date))) as total from bp_step where bps_report_id = @bps_report_id and bps_end_date is not null

 it always blocking this query:

@bpp_end_time datetime,@bps_id bigint) update bp_participant set bpp_end_time =@bpp_end_time where bps_id =@bps_id and bpp_end_time is null

When this happens, workflow stops and we have to kill the head block in order for workflow to start processing again.

Please provide us with more information about these queries. It would help us try and pinpoint which workflow is causing the problem.  Information such as:

• What are these queries doing?
• Is it caused by an object in Workflow or is it a SQL store procedure?
• If a block happens, is there a SQL query we can run against the workflow DB to find out which WF is currently having the issue?
• Since we had to terminate the SQL lock, would an error entry be logged anywhere?

Thanks