Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[David Morinello]

I have some SQL monitoring tools keeping an eye on GP activity. a few times a month, I see a few SQL alerts for “Blocked Processes”.

It is always the same subgroup of GP users and this call: uprBuildHomepageDataGridTempTable
What the heck is this and why would it cause blocking?

We are on GP 2018 R2 and have never used Payroll or HR modules. All GP Users access the same GP Clients through Citrix. No individual GP Clients are in use.

*********************************************************************************************

Command: AWAITING COMMAND
Program Name:                
Wait Type: OLEDB/Miscellaneous
Maximum Wait Time For Blocked Thread: 494145 Input Buffer: BEGIN DECLARE @stored_proc_name char(43) DECLARE @retstat int DECLARE @param5 int set nocount on SELECT @param5 = 0 SELECT @stored_proc_name = ‘BOARD.dbo.uprBuildHomepageDataGridTempTable’ EXEC @retstat = @stored_proc_name ”, ‘2020.09.27’, ‘2020.10.03’,
Status: sleeping                     
SQL String:
BEGIN DECLARE @stored_proc_name char(43) DECLARE @retstat int DECLARE @param5 int set nocount on SELECT @param5 = 0 SELECT @stored_proc_name = ‘BOARD.dbo.uprBuildHomepageDataGridTempTable‘ EXEC @retstat = @stored_proc_name ”, ‘2020.09.27’, ‘2020.10.03’, ‘##2484634’, @param5 OUT SELECT @retstat, @param5 set nocount on END
*********************************************************************************************

——————————
David Morinello
Senior Dynamics GP Systems Architect
Ascend Learning, LLC
Leawood KS
——————————