Error: 'Violation of PRIMARY KEY constraint 'PK_arc_msg_tags'. Cannot insert duplicate key in object 'dbo.arc_tags_msg'' when using MAUpdateUsers

Versions / Builds Affected

20150218 (and probably older)

Status

Open

TT / JIRAID

3008

How to Identify

Debug logging of the MAUpdateUsers tool must show the very same constraint error (except for the duplicate key value). Here is the complete debug logging flow: 2015-08-06,17:01:46,132,1,"#000012A0","#00000003","info ","MAUpdateUsers","*Updating MS SQL database sqlmanage\2013 Jan - Dec*" 2015-08-06,17:01:48,145,1,"#000012A0","#00000003","info ","MAUpdateUsers","Checking DB schema..." 2015-08-06,17:01:48,145,1,"#000012A0","#00000003","info ","MAUpdateUsers","Schema version:" 2015-08-06,17:01:48,145,1,"#000012A0","#00000003","info ","MAUpdateUsers"," Supported: >45" 2015-08-06,17:01:48,145,1,"#000012A0","#00000003","info ","MAUpdateUsers"," Current store: 65" ... 2015-08-06,17:01:54,978,1,"#000012A0","#00000003","info ","MAUpdateUsers",">Processing - 22ff7850a81d96418c5f117bf052d095, -4744097971480510696, MANAGEMENT\naor" 2015-08-06,17:01:54,978,1,"#000012A0","#00000003","info ","MAUpdateUsers"," Found more than one user with the same name." 2015-08-06,17:01:54,978,1,"#000012A0","#00000003","info ","MAUpdateUsers"," Updating user 186 to 135." 2015-08-06,17:01:54,978,1,"#000012A0","#00000003","info ","MAUpdateUsers"," Updating arc_owners..." 2015-08-06,17:01:55,492,1,"#000012A0","#00000003","info ","MAUpdateUsers"," Updating arc_tags..." 2015-08-06,17:01:55,492,1,"#000012A0","#00000003","info ","MAUpdateUsers"," tagName: FOLDER_SENT, tagValue: Sent Items, newUser: 135, oldUser: 186, oldUserTagId: -2147482436, newUserTagId: -2147482723." 2015-08-06,17:01:55,992,1,"#000012A0","#00000003","info ","MAUpdateUsers"," tagName: FOLDER_INBOX, tagValue: Inbox, newUser: 135, oldUser: 186, oldUserTagId: -2147482435, newUserTagId: -2147483205." 2015-08-06,17:01:56,163,1,"#000012A0","#00000001","error ","errors","error: Violation of PRIMARY KEY constraint 'PK_arc_msg_tags'. Cannot insert duplicate key in object 'dbo.arc_tags_msg'. The duplicate key value is (-2147483205, -2147179471). ;The statement has been terminated."

Workaround / Fix Details

n/a

Required Actions

Escalate with: 1. Server side TS files 2. Debuglogs from MAUpdateUsers tool