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 22.214.171.124  and later
Siebel CRM - Version 126.96.36.199  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. 188.8.131.52, 184.108.40.206 but it was not observerd in previous versions like 220.127.116.11 or 18.104.22.168.
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