Querypage fails with SBL-EAI-04606 using PageSize greater than 100 (Doc ID 1087863.1)

Last updated on NOVEMBER 12, 2014

Applies to:

Siebel eService - Version 7.7.2 [18325] to 8.1 [21039] [Release V7 to V8]
Siebel CRM - Version 7.7.2 SIA [18325] and later
Information in this document applies to any platform.

Symptoms

On : 7.7.2.8 [18379] version, Siebel EAI, EAI Siebel Adapter Business Service / QueryPage method.

When attempting to run a workflow process including in its first step a call to EAI Siebel Adapter BS / QueryPage method, the following error occurs when setting Input Property PageSize with a value greater than 100.

ERROR
-----------------------
PageSize method argument cannot be greater than 'Y' specified by the server parameter 'MaximumPageSize' (SBL-EAI-04606)

STEPS
-----------------------
The issue can be also reproduced with vanilla configuration using BS Simulator with the following steps:
1. From Siebel client, go to SiteMap > Business Services > Simulator
2. Add a new record with BS EAI Siebel Adapter and Method QueryPage.
3. Load the Input arguments from a file with the following content, as example:
<?xml version="1.0" encoding="UTF-8"?><?Siebel-Property-Set EscapeNames="true"?><PropertySet
OutputIntObjectName="EAI Account"
PageSize="101"
SearchSpec="[Account.Name] LIKE 'B*'"
SortSpec="Location"
StartRowNum="0"
></PropertySet
>
Ensure of using a search specification that will have more than 100 records related in Siebel.
4. When select 'Run' the error message is displayed.
5. Changing the PageSize from 101 to 100 and repeating the test, it works fine, returning 100 records for IO.

Cause

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