My Oracle Support Banner

SBL-EAI-04381 Upsert Error When a Trailing Space is Sent in the User Key (Doc ID 1613171.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel Public Sector Call Center - Version [23021] and later
Siebel CRM - Version [23021] and later
Information in this document applies to any platform.


When using EAI Siebel Adapter to update an existing record where the user key is based on a unique key field and a trailing space is sent to the user key field Siebel should update the existing record it tries to insert a new record and fails.

Error------Error invoking service 'EAI Siebel Adapter', method 'Upsert' at step 'Write to Address BC'.(SBL-BPR-00162)
For instance of Integration Component 'PersonalAddress_IO', using user key '[Address Name] = "Residential 1-XXX 01/01/1990 00:00:00" AND [Address Type] = "Residential" AND [Start Date] = "01/01/1990"', a record with identical values already exists in the Siebel database.

Please ensure that the field values in the input message are unique.(SBL-EAI-04381)(SBL-EXL-00151)

This behavior was observed in latest versions of Siebel e.g., but it was not observerd in previous versions like or

In previous versions EAI Siebel Adapter removed the trailing space during query by user key and also during upsert.

For newer versions the query step is not removing the trailing spaces and is not finding the record as an existing one.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.