KNOWLEDGE BASE

Error "Session Ended by Server" When Dashboard Load Times Out After 30 Minutes


Published: 05 Dec 2013
Last Modified Date: 02 Sep 2016

Issue

When loading a dashboard on Tableau Server, the dashboard fails to load within 30 minutes and the following error might occur:
 
Session Ended by Server
An unexpected error occurred on the server. If you continue to receive this error please contact your Tableau Server Administrator.
Tableau Server (<version>) encountered an error while working with this worksheet.

Environment

Tableau Server

Resolution

Increase the query time out limit.
  1. On the computer running Tableau Server, open the Command Prompt window as an administrator and run one of the following commands:
    • On a 32-bit computer: cd "C:\Program Files\Tableau\Tableau Server\[version]\bin"
    • On a 64-bit computer: cd "C:\Program Files (x86)\Tableau\Tableau Server\[version]\bin"
  2. At the command prompt, run the following commands in order:
    • tabadmin stop 
    • tabadmin set vizqlserver.querylimit 3600 
    • tabadmin config
    • tabadmin start
Note: 3600 is one hour in seconds. The default value 1800.

Cause

The default query timeout on Tableau Server is 30 minutes. If running a query takes more than 30 minutes, Tableau Server stops the query, and this error message displays.
Did this article resolve the issue?