Siebel EAI Adapter, Upsert Error SBL-EAI-04381, "a record with identical values already exists in the Siebel database."
(Doc ID 485939.1)
Last updated on JANUARY 03, 2023
Applies to:
Siebel System Software - Version 7.8.2.3 [19221] and laterz*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.8.2.3 [19221]
Database: Microsoft SQL Server 2000
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Microsoft Windows 2003 Server SP1
This document was previously published as Siebel SR 38-3440380493.
Symptoms
SBL-EAI-04381
The EAI Siebel Adapter, Upsert method, is called via in inbound web service. While updating some records, an error is sometimes (intermittently) reported saying that the record already exists, and no inserts are allowed. This is not expected behaviour as the upsert method in this case should do an update of the record. The log files gives us the following errors:
DBCLog DBCLogError SQLError: [23000],[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.S_ORG_EXT' with unique index 'S_ORG_EXT_U1'.
ObjMgrLog Error (adptutils.cpp (5137)) SBL-EAI-04381: For instance of Integration Component 'Account For TEAM', using user key '[CSN] = "10017918"', a record with identical values already exists in the Siebel database.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |