LOV - List of Value Queries with 30 Characters Generate Errors: ORA-24345, SBL-DAT-00500 and SBL-DBC-00105 (Doc ID 494232.1)

Last updated on JUNE 05, 2017

Applies to:

Siebel CRM - Version 8.0 [20405] and later
Information in this document applies to any platform.
Product Release: V8 (Enterprise)
Version: 8.0 [20405]
Database: Oracle 10.2.0.2
Application Server OS: Microsoft Windows 2003 Server SP2
Database Server OS: Microsoft Windows 2003 Server SP2

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

***Checked for relevance on 19-March-2012***
***Checked for relevance on 9-July-2014***


Symptoms

While querying list of values (LOV's) for COUNTRY typed LOVS, not all records were getting retrieved.

In the spool file, it showed that the following query retrieved 52 records.:

SELECT statement with ID: C2CA278
SELECT /*+ ALL_ROWS */
T1.CONFLICT_ID,
T1.LAST_UPD,
T1.CREATED,
T1.LAST_UPD_BY,
T1.CREATED_BY,
T1.MODIFICATION_NUM,
T1.ROW_ID,
T1.NAME,
T1.ORDER_BY,
T1.RPLCTN_LVL_CD,
T1.SUB_TYPE,
T1.TYPE,
T1.VAL,
T1.CODE
FROM
SIEBEL.S_LST_OF_VAL T1
WHERE
((T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND
(T1.CODE != 'CLASS' OR T1.CODE IS NULL) AND
(T1.TYPE = :2 AND T1.BU_ID IS NULL))
ORDER BY
T1.ORDER_BY

Bind variable 1: Y
Bind variable 2: COUNTRY

The same SQL statement when executed directly against the database (using Toad or other SQL tool) retrieved 240 records.

Also, scrolling through the View 'List of Values View' by filtering for TYPE = COUNTRY the following error message appears:

SBL-DAT-00500 - 'There were more rows than could be returned. Please refine your query to bring back fewer rows' Please continue or ask your systems administrator to check your application configuration if the problems persists. (SBL-DBC-00105)

ORA-24345: A Truncation or null fetch error occurred.

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