Error “Extract failed to complete in 7200 seconds”

Published: 12 Mar 2013
Last Modified Date: 23 Mar 2018


An extract refresh fails with the following Tableau Server error:

Timeout Error - Canceling task that took longer than 7200 seconds
Extract failed to complete in 7200 seconds


com.tableausoftware.nativeapi.dll.ResourceGovernorException: The query time resource limit (7200 seconds) was exceeded


Tableau Server


Increase the value for the backgrounder.querylimit parameter.

  1. Open a Command Prompt, and change directories to the Tableau Server\bin directory.

    For example: cd "C:\Program Files\Tableau\Tableau Server\<version>\bin"

  2. Run the following command to stop Tableau Server:

    tabadmin stop

  3. Run the following additional commands to increase the querylimit parameter, configure Tableau Server with the new setting, and restart Tableau Server with the new configuration:
    • tabadmin set backgrounder.querylimit 9000
    • tabadmin configure
    • tabadmin start
  4. Log in to Tableau Server and attempt to refresh the extract using the Refresh Now option.

    If the refresh fails with the same error after the 9000 seconds (or 2.5 hours), repeat these steps, setting the querylimit parameter value to 10800.


The query exceeded the timeout variable set for extract refreshes.

Did this article resolve the issue?