EAI REST API: {"ERROR":"There were more rows than could be returned. Please refine your query to bring back fewer rows(SBL-DAT-00500)"}

(Doc ID 2358115.1)

Last updated on FEBRUARY 06, 2018

Applies to:

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

Symptoms

When attempting to invoke the Rest API Integration object while the IO is deployed to runtime tables and getting the below error message
  -  SBL-DAT-00500: There were more rows than could be returned. Please refine your query to bring back fewer rows

STEPS
-----------------------

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

1) Open the tools, select the IO (example Base Account) and deploy it to runtime table.
2) Restart Siebel server services (just to be sure all changes made are reflected).
3) test using the Postman/SOAP UI Inbound REST request with the below sample message

E.g : URL: https://ServerName:port/siebel/v1.0/data/Account/Account/1xxxxx

Changes

 

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