SBL-EAI-04381 Upsert Error When a Trailing Space is Sent in the User Key
Last updated on MARCH 02, 2017
Applies to:Siebel Public Sector Call Center - Version 126.96.36.199  and later
Siebel CRM - Version 188.8.131.52  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. 184.108.40.206, 220.127.116.11 but it was not observerd in previous versions like 18.104.22.168 or 22.214.171.124.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms