When you execute a GetList SmartObject method from a SQL SmartObject with a large number of records, the K2 Host Server stops, and an error occurs.
The following error occurs: “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.)”.
The SQL connection client implementation reached the default timeout value.
- Ensure you have K2 Five (5.2) installed.
- Download and install the K2 Five (5.2) May 2019 Cumulative Update from K2 Partner and Customer Portal.
- Download the K2 Five (5.2) May 2019 Cumulative Update FP1 from K2 Partner and Customer Portal.
- Install the K2 Five (5.2) May 2019 Cumulative Update FP1 to apply the fix.
After installing the Fix Pack, you can now increase the SQL connection timeout value for the K2 DAC connections to SQL. Increase the “bufferrecords” value to any number in the K2HostServer.exe.config file located in [INSTALLDIR]\Host Server\Bin.