Limitation Of 'Query' Method Of 'EAI Siebel Adapter' In The SearchSpec Parameter With OR/AND Operator (Doc ID 2143909.1)

Last updated on JULY 06, 2016

Applies to:

Siebel Universal Customer Master - Version 15.5 [IP2015] and later
Information in this document applies to any platform.

Goal

Customer performing the 'EAI Siebel Adapter' Query operation on the vanilla custom IO by passing the SearchSpec parameter.
This is getting errored out with the below error.

Error in fileMethod 'SetSearchSpec' of business component 'Contact' (integration component 'Contact') returned the following error:
"Invalid search specification '(((((((((((((((((
Customer is performing the 'EAI Siebel Adapter' Query operation on the vanilla custom IO by passing the SearchSpec parameter.
This is getting errored out with the below error.

Error in fileMethod 'SetSearchSpec' of business component 'Contact' (integration component 'Contact') returned the following error:

"Invalid search specification '(((((((((((((((((

When checking document "EAI Siebel Adapter and Siebel UI may crash or syntax error when search expression contains excessive number of "OR" / "AND" conditions (Doc ID 1311972.1)", it indicates that EAI Siebel Adapter and Siebel UI may crash or syntax error when search expression contains excessive number of "OR" / "AND" conditions.

Customer tried query operation for around 127 records and it all worked fine, however, but it errored for around 300+ records.

The customer's usage scenario is as follows:

Siebel will be receiving the request from external system through inbound web service and it contains Last name and first name.From the request we need to take the First name and last name and query in Siebel for the match and return the information about those contacts to external system.If the records are ore than 194 customer is facing the issue as mentioned above

What are the exact number of records for which the EAI Siebel Adapter can process successfully with the "OR" / "AND" conditions?


 

Solution

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