1. Home
  2. Inventory and Item Tracking Software
  3. BACKTRACK
  4. BACKTRACK Problems
  5. BACKTRACK Migration Issue – Duplicate Security Groups – BACKTRACK Problem

BACKTRACK Migration Issue – Duplicate Security Groups – BACKTRACK Problem

Summary

This article explains a BACKTRACK problem that complicates migration by creating duplicate records, and details how to resolve the issue.

Symptoms

Duplicate records appear for each security group.

Explanation

In migrations from older BACKTRACK versions, (v6 or earlier) we often see duplicate records created for each Security Group in BACKTRACK. This will trigger errors every time BACKTRACK needs to access the user information.

Solution

The duplicates need to be removed. Since this duplicate is a duplication of the key field (Security Group name), SQL Management Studio IS NOT an effective way to remove it.

A better approach is to create two new groups (e.g. Administrator1 and Everyone1) and then delete the old groups (e.g. Administrator and Everyone). When the old ones are deleted, this will force BACKTRACK to move all the users assigned to the old Security Group to the new one.

Additional Comments

Enter additional comments here

Updated on September 15, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support