SBL-DAT-00381: A record that contains identical values to the record you have created already exists.

Applies to:

Error Message Area:Data Manager - DAT
Version:Siebel 7.7

Purpose

This document is intended to provide cause and corrective action information about Siebel Error Message 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.

Scope

This document is informational and intended for any user.

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.

Explanation

1. An attempt to create or update a record has resulted in a violation of the uniqueness constraint as defined by the user key index. The action may have been initiated through any of the following: user actions directly in the UI, Enterprise Integration Manager (EIM), eBusiness Application Integration (EAI), business services or other scripting, workflow processes, object interfaces such as COM or CORBA, or Data Quality activities.

2. This error can also be caused by violating the unique index on tables that store child records of a record that is being created or deleted. If this occurs, the cause may be due to the No Copy property on the Multi Value Link (MVL) object, or the Cascade Delete property on the Link object.

3. This error may occur in Siebel applications version 7.5.2.102 and higher after creating table S_IC_ACHV_TXN, whenever an order with more than one line item has been imported into the Incentive Compensation (IC) Transaction Workbook and the corresponding transaction is accumulated.

Corrective Action

1. Use SQL logging to identify the table and record values causing this error. The SQL logging method will differ depending upon which action is triggering this error. If possible, use additional logging to determine the buscomp whose record was being created, or updated.

In Siebel Tools, look up the Table and its child User Key to find the user key index (_U1 index). Compare the columns in the user key index with the record values to confirm which unique constraint is being violated.

If it is unclear how the creation or update was triggered, check for scripting on the buscomp, workflow processes, including batch processes or repeating component requests, and object interfaces which may be running custom routines.

The exact corrective action will depend upon what action led to the error and whether the error is appropriate to the situation. If a user action triggered the error, the user should correct the values provided to meet the unique constraint requirements for the table. If the error was triggered by a background or automated process, you may need to modify the script or process to ensure that it will not try to enter duplicate records.

2. If this error is occurring on a table storing child records when the parent record is being copied, set the No Copy property of the MVL to TRUE. If this error occurs on a table storing child records when the parent record is being deleted, set the Cascade Delete property of the Link object to CLEAR. If there are multiple links defined between business components based on the same tables, make sure the No Copy or Cascade Delete properties are set correctly on all MVLs and Links.

3. If you receive this error in the ICMContainerCalc log file after accumulating transactions with more than one line item, refer to Alert 1031 on SupportWeb for details on how to resolve the error.

Applies to:

Siebel Public Sector CRM Service - Version: 7.8.2.8 SIA [19237] and later   [Release: V7 and later ]
Information in this document applies to any platform.

Symptoms

While merging accounts in Administration - Data > Accounts Administration, the following error is generated:

We detected an Error which may have occurred for one or more of the following reasons:
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)

Cause

The issue has been reproduced in standard environment in 8.1.1.1 and CR # 12-1ZB8UCJ has been logged to address this issue.

Solution

As a workaround please consider merging records in Accounts > Accounts Administration. I have tested the same in my test environment and I was able to successfully merge records.

References

BUG:12-1ZB8UCJ - SBL-DAT-00381 WHILE MERGING RECORDS IN SIS ACCOUNT ADMINISTRATION VIEW

Applies to:

Siebel CRM - Version: 8.0.0.5 SIA [20420] - Release: V8
Oracle Data Quality Matching Server - Version: 8.0.0.5 SIA [20420] to 8.0.0.7 SIA [20426] - Release: V8 to V8
Information in this document applies to any platform.

Symptoms

Statement of what the issue is
The customer has found an issue when using Siebel 8.0.0.5 along with third party data quality application Identity Search Server (ISS, also known as ODQ - Oracle Data Quality or IIR - Informatica Identity Resolution) whereby if you enter a contact record and then another and then amend the second contact, an error message is shown:

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)

Cause

Statement describing the cause of the problem
The issue was determined to be a new product defect. The following change request was raised:

Bug 12-1STC0TH - Using 8.0 with ISS results in SBL-DAT-00381 error message

Solution

This product defect does not seem to affect Siebel 8.1.x, only 8.0.0.5 - 8.0.0.8 fix packs.

This product defect has been fixed in the following products:

- 8.0.0.9 Fix Pack
- 8.0.0.7 QF0711

At the time of writing, 8.0.0.9 fix pack was not available, so in order to download QF0711 please follow the below instructions:

1. Click 'Patches & Updates' [top right hand corner of this portal]
2. Click 'Oracle, Siebel and Hyperion Products'
3. Click 'Simple Search'
4. Search By 'Patch Number/Name' and enter
"8679111" for SBA 8.0.0.7 QF0711
5. Select Platform or Language 'Microsoft Windows (32 bit)'
6. Click 'Go.

QF0711 is currently only available for Windows and Solaris operating systems.

References

BUG:12-1TYAW7D - EDIT WEB LAYOUT ON A VIEW CRASHES TOOLS
BUG:12-1STC0TH - USING 8.0 WITH ISS RESULTS IN SBL-DAT-00381 ERROR MESSAGE

Applies to:

Siebel Data Quality - Version: 8.0 [20405] to 8.0.0.5 [20420] - Release: V8 to V8
Siebel Data Quality - Version: 8.1.1 [21112] to 8.1.1 [21112]   [Release: V8 to V8]
Information in this document applies to any platform.

Symptoms

When attempting to merge two accounts or Contacts via Administration - Data Quality > Duplicate Accounts or Duplicate Contacts the following error occurs.

ERROR
-----------------------
SBL-DBC-00111: An error has occurred writing to a record.
SBL-DAT-00381: A record that contains identical values to the record you have created already exists.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enable Case Insensitive and Accent Insensitive (CIAI) searching on Account/Contact related columns
2. Enter some Account or Contact records in the user interface
3. Ran a batch key generation and then deduplication job
4. Try to merge two accounts highlighted as duplicates

Cause

The cause is due to the internal Siebel code incorrectly handling Case Insensitive and Accent Insensitive columns during a merge.

SUPPORT OF CONCLUSION
---------------
Bug 12-1OQDGQP - Merging of two Contact Records raises error SBL-DAT-00381

Solution

The issue is fixed in in the following fix packs:

- 8.0.0.6 and higher
- 8.1.1.1 and higher

To download the latest fix pack follow the below steps:
- Click the 'Patches & Updates' tab on this portal
- In the 'Patch Search' window, click the 'Product or Family (Advanced Search) link
- In the 'Product is', type or select either 'Siebel Business Applications' (NOT Siebel eBusiness Applications)
- Choose the appropriate release in 'Release is' (e.g. Siebel CRM 8.0 for Siebel 8.0.x or Siebel CRM 8.1.1 for Siebel 8.1.1.x)
- Choose the appropriate 'Platform', e.g. Microsoft Windows (32 bit), Oracle Solaris on SPARC (64 bit) etc.
- Click the plus symbol (+) to 'Add a Search Filter' and Select Filter 'Type' and select 'Patchset'
- Click Search
- Click the appropriate Patch Name link for the appropriate fix pack for your required operating system

References

BUG:12-1OQDGQP - MERGING OF TWO CONTACT RECORDS RAISES ERROR SBL-DAT-00381
BUG:12-1NWCZ8F - MLOV ENABLED FIELD DISPLAYS INCORRECT VALUE AFTER APPLYING CIAI TABLE CHANGES TO DATABASE

Applies to:

Siebel Tools - Version: 8.0.0.5 [20420] - Release: V8
Information in this document applies to any platform.

Symptoms

When attempting to copy an Action record in All Activities list view,
the following error occurs.

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

Cause

In general, when two identical records are inserted into a table, the unique constraint error will be thrown. In customer's environment, there were two MVLs configured to the Employee BC, of which one was standard one (for visibility) and another was custom one. Both these MVLs were active while copying the Action record, causing double insert into the S_ACT_EMP table (which stores the relationship between an Action and many Employee records) and hence causing the error.

Solution

Setting "No Copy" to TRUE for the custom MVL to the Employee BC will avoid double insert into the S_ACT_EMP table and hence avoiding the error.

The below steps were followed resolve the issue:

(1) Go to the Action BC and navigate to the custom MVL to the the Employee BC.
(2) Set "No Copy" to TRUE for the custom MVL.
(3) Compile the changes.