SBL-DAT-00590 Error While Trying to Pick A Value For A Picklist Field in Siebel

Doc ID 1335003.1

APPLIES TO:
Siebel Tools - Version 8.1.1.4 SIA [21225] and later
Information in this document applies to any platform.
Checked for Relevance on 15-Mar-2013
Checked for Relevance on 03-Nov-2015

SYMPTOMS
When attempting to create a new record in Campaign Applet in Asset > Campaign screen for the first time,
the following error occurs. These errors will happen for the first time only per session. For second time, "new" button it's ok and no error.

The problem in Campaign BC is with 'Call Status' field, which has predefault value= Expr: "LookupValue(""CAMPAIGN_STATUS_OUTCOME"",""New Added"")"

ERROR
-----------------------
[1] An error occurred calculating the default value for field 'Call Status' in business component 'AIS Asset Campaigns'.(SBL-DAT-00412)
[2] Could not evaluate expression 'Expr: "LookupValue(""CAMPAIGN_STATUS_OUTCOME"",""New Added"")"' for field 'Call Status' in business component 'AIS Asset Campaigns'.(SBL-DAT-00394)
[3] An error occurred while attempting to look up the LOV value of 'New Added' of type 'CAMPAIGN_STATUS_OUTCOME'.(SBL-DAT-00590)
[4] There were more rows than could be returned. Please refine your query to bring back fewer rows(SBL-DAT-00500)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Navigate to Asset > Campaign screen.
2. Click "new button" in Campaign Applet
3. The above mentioned errors occurs.
4. Again click on click "new button" in Campaign Applet. A new record will be created correctly.

CAUSE
In standard, these errors occur while trying to pick a value for a static pick list, which has more than 10000 records for the LOV type of that static pick list.

In customer's environment, customer had 10700 records for the LOV of Type as "CAMPAIGN_STATUS_OUTCOME". Hence the errors were thrown while trying to predefault the pick list field value.

SOLUTION
The customer followed the below steps to resolve the issue:

(1) In the Siebel application, navigate to Administration - Data -> List of Values view
(2) Query for the LOV Type of the field, which gives the error.
(3) Get the count and try to reduce the count to be less than 10000 records.
(4) Clear the cache.

Note: If one does not want to limit the records to 10000 due to their business needs, then it is recommended to use Pick Applet configured for the Picklist with Long List property set to FALSE.

Source: Oracle Doc ID 1335003.1

See Alos:
DSMaxFetchArraySize = -1 Could Result IN High Memory Usage / Crash Of OM PIDs (Doc ID 477558.1)  

There were more rows than could be returned error occurs when executing LookupValue in an UI data map (Doc ID 1925807.1)