Versions / Builds Affected20131111, 20140616
Problem SummaryError: '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 / JIRAID2562
How to IdentifyCustomer 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.
1. Run the query: SELECT * FROM arc_users
2. The result set would show 2 rows in which the userName column read:
The important point is that the domain name part differs, but the user part is the same.
Workaround / Fix DetailsFIX
A new version of MAUpdateUsers for MailArchiver 2014 build 20140616 has been uploaded to the FTP.
MAUpdateUsers.exe was built on 2014-09-11.
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)
UPDATE arc_users SET userName=REPLACE(userName,'OLDDOMAIN\','NEWDOMAIN\');
Required ActionsUse latest version of MAUpdateUsers (.exe created on 2014-09-11 or later) for MailArchiver 2014 build 20140616 or newer