Hello Tableau Community,
I am currently working on Tableau Server and encountering issues with long-running extract refreshes timing out. I understand that settings such as
backgrounder.timeout_tasks
and
backgrounder.querylimit
might be relevant, but I am having difficulty verifying or adjusting these values.
Here are the steps I have tried so far:
- I ran the following command to check the timeout settings:
tsm configuration get -k backgrounder.timeout_tasks
However, I didn’t get a numerical value; instead, I received a list of available keys.
I tried setting new values for backgrounder.timeout_tasks and backgrounder.querylimit using the following commands:
tsm configuration set -k backgrounder.timeout_tasks -v 28800
tsm configuration set -k backgrounder.querylimit -v 7200
After applying the changes and restarting Tableau Server, I still couldn’t verify whether the new timeout settings were applied.
Here are my specific questions:
- How can I verify the current timeout values for backgrounder.timeout_tasks and backgrounder.querylimit on Tableau Server?
- Is there a step-by-step guide or a resource (e.g., video or documentation) that demonstrates these configurations live?
- Could there be other settings or external factors (e.g., database timeouts or network issues) that are affecting the extract refreshes?
Any guidance, best practices, or resources to address these issues would be greatly appreciated. Thank you in advance!
Best regards,
Nihar Dattani
Hi @Nihar Dattani, you most likely broke something along the way because backgroundertimeouttasks is meant to be a list of backgrounder types not a timeout integer value.
https://help.tableau.com/current/server/en-us/cli_configuration-set_tsm.htm#backgroundertimeouttasks
So restore it with tsm configuration set -k backgrounder.timeout_tasks -d and re-apply pending changes.
The types listed there are controlling the involvement of key
"tsm configuration get -k backgrounder.extra_timeout_in_seconds" which is the number of seconds beyond the query limit before a task is canceled. So also tasks like subscriptions, acceleration etc...
For extract refresh, you were already right with backgrounder.querylimit.
Yes indeed, a timeout could also from any end point along the way to your database, so Tableau Server timeout, ODBC or JDBC configured timeout, Reverse Proxy or Load Balancer timeout if involved on the way to your Database Cluster, and finally Database Server Timeout.
