Xuber_TGB
Nintex Newbie

How to determine the DB version of a K2 DB

Hi,

 

Our customer recently installed the following MS updates:

 

1.kb5001849

2.kb5003636

3.kb5003696

4.kb5003697

 

Now the K2 service is failing to start. When I look at the HostServer log files I see this, which apparently means the K2 DB version isn't matching the installed version:

"45817334","2021-06-16 14:19:26","Error","General","0","ErrorMessage","SourceCode.Hosting.Server.Runtime.HostLoadBalancedServerManager.Poll","0 System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'hServerUpdate' expects parameter '@EnvironmentGUID', 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()

 

The customer doesn't think anything changed in the DB but to be sure is there a way to check what version the DB is at to compare with the installed K2?

Labels: (1)
0 Kudos
Reply
1 Reply
khanh
Nintex Employee
Nintex Employee

Re: How to determine the DB version of a K2 DB

Hi Xuber_TGB,

 

Perhaps, you can take a look at the [Hostserver].[Configuration] table and look for the following variable tokens [ProductVersion] and [CurrentDBVersion].

0 Kudos
Reply