Unable to load Activity Logs Report
Afternoon,
We are trying to make use of the Activity Logs Report in RDM, but each time this fails to load with an Unexpected Exception. The progress bar will appear when trying to load this report, but after 20-30 seconds the Unexpected Exception error window appears and the details for this read,
Devolutions.RemoteDesktopManager.Business.TryGoOfflineException: Unexpected exception ---> System.Net.WebException: Unexpected exception
at Devolutions.Server.ApiWrapper.RestClient.GetResponse[T](HttpWebRequest request)
at Devolutions.RemoteDesktopManager.Business.DataSources.RDMSWebApiClient.cea5ed782d590a019f81f2bdfbef26657()
at Devolutions.RemoteDesktopManager.Business.DataSources.RDMSWebApiClient.c5f4f6c72c053c0cd60a62abeeaa43fdf[cb75a0a5d15a1ad8b8a8a5e57cca214a3](c31561c0d54939abd223ac7c0cf30e7e6`1 c6cc9ab02b2ea9ccd42c7c0497677bcc2, ExecuteActionLogMode c92f46156e371279a4f61cd5822be5fee)
--- End of inner exception stack trace ---
I have also attached the errors which RDM emails us when this happens (seems to be a different SQL Exception error each time).
We are running,
- RDM version: 2020.2.19
- DPS Version: 2020.2.9.0
- Data Source: DPS Server with SQL
I have tried running this from different clients, and from the server that runs DPS itself and also tried using the Activity Logs Report via the web portal version of RDM, but same issue.
Any help on this would be greatly appreciated.
Many Thanks
Rich
RDM Errors.txt
All Comments (3)
Hello,
Thank you for reporting this problem.
It seems that DVLS is unable to retrieve the logs from the ConnectionLog table because the number of records is too important. Could you please verify the number of records in the ConnectionLog table in the SQL database? You can get the information with the Disk Usage by Top Tables report in SQL Server Management Studio application.
You could also try to adjust the connection string parameter as explained on this page to prevent SQL timeouts.
https://kb.devolutions.net/dps_preventing_sql_timeouts_with_dps.html
Best regards,
Érica Poirier
Hi
Erica,
Thanks for getting back to me so quickly on this.
I am taken a look at the SQL table stats as requested, and we found the below,
I have also amended the SQL Connection timeout options as per that linked article, but that hasn't appeared to make a difference I am afraid. I would imagine that we need to cear down the ConnectionLog table, given its size?
Thanks
Rich
Hello,
Wow 2,8 million records! That's a lot. So yes it will be important to reduce the number of records in order to get the Activity Log report to work.
Have you configured the Email Notification feature? I see that the SubscriptionEvent table contains 642K records.
Could you please send an email to ticket@devolutions.net and I will send you a SQL statement to help you archive or delete the number of records?
Best regards,
Érica Poirier