KNOWLEDGE BASE

Timeout Errors when Publishing and Viewing


Published: 01 May 2017
Last Modified Date: 28 Sep 2017

Issue

When you try to publish a workbook to Tableau Server or view a workbook on Tableau Server, one of the following errors occurs: 
  • Vizql::Error: Unable to load workbook 
    Code: 800 
    Details: Errors occurred while trying to load the workbook "[path]". The load was not able to complete successfully. The query time resource limit (1800 seconds) was exceeded.
  • Vizql::Error: Timeout error 
    Code: 999 
    Details: Timeout communicating with server: execution expired
  • Operation canceled. 
    The session has exceeded the 1800s limit.
  • HTTP request failed (400)
  • Cannot connect to Tableau Server. Please check the server name and port and try again.

Environment

  • Tableau Server
  • Tableau Desktop

Resolution

Configure gateway.timeout and vizqlserver.querylimit timeouts

Please note that for Tableau Server 10.4 or later versions, the following steps do not need to be performed for the gateway.timeout.

The example here shows you how to increase the vizqlserver.querylimit timeout to 3600 seconds, or one hour.

  1. From the computer running Tableau Server, open a command prompt as an administrator.
  2. Change to the Tableau Server bin directory using the appropriate path for your operating system and server version. For example:
    C:\Program Files\Tableau\Tableau Server\[version]\bin
  3. Run the following commands:
    • tabadmin stop
    • tabadmin set gateway.timeout 3600
    • tabadmin set vizqlserver.querylimit 3600
    • tabadmin configure
    • tabadmin start

Test the configuration settings

After Tableau Server is restarted, repeat the steps that led to the timeout error. If necessary, adjust the timeout limits again. If the limits are still reached, have a database administrator check the query that is being run.

Cause

A task ran longer than the time allowed by the query limit. 

Additional Information

The main Tableau Server timeout settings are: 
  • gateway.timeout: Covers the duration of any action on Tableau Server, such as publishing a workbook with a large external file or extract.

    Default value is 1800 seconds.

  • vizqlserver.querylimit: Covers specifically the queries executed to return views or populate extracts

    Default value is 1800 seconds.

If using Tableau Server 10.3 or earlier, when you increase vizqlserver.querylimit, please also increase the gateway.timeout accordingly. 
Did this article resolve the issue?