000030182 - Error when modifying history log options

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000030182
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 5.5 SP1
Platform: Windows
Platform (Other): null
O/S Version: Customer doesn't know/not sure-see notes
Product Name: null
Product Description: null
IssueViolation of Primary key contraint 'PK_tblIVFieldHistoryOptions'. Cannot insert duplicate key in object 'dbo.tblIVFieldHistoryOptions'. The duplicate key value is (72,67).
User-added image
CauseThe tblIVfieldhistory options table has a key error.
ResolutionThe only way to resolve this is to delete the history log field and create a new one with the desired options.