Versions / Builds Affected
20150218 (and probably older)Status
OpenTT / JIRAID
3008How 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/aRequired Actions
Escalate with:
1. Server side TS files
2. Debuglogs from MAUpdateUsers tool