My Oracle Support Banner

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

Last updated on SEPTEMBER 11, 2023

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.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.