UIM Finder API Returns Error Message "The Result List Has Been Closed." When Searching Telephone Numbers
Last updated on SEPTEMBER 16, 2016
Applies to:Oracle Communications Unified Inventory Management - Version 7.1.2 and later
Information in this document applies to any platform.
Customer recently applied patch 18.104.22.168 patch 4 build 286 in our DEV environment. We updated "reserveMDN" web service to leverage newly row-locking feature. When row-lock policy is set on the search criteria object, the Finder API is ble to return records when records are found matching the criteria. However when no records are found it throws an exception along with the message "The result list has been closed." The web service returns this fault message which is not much helpful to the consumers.
TelephoneNumberSearchCriteria searchCriteria = mgr.makeTelephoneNumberSearchCriteria();
//Set the searchCriteria
LockPolicy lockPolicy = InventoryHelper.makeLockPolicy();
//Set the number of resources to be rowlocked to slighter higher value than requested quantity.
lockPolicy.setNumberOfResources(mdnquantity + 20);
//exclude resources which already have been rowlocked from the result.
list = mgr.findTelephoneNumbers(searchCriteria);
if(list != null && list.size()==0)
errorMessage = "No MDNs available in inventory for the NPA-NXX";
throw new UIMFaultType(errorMessage,"5020");
The exception is thrown by TelephoneNumberManager.findTelephoneNumbers(searchCriteria) method. Prior to this change, if the list returned was null or empty, we would handle it by returning a FaultResponse to the consumer of the web service.
If lockpolicy is not set on the searc criteria, then the method does not throw an exception.
"The result list has been closed."
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