SQL Blocked Process – uprBuildHomepageDataGridTempTable

  • SQL Blocked Process – uprBuildHomepageDataGridTempTable

    Posted by David Morinello on October 1, 2020 at 10:23 am
    • David Morinello

      Member

      October 1, 2020 at 10:23 AM

      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
      ——————————

    David Morinello replied 3 years, 4 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!