“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 AUGUST 16, 2016

Applies to:

Siebel CRM - Version [IP2013] and later
Information in this document applies to any platform.
*** Checked for currency JUL-22-2016 ***


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:


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