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

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

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.

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