“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 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.
*** Checked for currency JUL-22-2016 ***

Symptoms

Environment:
------------
Siebel CRM 8.1.1.11 [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:
------
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:
(SBL-BPR-00162)--(SBL-DAT-00590)--(SBL-DAT-00500)

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