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

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

Answers

  • 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.
    Kind regards

    Tom Claringbold | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.