Issue Description

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.

Error Message

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.)”.

Cause

The SQL connection client implementation reached the default timeout value.

Resolution

  1. Ensure you have K2 Five (5.1) installed.
  2. Download and install the K2 Five (5.1) November 2018 Cumulative Update from K2 Partner and Customer Portal.
  3. Download the K2 Five (5.1) November 2018 Cumulative Update FP15 from K2 Partner and Customer Portal.
  4. Install the K2 Five (5.1) November 2018 Cumulative Update FP15 to apply the fix.

Considerations

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.