SBL-DAT-00500 Error in All Asset View when Querying with Product Picklist or Updating Product with Product Picklist and there are More Than 10K Assets with that Product Name. (Doc ID 1630127.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.10 [23021] version, Configuration - Dev Env

When navigating to Assets view, updating an Asset's Product and navigating to the next record results in the below error.

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

No action is being performed and user is simply navigating from one records to another. After clicking on 'ok' on the error, user is able to navigate successfully and error does not come. This error happens often but not always.

Max Cursor Size at Asset BC level is = -1

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

The issue can be reproduced at will with the following steps:
Navigate to the All Assets view.
Their custom srf allows the Asset Mgmt - Asset BC to update the Product Name field which the standard configuration does not.
If they update the Asset to have a Product that already has more than 10K Assets for that Product, the SBL-DAT-00500 error happens when they navigate to the next record.
Note, that if the user instead just types in the Product Name instead of using the Picklist to update the field, the SBL-DAT-00500 error does not appear.

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