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 NOVEMBER 01, 2023
Applies to:
Siebel CRM - Version 8.0 [20405] and laterInformation 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.
*** ***
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
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 |