Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Oct 10, 2023 10:16:45 AM
Jun 20, 2022 4:38:05 AM
Inactive TCP/IP connections to SQL Server can sometimes be closed by your router or firewall. This will give your task a recoverable environmental error. Parameters in the Windows Registry can be set to send transmissions for the connection to keep it active.
00026464: 2021-10-27T05:08:24 [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: 08S01 NativeError: 10054 Message: [Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host. [1022502] (ar_odbc_stmt.c:3977)
Qlik Replicate
SQL Server as a source
Windows environment
Registry parameters can be added on the Replicate Server with Registry Editor.
Add the following dword keys and the specified decimal values:
Follow these steps to modify the registry manually:
For more information on the Windows registry parameters, please refer to Microsoft documentation:
Description of Windows TCP features
KeepAliveTime