Timeout when Publishing or Viewing

• 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 (30.000 seconds) was exceeded.
• Vizql::Error: Timeout error
  Code: 999
  Details:
  Timeout communicating with server: execution expired
• Operation cancelled.
  The session has exceeded the 30s limit
• HTTP request failed (400)
• Cannot connect to Tableau Server. Please check the server name and port and try again.

When publishing a workbook, refreshing an extract or viewing a workbook on Tableau Server, there are two main timeout settings to be aware of. These two settings are gateway.timeout and vizqlserver.querylimit. Gateway.timeout covers the length of any action on Tableau Server, such as publishing a workbook with a large external file or extract. Vizqlserver.querylimit specifically covers the queries executed to return views or populate extracts.

This document will guide you through changing these two timeout settings. The gateway.timeout and vizqlserver.querylimit values are in seconds, the default being 30 seconds. This example increases the timeouts to 900 seconds, or 15 minutes. Consult with a database administrator to determine the best timeouts for your environment.

For a detailed listing of other Tableau Server parameters, see Appendix D: Reconfiguring the Server in the Tableau Server Administration Guide.

Step 1

Log into the machine Tableau Server is installed on as an administrator or with the Tableau Server User account.

Step 2

In the command Window, change directories using the file path for the Tableau Server bin directory, for a default 32-bit Windows installation this would be:

cd "C:\Program Files\Tableau\Tableau Server\{version}\bin"

Step 3

Once in the Tableau Server bin directory, run the following commands:

tabadmin stop
tabadmin set vizqlserver.querylimit 900
tabadmin configure
tabadmin start

Once Tableau Server is restarted, test the last action that lead to the error message. If necessary, adjust the timeout limits upwards again. If the limits are still being reached, have a database administrator check the query that is being run. If all seems in order on the database side contact support@tableausoftware.com.