Last updated on JULY 10, 2017
Applies to:Siebel CRM - Version 15.0 [IP2015] and later
Information in this document applies to any platform.
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
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: ( 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.
The issue can be reproduced at will with the following steps:
1. Run DeDuplication batch job on DQ manager Component
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms