Error SBL-DAT-00500 When Accessing Assets View (Doc ID 481538.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 7.8.2 SIA [19213] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.8.2 [19213] CHS Engy/Oil
Database: Oracle 9.2.0.7
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Sun Solaris 8

This document was previously published as Siebel SR 38-3147897861.
***Checked for currency on 13-Mar 2015***


Symptoms

The customer is using Siebel version 7.8.2.3 and complains that an error has occurred when accessing the Assets view:

"There were more rows than could be returned". (SBL-DAT-00500)

Customer found a posting which apparently fixes the problem by setting the applet user property "Disable Buscomp Hierarchy" to TRUE.
However, in that posting was mentioned that if the property in cause was set to FALSE to fix a defect wherein attributes are not copied over when you create an Asset.
The customer is using ABO, and this will be a huge impact if the attributes are not copied over an Asset.
Moreover, if the customer set it to TRUE the ability to see hierarchies in the Assets view is lost.

Customer wants to know that if they set the user prop 'Disable Buscomp Hierarchy' to TRUE, attributes are still copied when creating an Asset.

 

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