My Oracle Support Banner

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.

Symptoms

On migrating from DR to RR environment customer encountered a unique index error on Table S_RR_CLASS and Index S_RR_CLASS_U1 .

Error:

[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.

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.