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]
- Fusion Applied Training Mobile Apps Released - August 26, 2018
- Using RPA vs API based Integration - June 7, 2018
- Chatbots with DialogFlow and AWS Rest Services - May 9, 2018