When Payroll batch posting happens along with other batch posting. We get a lot of blocking alerts.
The alerts are coming from proc call [dbo].[bspHQTCNextTrans] and please check the statements below
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
UPDATE dbo.HQTC
SET LastTrans = LastTrans + 1
OUTPUT inserted.LastTrans
| Company | McKinstry |
| I need it... | 1 month |
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.