Client sessions returns error "the connection to the server is no longer responding"

Toni_Bussola

This is occurring with a job is running on the job schedular at around the same time that a back up is running on the SQL server. Is there a timeout setting that can be adjusted to allow for a possible slow response when the backup is running.

ricardopaiva

There’s a SQL Timeout setting in NAV Server.
Default value is 30 minutes. It means that the server will close the connection if it takes longer than 30 minutes.
Does that job takes longer that 30 minutes to run?

Please refer to the link:

https://docs.microsoft.com/en-us/dynamics-nav/configuring-microsoft-dynamics-nav-server

Search for ”SQL Command Timeout“.

Toni_Bussola

Hi Ricardo. Thank you for your response, job schedule log is indicating that job took about 40 minutes (instead of 2) at around that time. Will investigate with the thought that records may have been locked by another user.