SBL-DAT-00391: Please sort the data before going to the last record. The data set is too large to return unless the data is sorted.

Applies to:

Product Release: V7 (Enterprise)
Version: 7.5.3.15 [16279] Cons Sec
Database: Microsoft SQL Server 2000 SP 2
Application Server OS: Microsoft Windows 2000 Server SP 2
Database Server OS: Microsoft Windows 2000 Server SP 2

This document was previously published as Siebel SR 38-3136688731.

Symptoms

SBL-DAT-00391

Hi,

I created a BC and a list applet based on table S_LIT, in order to administrate a particular type of literatures.

The problem is when I want to insert a new record I have a message:
- - -
Please sort the data before going to the last record. The data set is too large to return unless the data is sorted.(SBL-DAT-00391)
- - -

In fact, Siebel tries to insert this new record at the last position (which is absolutely not necessary) and as there many records, he cannot do it directly.

I have checked that "Append Data" is not checked on S_LIT and there is no script or User Prop, neither on the applet nor on the BC.

Thanks for your help

Solution

Message 1

For the benefit of other readers:

Issue:
===
I created a BC and a list applet based on table S_LIT, in order to administrate a particular type of literatures.

The problem is when I want to insert a new record I have a message:
- - -
Please sort the data before going to the last record. The data set is too large to return unless the data is sorted.(SBL-DAT-00391)
- - -

In fact, Siebel tries to insert this new record at the last position (which is absolutely not necessary) and as there many records, he cannot do it directly.

I have checked that "Append Data" is not checked on S_LIT and there is no script or User Prop, neither on the applet nor on the BC.

Solution:
====
This behavior was due to the 'Insert Position' property of the applet involved that was set to LAST. The issue was resolved once this property was cleared (set to blank).

Note that this property is not displayed by default in Tools. You have to use the "Columns Displayed" feature to display it.

The 'Insert Position' applet property is documented in the Bookshelf:

Object Types Reference
Siebel Object Types
Applet
- - -
Property: Insert Position
Description/Usage: The position in which new records are created.
Valid Values/Examples:

BEFORE = Before the current record.

AFTER = After the current record.

FIRST = The first record.

LAST = The last record.
- - -

Applies to:

Product Release: V7 (Enterprise)
Version: 7.5.3.3 [16172] ITA Life Sci
Database: Oracle 9i
Application Server OS: Microsoft Windows 2000 Advanced Server SP 4
Database Server OS: HP-UX 11.0

This document was previously published as Siebel SR 38-1234145951.

Symptoms

SBL-DAT-00391

When our users scroll to the bottom of the Account List Applet in the "All Account List View" they get the following error message:

"Please sort the data before going to the last record. The data set is too large to return unless the data is sorted."

Please assist on how this can be fixed.

Solution

Message 1

For the benefit of other users,

Customer's reported situation is the expected behavior in Standard Siebel environment and the reason why Siebel displays that message is for performance considerations. When we try to navigate to the last record, Siebel will actually reverse the current sort and re-query the data to get the last records without having to read through them all.

Change request 12-12U5UE has been logged to address the product enhancement request that scrolling to the last record should not generate an error message.

As a workaround, it was recommended that customer sort on any of the field on the list applet before scrolling down to the last record to overcome this error.