My Oracle Support Banner

EAI Siebel Adapter Error Messages References "IS NULL" In The Search Spec Instead Of The Actual Field Value (Doc ID 525440.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel System Software - Version 6.0.1 [2848] and later
Information in this document applies to any platform.


Calling update (Insert, Update, Upsert and Syncrhonize) methods of the EAI Siebel Adapter  Business Service (explicitly or implicitly via Appliction Service Interface),
  customer may encounter that the returned error message (in case of data transaction  error) contains "NULL" in the search specificaton of Intgeration/Business Component  that has been originating the error.

Below is the typical use case:

We have the following problem regarding the EAI Siebel Adapter. We use the EAI Siebel Adapter to process a Siebel Message that contains multiple records that should be imported. When an error occurs the error message describes the error and it indicates the record in which the error occured. The record is indicated by the combination of the fields included in the integration component key. The problem is that some times the values of the fields included in the integration component key are not displayed by the error message. Instead the literal "IS NULL" is displayed for each of these fields. For example, the following message was provided by the EAI Siebel Adapter during the importation of products.

Error Message: Method 'SetFieldValue' of business component 'Internal Product' (integration component 'Internal Product') for record with search specification '[Part #] IS NULL' returned the following error:"Date out of range. Valid range is January 1, 1753 to December 31, 4712.(SBL-DAT-00374)"(SBL-EAI-04375), Error Code: undefined

In this case we cannot locate the record in which the error occurred.




To view full details, 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 a vibrant support community of peers and Oracle experts.