Tableau Server Content Exploration Service
The Tableau Server Content Exploration Service extends the capabilities of the Search and Browse process and is responsible for indexing all content in Tableau Server. This service is available in Tableau Server 2021.1 and later and required to search and browse external assets such as databases and tables. Databases and tables are only available if you have Tableau Catalogue enabled.
The Content Exploration Service is applicable to both quick and filtered searches. This service is not based on SOLR but depends on the Elastic Search to perform its functions.
The Content Exploration Service is automatically installed on the first node where Application Server (vizportal) is installed.
For high availability and better performance, it is recommended that you install at least one instance of the Content Exploration Service on every node that is running the Application Server.
|Status||Status of the
|Logging||Logs generated by the
What happens when the Content Exploration Service fails?
If the Content Exploration Service stops working, any search requests for the content type it provides would fail to appear on the search results. Subsequent requests are routed to a healthy instance of the service. If the Content Exploration Service doesn’t start up on the node, you can try to start the service manually by running the following command:
sc start contentexploration_0
The Content Exploration Service has the ability to scale up as needed but based on the available memory on the node. However, there is a memory allocation set by default that determines the maximum amount of memory that can be used by the service. While it is not typically recommended that you change this setting if you are seeing performance issues due to insufficient memory allocation, you can run the following commands to change the maximum memory allocation setting.
First, retrieve the current maximum memory allocation by running the following command:
tsm configuration get -k content-exploration.vmopts
Run the following commands to change the maximum memory allocation by updating the -Xmx value only. Do not change any other options:
tsm configuration set -k content-exploration.vmopts -Xmx1024m -XX:+ExitOnOutOfMemoryError -Dspring.profiles.active=monolith
tsm pending-changes apply
The Content Exploration Service creates two sets of log files:
control_contentexploration*.log: These logs will contain information about the service starting and being enabled.
contentexploration_*.log: Any errors or problems are logged here.
For more information, see Tableau Server Logs and Log File Locations.
There are couple of ways the Content Exploration Service is used to make sure that searchable content is kept up to date:
- Whenever content managed by Tableau Server or Tableau Online is modified, including permissions, the Content Exploration Service re-indexes the relevant documents to keep its search indexes up to date.
- A system generated Backgrounder task that periodically validates that all content is properly synchronised and re-indexes any discrepancies that are found.
During restore, the restore process will initiate a full re-indexing of the content and external assets managed by Tableau Server. The re-indexing process consumes CPU resources which may be noticeable during backup and restore.