ADM Export Size Limit (SBL-DAT-00500) (SBL-EAI-04376) (Doc ID 482445.1)

Last updated on DECEMBER 05, 2016

Applies to:

Siebel System Software - Version 7.8.2 SIA [19213] to 8.1.1.5 [21229] [Release V7 to V8]
Information in this document applies to any platform.
Product Release: V7 (Enterprise)
Version: 7.8.2 [19213] Com/Med



Symptoms

ADM Issue:

The following error displays when exporting a file with more than 10,000 records for ADM:

"There were more rows than could be returned. Please refine your query to bring back fewer rows (SBL-DAT-00500) (SBL-EAI-04376)


Full error message:

We detected an Error which may have occurred for one or more of the following reasons:
Method 'NextRecord' of business component 'Feature Access' (integration component 'Feature Access') returned the following error: "There were more rows than could be returned. Please refine your query to bring back fewer rows (SBL-DAT-00500) (SBL-EAI-04376)



Has the DSMaxFetchArraySize parameter been removed from 7.8.2.x since it is not available under Enterprise Profile Configuration?

The desire is to set this parameter to -1 to use the ADM process for exporting more than 10000 rows.

The Troubleshooting Steps in <Document 477716.1> recommends doing this; however, there is a warning in the Alert <Document 477558.1> that states setting this parameter could cause an Object Manager crash.

The Alert also states Change Request 12-J50XVH says that any reference of setting this parameter has been removed from Siebel Bookshelf v 7.x.

<Bug 10470871> discusses an enhancement request for setting this parameter at the component parameter level but the enhancement was rejected.

 

 

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