My Oracle Support Banner

Problem Quering An IO With Picklist Field With More Than 10000 Values (Doc ID 1149263.1)

Last updated on MARCH 01, 2018

Applies to:

Siebel CRM - Version 8.0 [20405] and later
Information in this document applies to any platform.


When querying a record with the EAI Siebel Adapter set using the ForwardOnly mode, it was still raising the 10K record limit error SBL-DAT-00500:

In Spanish:

ObjMgrBusCompLog Warning 2 000046ac4c1770d4:0 2010-06-29 00:13:01 (sqlobj.cpp (34364)) SBL-DAT-00500: Existian mas filas que pueden ser devueltas. Mejore la consulta para devolver menos filas.

In English:

SBL-DAT-00500: There were more rows than could be returned. Please refine your query to bring back fewer rows.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.