Query Results in WebCenter Content Presenter

I was trying to display some content from UCM in webcenter to research an issue we are having at our current client. I dropped a content presenter taskflow on a page and decided to display results of a query in that taskflow.
No matter what query conditions I provided, there were no results in the Preview Query Results table. There were no errors in the webcenter space log or or the content server log. The same query works from UCM.

The problem is most likely in the configuration of the Content Server. If you check the config.cfg from the content server, you probably are missing to directives:
SearchIndexerEngineName
IndexerDatabaseProviderName

Configure Oracle Text Search as described at:
Configuring Oracle Text Search for Oracle Content Server
Working with the Search Index

TLDR; Edit the $DOMAIN_HOME/ucm/cs/config/config.cfg file and add the two following lines:
SearchIndexerEngineName=OracleTextSearch IndexerDatabaseProviderName=SystemDatabase

You can verify the SearchIndexerEngineName being used from:
http://cs/idcplg?IdcService=GET_ENVIRONMENT&IsSoap=1
Look for the SearchIndexerEngineName entry.

Save the file and restart the content server managed server and the WebCenter managed server. Now, login to the UCM server at http:///cs
Go to -> Administration > Admin Applets
-> Repository Manager > Indexer tab – click the Start button

Reference:
1. Oracle support ID: 1326427.1 :Basic/Advanced Search in Oracle Webcenter Spaces/Portal Does Not Return Any Documents in Taskflows – UCM SearchIndexerEngineName

2. Switching from Verity to DATABASE.FULLTEXT on Oracle Database [ID 844808.1]

Author
Recent Posts

vivek

Oracle Fusion Middleware Architect at FUSION Applied

Vivek is an Oracle Certified Fusion Middleware architect. He has over 18 years of experience implementing custom software solutions in the Financial, Health, and Government sectors. He is one of the founders of Fusion Applied.