My Oracle Support Banner

COLLECTION_SEARCH_CONTENT Performs Unbound Queries When Folder Parameter Is Invalid Folder (Doc ID 1985817.1)

Last updated on MAY 27, 2021

Applies to:

Oracle WebCenter Content - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

When COLLECTION_SEARCH_CONTENT is run with an invalid folder as a parameter, the search is still run without using the folder as part of the query criteria.

This can return a large number of items, and the searches can take a long time.

For example, running a service like this, where Folder2 is not a valid folder, returns every content item checked into the server:

http://xxxxxxxxx.example.com:16200/cs/idcplg?IdcService=COLLECTION_SEARCH_CONTENT&dCollectionPath=/Contribution%20Folders/Folder2&dOriginalName=df1.txt&dReleaseState=Y&hasCollectionPath=true

Instead, it should return 0 results since there are no matches on the original query, due to the dCollectionPath being invalid.

Cause

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
Symptoms
Cause
Solution
References


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