Return
-
Title
When executing a built in search, a violation of primary key constraint error shows up. -
Description
When runing a builtin search, the Change Auditor Client presents a pop up with a violation of primary key error similar to:
Violation of PRIMARY KEY constraint 'PK__#A5F8223__DED88B1C4CADCC26'. Cannot insert duplicate key in object 'dbo.@tmp'. The duplicate key value is (0x000000ff00002b3900000002).The statement has been terminated.Checking the Change Auditor Coordinator log there is a Warning similar to:Key violation inserting Event IDs, attempting to recover task: AuditEvent_EventID:27123ed40b484e27af33674a428441aaException: Violation of PRIMARY KEY constraint 'PK__AuditEve__7944C8707FFD1045'. Cannot insert duplicate key in object 'dbo.AuditEvent_EventID'. The duplicate key value is (0x01e4c11c48565fe99ab89b5a729fd72c).The statement has been terminated.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.