How can we help you today? How can we help you today?

Extended event 208 with: Invalid object name '##redgate_sqlmonitor_querywaitstats***

I've just started testing the monitoring of suspicious errors by turning on extended event 208 and the first error that pops up is this one:

Invalid object name '##redgate_sqlmonitor_querywaitstats_********__**'.
Caused by "SQL Monitor - Monitoring"

Has anyone stumbled onto this as well?

Best regards

gudmundur
Gudmundur Annas Kristjansson
0

Comments

5 comments

Sort by
  • Alex B
    Hi gudakrist,

    This issue should be fixed from version 11.2.1.  You can get the latest version here: https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_11.2.8.13937.exe 

    Please do let me know if you are still seeing this on a version 11.2.1 or later!

    Kind regards,
    Alex
    Alex B
    0
  • gudakrist
    Thank's Alex , I'll post an update after upgrade.
    gudakrist
    0
  • gudakrist
    Hi again Alex
    We have finally upgraded to 12.1.2 and we are still getting the error:
    Cannot drop the table '##redgate_sqlmonitor_querywaitstats_a_XXXXXXXXXXX__pa4

    The other error     Invalid object name '##redgate_sqlmonitor_querywaitstats_********__**'. has not popped up
    gudakrist
    0
  • Alex B
    Hi @gudakrist,

    The team have made a change they believe will fix this new issue of "Cannot drop the table..." from v12.1.10+ - here is a link for the latest version 12.1.12 https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_12.1.12.25952.exe 

    Kind regards,
    Alex
    Alex B
    0
  • AsafC
    Hi,
    after upgrading to Version 14.0.20 
    This error started to appear:
    There is already an object named '##redgate_sqlmonitor_querywaitstats_

    Thanks, Asaf
    AsafC
    0

Add comment

Please sign in to leave a comment.