My Oracle Support Banner

“There were more rows than could be returned” error occurs when executing LookupValue in an UI data map (Doc ID 1925807.1)

Last updated on APRIL 02, 2024

Applies to:

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

Siebel CRM [23030]
Microsoft Windows (32-bit) 2003

Statement of Issue:

An external application sends a record to Siebel. An UI data map is used to convert the record. This includes the expression LookupValue("MSC_WARD",[MSC Ward]) to convert an incoming WARD code into the required value in Siebel. In Siebel there are 11400 List Of Value records where Type = MSC Ward, but there is only 1 record with the relevant Type and LIC combination. When the external application sends a record to Siebel, an error is occurring.

Error invoking service 'EAI Data Transformation Engine', method 'Execute' at step 'DataMap'.(SBL-BPR-00162)
An error occurred while attempting to look up the LOV value of '0512005' of type 'MSC_WARD'.(SBL-DAT-00590)
There were more rows than could be returned. Please refine your query to bring back fewer rows(SBL-DAT-00500)

Error Code:


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.