Parallel execution of changes that would create a DialogProcess potentially results in an error:
"Cannot insert duplicate key in object 'dbo.DialogProcess'. The duplicate key value is..."
The full error is:
"VI.Base.ViException: Error during execution of statement: declare @today datetime = getutcdate() merge into DialogProcess as t using (values ('aaf9dd27-ea67-46ed-82b4-746e28d08770', 'ADSAccount', '<Key><T>ADSAccount</T><P>7aa10baa-c057-47bf-8c4c-41f426608d47</P></Key>', 'G', N'Update Active Directory user account', N'sa'))
as s (GenProcID, BasisObjectType, ObjectKey, ProcessState, DisplayName, XUser) on t.GenProcID = s.GenProcID when matched and ( t.ProcessState <> s.ProcessState or (IsNull(t.DisplayName, N'') = '' and s.DisplayName > N' ')) then
update set
t.ProcessState = s.ProcessState,
DisplayName = CASE WHEN IsNull(t.DisplayName, N'') = N'' THEN s.DisplayName ELSE t.DisplayName END,
XDateUpdated = @today,
XUserUpdated = s.XUser
when not matched by target then
insert (GenProcID, BasisObjectType, ObjectKey, ProcessState, DisplayName, XDateInserted, XUserInserted, XDateUpdated, XUserUpdated)
values (GenProcID, BasisObjectType, ObjectKey, ProcessState, DisplayName, @today, XUser, @today, XUser); ---> VI.DB.DatabaseException: Database error 2627: Violation of PRIMARY KEY constraint 'PK__DialogPr__2B66FD776487EDFB'. Cannot insert duplicate key in object 'dbo.DialogProcess'. The duplicate key value is (aaf9dd27-ea67-46ed-82b4-746e28d08770).
The statement has been terminated. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__DialogPr__2B66FD776487EDFB'. Cannot insert duplicate key in object 'dbo.DialogProcess'. The duplicate key value is (aaf9dd27-ea67-46ed-82b4-746e28d08770)"
This is a product defect (33188).
WORKAROUND
None
STATUS
This will be fixed in a future release of the product. If you require this immediately corrected, please contact Support for a hotfix referencing the defect ID 33188.
© 2025 One Identity LLC. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center