How do you use cloud databases? Take the survey.
Options
TopQueriesController.GetTopQueries (RedGate.SqlMonitor.UI.Website) threw unhandled exception System.
HamidAr
Posts: 1 New member
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
Tagged:
Answers
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.
Tom Claringbold | Redgate Software
Have you visited our Help Center?