Usage Logs - Query Timeout

Usage Logs - Query Timeout

avatar

Hi there

When I run the "Activity Logs" report, i get the following error:

forum image

I use the most recent Devolutions Server version.

Best regards, John

All Comments (3)

avatar

Hello,

Could you please follow the instruction on this article and try again?
https://kb.devolutions.net/dps_preventing_sql_timeouts_with_dps.html

It is also possible that the number of records in the database is too important. The Cleanup Logs feature helps to keep the database healthy.
https://helpserver.devolutions.net/webinterface_cleanuplogs.html

Let us know if you can get it working after applying those solutions.

Best regards,

Érica Poirier

avatar

Hello Erica

I already increased the SQL timeout to 90 seconds, this had no effect.
Log files archiving is active, logs older than 6 months are beeing archived.
Something else I can do?

Best regards, John

avatar

Hello John,

Thank you for your feedback.

It seems that the ConnectionLog table contains too many records in the last 7 days and that raise the timeout error when trying to open the Activity Logs report.

I think it would be easier to troubleshoot this problem in a remote session. Please open a new ticket at service@devolutions.net and add a reference to this forum's thread. We will send you a link to book the support session.

Best regards,

Érica Poirier