Transaction Merger failed with "ORA-00001 unique constraint violated" S_ACT_CONTACT_U1 (Doc ID 1280449.1)

Last updated on MARCH 23, 2016

Applies to:

Siebel Remote - Version 7.8.2.13 [19250] and later
Information in this document applies to any platform.
**Review on 20 Oct 2014**

Symptoms

The Merger failed with the following errors:

SQLError Statement 0 0 2010-08-18 14:59:56 SQL Statement:
UPDATE SIEBEL.S_ACT_CONTACT
SET CON_ID = '1-1BUO-1375'
WHERE ( CON_ID = '1-2UN5W' OR ACTIVITY_ID in ('1-2VT3M', '1-2VT7R',
'1LG-15M', '1LG-1B7', '1LG-1TH', '1LG-26P', '1LG-2HD', '1LG-2LR',
'1LG-2NG', '1LG-8UC', '1LG-8UH', '1LG-8YE', '1LG-8YJ', '1LG-UN',
'1YJ-2L1', '1YJ-2LC', '1YJ-2LP', '3NI-1JZ', '3NI-1K4', '3NI-1K9',
'3NI-432', '3NI-46K', '3NI-46P', '3NI-4KE', '3NI-5VF', '3NI-5VK',
'3NI-5VP', '3NI-VS', '3NI-VX', '3NI-WF', '6PA-5G0', '6PA-5G4',
'6PA-5G8', '6PA-5GC', '6PA-6FB', '6PA-6FF', '6PA-6FJ', '6PA-8J8',
'6PA-8JC', '6PA-8JG', '6PA-8JK', '6PA-ANB', '6PA-ANF', '6PA-BKQ',
'6PA-CKL', '6PA-D03', '6PA-DES', '6PA-DU9', '6PA-EGJ', '6PA-FEH',
'6PA-GWH', '6PA-H8R', '6PA-HRK', '8CF-3EK', '8CF-ID', '8GW-16Z',
'8GW-173', '8GW-177', 'C1C-1N0', 'C1C-2E4', 'C1C-2U7', 'C1C-3LN',
'C1C-4DN', 'C1C-582', 'C1C-I0', 'C1C-N6', 'EGT-1D4', 'EGT-1VB',
'EGT-3J5', 'EGT-4L9', 'EGT-611', 'EGT-6R3', 'EGT-7L6', 'EGT-84S',
'EGT-932', 'EGT-9QJ', 'EGT-A5P', 'EGT-BLC', 'EGT-CMI', 'EGT-DGC',
'EGT-E2Z', 'EGT-F9X', 'IDG-2BQ', 'IDG-2BU', 'IDG-3V4', 'IDG-4ZV',
'IDG-5RB', 'IDG-5ZP', 'IDG-7MF', 'IDG-7MJ', 'IDG-9IV', 'IDG-BEO',
'IDG-BR1', 'IDG-DR7', 'IDG-EIU', 'IDG-EIY', 'IIQ-14E', 'IIQ-14I',
'IIQ-14M', 'IIQ-14Q', 'IIQ-331', 'IIQ-335', 'IIQ-339', 'IIQ-33D',
'IIQ-4TN', 'IIQ-593', 'IIQ-5VY', 'IIQ-6JJ', 'IIQ-7UE', 'IIQ-7ZN',
'IIQ-9GX', 'IIQ-A3B', 'IIQ-BTJ', 'IIQ-CCY', 'IIQ-CPV', 'IIQ-D13',
'IIQ-D47', 'IIQ-DWN', 'IIQ-FAY', 'IIQ-GUD', 'IIQ-GVI', 'IK7-5J',
'LKY-RI')) AND CON_ID != '1-1BUO-1375'

DBCLog DBCLogError 1 0 2010-08-18 14:59:56 [DataDirect][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_ACT_CONTACT_U1) violated

Cause

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