TopQueriesController.GetTopQueries (RedGate.SqlMonitor.UI.Website) threw unhandled exception System.

HamidAr

Hi,

We upgrade SQL Monitor to last version (12.1.41) and after upgrading when we work with top query section in redgate monitor ,below error appeares in top query section.

Until we reset "SQL Monitor Base Monitor" service, it don't work anymore.

Event Logs in windows:

2022-11-07 11:46:04,492 [    7] ERROR RedGate.SqlMonitor.UI.Website.Controllers.TopQueriesController - Executed: RedGate.SqlMonitor.UI.Website.Controllers.TopQueriesController.GetTopQueries (RedGate.SqlMonitor.UI.Website) threw unhandled exception System.Exception: An unexpected error occured

 ---> RedGate.SqlMonitor.RPC.Client.Exceptions.RpcNoResultException: System.OverflowException was thrown by method Query on service DataPresenterRpcServer:

System.OverflowException: Value was either too large or too small for a Decimal.

Our windows server version : 2019 Datacenter

Please guid me to fix this issue.

Related event logs have been attached

Best regards

Tom_C

Hi Hamid,
 
Many thanks for your help in the internal ticket, posting an additional response here for anyone else who searches for this issue in the forum.

This was a wider issue, a fix for this issue was included in release (v12.1.42) which can be downloaded here.

Please let us know if you require any further assistance with SQL Monitor.