Introduction

Your K2 environment may have duplicate roles in the database, which could cause your upgrade to K2 Five 5.2 to have issues when editing roles. This article will describe how to run a SQL Script to identify duplicate roles in your environment prior to upgrading to K2 Five 5.2.

Steps to run the SQL Query

This script will query your role tables and report any duplicate named roles. It will not make any changes to your K2 database. In order to determine if you have duplicate named roles in your K2 database, perform the following steps:
  1. Download the attached Check for Duplicate Roles.zip file and extract it.
  2. Run the Check for Duplicate Roles.sql query in SQL Server Management Tools against your K2 database.
  3. The first dataset will display all of the roles in your environment. An example is shown below:
    Image
  4. The third dataset will display any duplicate roles. An example is shown below:
    Image
If this dataset is not blank, your upgrade to K2 Five 5.2 will have issues when editing roles. Do not upgrade to K2 Five 5.2 at this time. We are working on resolving this issue and will release a new installer.