Batch Deduplication Job Is Failing To Insert Records In S_dedup_result Table (Doc ID 2284734.1)

Last updated on JULY 10, 2017

Applies to:

Siebel CRM - Version 15.0 [IP2015] and later
Information in this document applies to any platform.

Symptoms


Batch Deduplication Job is failing to insert records in s_dedup_result table

After executing Batch Deduplication Job in UCM,
we can see siebel_account_candidates and siebel_account_matches staging tables are populated correctly in edq staging area which means edq is recieving the profiles for matching and its correctly generating match score and duplicates.

Issue is when inserting this back to OCH S_DEDUP_RESULT table. its failing with below error

 

ERROR
-----------------------

ObjMgrBusCompLog Error 1 00001089595201b5:0 2017-07-04 12:33:26 (oracon.cpp (3919)) SBL-DBC-00111: An error has occurred writing to a record.
SQLParseAndExecute Execute 5 00001089595201b5:0 2017-07-04 12:33:26 ORA-00001: unique constraint (SIEBEL.S_DEDUP_RESULT_U1) violated
ORA-06512: at line 24
ObjMgrBusCompLog Error 1 00001089595201b5:0 2017-07-04 12:33:26 (oracon.cpp (899)) SBL-DAT-00381: A record that contains identical values to the record you have created already exists.
If you would like to enter a new record, please ensure that the field values are unique.
ObjMgrSqlLog Detail 4 00001089595201b5:0 2017-07-04 12:33:26
...
GenericLog GenericError 1 00001089595201b5:0 2017-07-04 12:33:27 ( (0) err=2818155 sys=7668093) SBL-OMS-00107: Object manager error: ([0] A record that contains identical values to the record you have created already exists.

If you would like to enter a new record, please ensure that the field values are unique.(SBL-DAT-00381) (0x75017d))
GenericLog GenericError 1 00001089595201b5:0 2017-07-04 12:33:27 (dqmgr.cpp (581) err=2424849 sys=0) SBL-DQM-00017: An error occurred while invoking a method inside the Data Quality Business Service. For details please refer Data Quality Component log file for the Server Task.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run DeDuplication batch job on DQ manager Component


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