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

gudakrist

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

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

gudakrist

Thank's Alex , I'll post an update after upgrade.

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

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

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