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 the following:

• gateway.timeout: 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: Vizqlserver.querylimit specifically covers the queries executed to return views or populate extracts.

The gateway.timeout and vizqlserver.querylimit values are in seconds with these default values: gateway.timeout = 1800 and vizqlserver.querylimit = 30. Consult with a database administrator to determine the best timeouts for your environment.  If the vizqlserver.querylimit is being increased above 1800 seconds, be sure to increase the gateway.timeout accordingly with the command ‘tabadmin set gateway.timeout NNNN’ where NNNN is the number of seconds.

For a detailed listing of other Tableau Server parameters, see the "Reconfiguring the Server" section in the Tableau Server Administration Guide.

The example below increases the vizqlserver.querylimit timeout to 900 seconds, or 15 minutes.

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.