KNOWLEDGE BASE

Error “Extract failed to complete in 7200 seconds”


Published: 12 Mar 2013
Last Modified Date: 15 Aug 2016

Issue

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

Or

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

Environment

Tableau Server

Resolution

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.

Cause

The query exceeded the timeout variable set for extract refreshes.

Did this article resolve the issue?