The Query to Siebel does not respond when the number of rows to be returned is very large.
book
Article ID: KB0090253
calendar_today
Updated On:
Products
Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Siebel
-
Not Applicable
-
Description
Description: Description: ========== When you fire a query to Siebel for data, Response to the query is not returned when the number of rows to be returned is large; Adapter throws a Siebel exception SBL-DAT-00500
Impact: ====== Loss of Functionality
Cause: ====== The adapter connects to Siebel Object Manager to create/retrieve records. The error reported by the Adapter is the error that was sent back to the Adapter by Siebel Object Manager.
Siebel reports this error when the number of records retrieved for the query is more than the number Siebel is configured to handle.
Resolution: ========== 1. Set MaxFetchArraySize or MaxCursorSize to a large value in the Siebel Configuration (.cfg) file used by the specific Object Manager to which the adapter is connecting to. 2. Increase the value for Maximum Cursor Size property for the specific Business Component being queried.
Workaround: =========== Refine the query to retrieve less number of records.
Symptoms:
Cause:
Issue/Introduction
The Query to Siebel does not respond when the number of rows to be returned is very large.