kbt132566

Issue

The following error frequently gets logged in the K2 HostServer error logs and the Windows Event Viewer:

"2936429982","2017-06-12 18:45:25","Error","EventBus","7498","General","ServerDAL.RefreshService","7498 An error has occurred: System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at SourceCode.EventBus.Server.ServerDAL.RefreshService() ClientConnectionId:1187a19a-23b2-42b5-af32-0de82ccac41d Error Number:-2,State:0,Class:11","anonymous","0.0.0.0","SERVER:C:Program Files (x86)K2 blackpearlHost ServerBin","2936429982","b0b8541973b84c68bdd0d0f886410e50",""

Symptoms

Troubleshooting Steps

There are a few workarounds you can try to resolve the error, but there is no definite solution for this issue:

1. Decrypt your K2HostServer.exe.config file and add "Max Pool Size=200" to the following Connection String, so it appears like this:

<add name="HostserverDB" connectionString="Data Source=DLX;Initial Catalog=K2;integrated security=sspi;Pooling=True;Max Pool Size=200"
providerName="K2BLACKPEARL" />

2. If the "Domain Users" AD Group is being used in Process Rights for certain processes, consider switching to Everyone (a special K2 group).

- This has to do with the "Domain Users" AD Group being a group in AD, which K2 needs to synchronize and keep track of in the Identity table. It includes a lot of users, so in order for K2 to synchronize every time a user tries to start a process, it will use a lot of resources. If the K2 special group "Everyone" is used, then there should be no resources being used because every user will get authenticated by K2.

3. Follow this article to clear your completed Eventbus tables:
https://help.k2.com/onlinehelp/k2blackpearl/devref/4.6.11/default.htm#EventBussLogging.htm

- The stored procedure will clear out the history log tables of the Eventbus when they become too full. If the numbers approach +-10,000 then you can consider running that stored procedure with an input property of "4" (to clear out only the completed entries).

4. This issue could also be performance related. For example: 

   a) Trying to pull a large set of records
   b) Index fragmentation
   c) Lack of proper indexes.

- Is regular index maintenance being performed?
- If it happens frequently, you could run an SQL profiler trace on the K2 and application database to see what might be executing when the error appears.