Overview
This article describes the resolution of the error which occurs when running the MAUpdateUsers tool fails with the error:
Violation of PRIMARY KEY constraint 'PK_arc_owners'. Cannot insert duplicate key in object 'dbo.arc_owners'. The duplicate key value is (-2147476184, 4)
Note: The duplicate key values within this full error line refer to database-specific email and user IDs and would differ.
MAUpdateUsers's debug logs would read:
2014-10-23,08:48:46,491,1,"#000028D0","#0000001F","info ","MAUpdateUsers","*Updating MS SQL database localhost\GFI_MA_x_2007*"
2014-10-23,08:48:46,615,1,"#000028D0","#0000001F","info ","MAUpdateUsers","Checking DB schema..." 2014-10-23,08:48:46,615,1,"#000028D0","#0000001F","info ","MAUpdateUsers","Schema version:" 2014-10-23,08:48:46,615,1,"#000028D0","#0000001F","info ","MAUpdateUsers"," Supported: >45" 2014-10-23,08:48:46,615,1,"#000028D0","#0000001F","info ","MAUpdateUsers"," Current store: 62" ... 2014-10-23,08:48:46,880,1,"#000028D0","#0000001F","info ","MAUpdateUsers",">Processing - 33a1c1eaa9cc174c9409a1b527223553, -587206214768350455, SCAEMI\BiffiS" 2014-10-23,08:48:46,880,1,"#000028D0","#0000001F","info ","MAUpdateUsers"," Found more than one user with the same name."
2014-10-23,08:48:46,880,1,"#000028D0","#0000001F","info ","MAUpdateUsers"," Updating user 7 to 4." 2014-10-23,08:48:46,880,1,"#000028D0","#0000001F","info ","MAUpdateUsers"," Updating arc_owners..." 2014-10-23,08:48:46,896,1,"#000028D0","#00000001","error ","errors","error: Violation of PRIMARY KEY constraint 'PK_arc_owners'. Cannot insert duplicate key in object 'dbo.arc_owners'. The duplicate key value is (-2147476184, 4). ;The statement has been terminated."
Note: The part of the error message in bold is the most relevant part to identify this issue as it mentions the exact constraint which causes the error.
Environment
The following are the affected versions/builds:
- 20140616
- 20141117
Resolution
This issue is fixed in UpdateUsers for GFI Archiver 2015 which has a file timestamp of the .exe file of 2015-01-14 (or newer)
- Upgrade to GFI Archiver 2015 or newer.
- Download and use UpdateUsers for the corresponding version.