Code Fix: The K2 Host Server stops when executing a GetList method on a SQL SmartObject
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
- 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.
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 ServerBin.
