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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.