Unique Key Violation During Migration To Downstream Environment Of MS SQL CIAI
(Doc ID 2655084.1)
Last updated on APRIL 06, 2020
Applies to:Siebel CRM - Version 19.10 and later
Information in this document applies to any platform.
On migrating from DR to RR environment customer encountered a unique index error on Table S_RR_CLASS and Index S_RR_CLASS_U1 .
[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.S_RR_CLASS' with unique index 'S_RR_CLASS_U1'. The duplicate key value is (1-17IBA-1, CSSADMService, 1-17IBA-8UZH, 0, ENU).
Customer was unable to fix the Duplicate values by inactivating one of the view name, Since the views did not have a reference in any Siebel Responsibilities.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document