Why does the Siebel adapter log the exception "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."?
Article ID: KB0086704
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Siebel | - |
| Not Applicable | - |
Description
Resolution:
The adapter will log the 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." due to following factors:
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 scripting, workflow processes etc
Corrective action that can be taken:
------------------------------------------
-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.
-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.
Note: 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. 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.
Corrective action that can be taken:
------------------------------------------
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.
The adapter will log the 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." due to following factors:
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 scripting, workflow processes etc
Corrective action that can be taken:
------------------------------------------
-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.
-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.
Note: 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. 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.
Corrective action that can be taken:
------------------------------------------
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.
Issue/Introduction
Why does the Siebel adapter log the exception "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."?
Feedback
Yes
No
Powered by
