K2 Server will not start -Procedure or function 'hServerUpdate' expects parameter '@StartUp', which was not supplied.

Topic

The follow error is seen in event log when trying to start K2 Service.

0 System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'hServerUpdate' expects parameter '@StartUp', which was not supplied.
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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at SourceCode.Hosting.Server.Runtime.HostLoadBalancedServerManager.Poll()
ClientConnectionId:4b47c9f8-20a8-4c76-8e3a-ce8c3bdbe568
Error Number:201,State:4,Class:16

Instructions

This error typically indicates that K2 Server and K2 Database are out of sync.   In this example, K2 server is version 4.7, but K2 DB is for version K2 Five (5.4).

Additional Information

This could be caused by K2 server was restored using 4.7 snapshot.  Restore K2 server to match the version of K2 Database will resolve the issue or vice versa.

Related Links

Labels: (1)
Version history
Revision #:
2 of 2
Last update:
‎05-10-2021 04:17 PM
Updated by:
 
Contributors