Error SBL-DAT-00500 When Revising Agreements From the All Agreements View (Doc ID 578128.1)

Last updated on AUGUST 15, 2017

Applies to:

Siebel Automotive - Version 7.5.3.1 SIA [16161] and later
Information in this document applies to any platform.
****Checked for Relevance on 14-Oct-2014****

Symptoms

When trying to revise an agreement by clicking Revise button in the All Agreements view, the following error may appear:

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


The corresponding log file shows the following queries for business component 'Service Agreement':

1. When entering the All Agreements view the application queries for all records in business component 'Service Agreement', but it fetches only the number of records that are displayed in the user interface - in this case 7 records.
-> Query BC 'Service Agreement' with condition:
SELECT statement with ID: 2787FA0
SELECT
:
FROM
SIEBEL.S_DOC_AGREE_BU T1,
:
SIEBEL.S_DOC_AGREE T33
WHERE
T1.BU_ID = :1 AND T33.ROW_ID = T1.AGREEMENT_ID AND
(T33.CONTRACT_FLG = 'N')
Bind variable 1: 1-2OS
- 1st Fetch
- a number of queries on S_LST_OF_VAL
- 6 more Fetches

2. When going to the next set of records the next 7 records are fetched:
... (GotoNextSet)
-> 7 Fetches for Cursor 2787fa0
... (GotoNextSet)
- 7 Fetches for Cursor 2787fa0

3. When refreshing the business component after the Revise operation the application again queries for records in business component 'Service Agreement', but this time it tries to fetch ALL records; if there are >= 10,000 records this leads to the error message cited above:
-> Query BC 'Service Agreement' with condition:
SELECT statement with ID: 2787FA0
SELECT
:
FROM
SIEBEL.S_DOC_AGREE_BU T1,
:
SIEBEL.S_DOC_AGREE T33
WHERE
T1.BU_ID = :1 AND T33.ROW_ID = T1.AGREEMENT_ID AND
(T33.CONTRACT_FLG = 'N')
Bind variable 1: 1-2OS 
- 7 Fetches for Cursor 2787fa0
: a number of queries on other BCs in between
- 9992 Fetches for Cursor 2787fa0
ObjMgrSqlLog Detail 4 2008-04-10 16:13:19 SQL Cursor with ID 2787FA0 Fetch Rows: 10000, Fetch All Time: 20.625 seconds.
ObjMgrDataObjLog CloseCursor 5 2008-04-10 16:13:19 End: Close for Cursor 2787fa0
GenericLog GenericError 1 2008-04-10 16:13:19 There were more rows than could be returned. Please refine your query to bring back fewer rows
ObjMgrLog Error 4 2008-04-10 16:13:19 (SBL-DAT-00500) There were more rows than could be returned. Please refine your query to bring back fewer rows

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