LEGACY CONTENT
This article refers to legacy products, components or features. Therefore, the content in this article is offered "as is" and will no longer be updated. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Introduction

After installation of K2 blackpearl 0807 with KB000370 in a distributed environment, the resolution of Roles may cause various database connectivity problems. One or more of the following errors can be seen in the K2 Server console:
  • "Error 1 Login failed for user ’NT AUTHORITY\ANONYMOUS LOGON’;
  • Info 7997 Database server busy;
  • Error 7498 An error has occurred: System.Data.SqlClient.SqlException: Login failed for user ’NT AUTHORITY\ANONYMOUS LOGON’.";
  • Database is not online

The exact error message will vary depending on the environment.
 

Error Scenario

Note: The steps below describe one scenario under which this error may occur. The steps below are simplified and not all the steps will be shown or described.
  1. Create a large role in K2 Workspace Management Console.
  2. In the HostServer database -> Role table find the role and enable caching by entering an "Interval time" and setting the "IsCacheable" column value to "True".
  3. Set "IsDynamic" to false.
  4. Start the K2 Server.
  5. Start the SQL Management console.
  6. Load the roles and select the role you created.
  7. Set the role to resolve 5 times
  8. Click the button to resolve the roles. This will take a few minutes as the role is resolving from Active Directory.
  9. Open "Task Manager".
  10. Wait for the role to resolve 5 times.
  11. When K2 Server caches the role, a "spike" in the CPU usage coming from K2HostServer.exe. can be seen.

Error Messages

The following error message relates to this issue:
  • Error 1 Login failed for user ’NT AUTHORITY\ANONYMOUS LOGON’;
  • Info 7997 Database server busy;
  • Error 7498 An error has occurred: System.Data.SqlClient.SqlException: Login failed for user ’NT AUTHORITY\ANONYMOUS LOGON’;
  • "Database is not online” (shown below)

 

Error Resolution

This Hotfix is contained within the latest K2 blackpearl 0807 Update. Install the update package to resolve the error.

The latest K2 blackpearl 0807 Update is available as an independent installation package which can be found here: https://portal.k2.com/downloads/bp/default.aspx