The Query to Siebel does not respond when the number of rows to be returned is very large.

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.