“There were more rows than could be returned” error occurs when executing LookupValue in an UI data map
Last updated on AUGUST 16, 2016
Applies to:Siebel CRM - Version 184.108.40.206 [IP2013] and later
Information in this document applies to any platform.
*** Checked for currency JUL-22-2016 ***
Siebel CRM 220.127.116.11 
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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms