Kepware Datalogger TCP Provider: An existing connection was forcibly closed by the remote host

[Tiago_Silva_PT]

Hello Community,

I am using KepserverEx 6.17 with Datalogger connecting to a SQL Server.

I have a strange error that happens once or twice a week, where the datalogger cannot query the recordset due to the following error:

Unable to query recordset on Log Group XXXX. Reason: TCP Provider: An existing connection was forcibly closed by the remote host. Communication link failure

I already went through the knowledge base and apparently it is related to a lock on the table defined in the log group.

After a couple of weeks deep diving in the SQL Server I cannot find any lock on the mentioned table during the time this errors happen. I simply cannot find a reason for this behaviour.

Has anyone also faced this issue? What could be the problem originating it?

Any suggestions would be appreciated.

Thanks.

[VladimirN · Accepted solution]

Take a look - "Configuration project performance optimization in PTC Kepware Products": https://www.ptc.com/en/support/article/CS292754