Phone Lines icon GFI Support

Articles in this section

See more

Error: 'Violation of PRIMARY KEY constraint 'PK_arc_owners'.' When Executing the MAUpdateUsers Tool

Author: Luis Fernandes Updated

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)

  1. Upgrade to GFI Archiver 2015 or newer.
  2. Download and use UpdateUsers for the corresponding version.