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

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

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. 8.1.1.10, 8.1.1.11 but it was not observerd in previous versions like 8.1.1.3 or 8.1.1.5.

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms