Code Fix: The K2 Host Server stops when executing a GetList method on a SQL SmartObject

  • 16 February 2021
  • 0 replies
  • 3 views

Badge +9
 

Code Fix: The K2 Host Server stops when executing a GetList method on a SQL SmartObject

KB003170

PRODUCT
K2 Five 5.3
K2 Five (5.3) Fix Pack 3
BASED ON
K2 Five 5.3

 

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.3) installed.
  2. Download the K2 Five (5.3) FP3 from K2 Partner and Customer Portal.
  3. Install the K2 Five (5.3) FP3 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.

 


0 replies

Be the first to reply!

Reply