[SQL Server]Cannot insert duplicate key row Error Occurs While Importing a Repository During an Upgrade Execution
Last updated on MARCH 01, 2018
Applies to:Siebel Call Center - Version 16.0 [IP2016] and later
Information in this document applies to any platform.
On : Siebel IRM from IP2014 to IP2016
Database is Microsoft Sql Server 2014
Collation used is Latin1*_CI_AS
When attempting to run the Production Test upgrade, a few errors occurred while trying to import the New Customer Repository.
2017-04-06 00:47:47 SQL Warning, SQL State 23000, 2601, [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.S_APPL_WTMPL_IT' with unique index 'S_APPL_WTMPL_IT_U1'. The duplicate key value is (1-MVYG-2UPS, executeQuery, <NULL>, <NULL>).
The issue can be reproduced at will with the following steps:
1. Start Database Configuration Wizard > Upgrade
2. Choose Upgrep
3. Environment: Production
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms