Error: 'Cannot insert duplicate key row in object 'dbo.arc_users' with unique index 'IX_arc_users_hash_unique' when running MAUpdateUsers and the arc_users table contains 2 rows for the same user, but different domain names

Versions / Builds Affected

20131111, 20140616

Status

Resolved

Problem Summary

Error: 'Cannot insert duplicate key row in object 'dbo.arc_users' with unique index 'IX_arc_users_hash_unique' when running MAUpdateUsers and the arc_users table contains 2 rows for the same user, but different domain names

TT / JIRAID

2562

How to Identify

Customer runs MAUpdateUsers and gets the error: 2014-09-05,12:57:54,605,1,"#000015E8","#00000001","error ","errors","error: Cannot insert duplicate key row in object 'dbo.arc_users' with unique index 'IX_arc_users_hash_unique'.;The statement has been terminated." Confirm in SQL that the arc_users table contains multiple rows for the same user, but with a different domain name part. For example: 1. Run the query: SELECT * FROM arc_users 2. The result set would show 2 rows in which the userName column read: Row1: OLDDOMAIN\Administrator Row2: NEWDOMAIN\Administrator The important point is that the domain name part differs, but the user part is the same.

Workaround / Fix Details

FIX A new version of MAUpdateUsers for MailArchiver 2014 build 20140616 has been uploaded to the FTP. MAUpdateUsers.exe was built on 2014-09-11. WORKAROUND A workaround is available, but best to be used only together with PSG as data in the DBs must be altered. DO NOT USE THIS QUERY UNLESS YOU ARE 100% SURE WHAT YOU ARE DOING AND A BACKUP EXISTS (ESP. OF THE DB) BEGIN TRANSACTION; UPDATE arc_users SET userName=REPLACE(userName,'OLDDOMAIN\','NEWDOMAIN\'); COMMIT TRANSACTION;

Required Actions

Use latest version of MAUpdateUsers (.exe created on 2014-09-11 or later) for MailArchiver 2014 build 20140616 or newer