Last Modified Date: 04 Apr 2019
- Tableau Server
- Tableau Desktop
ResolutionFor immediate resolution:
- Work with your database administrator to close out connections from the database side
- Restart Tableau Server
- Reduce the maximum size of the connection pool using protocolcachesize.
- Reduce the lifetime of connections in the pool using protocolcachelifetime_in_minutes.
- On the computer running Tableau Server, open a command prompt as an administrator.
- Navigate to the Tableau Server bin folder
- Enter the following commands. (The values for each option are suggestions. Adjust the values as appropriate for your environment.)
Versions 2018.1 and older using TabAdmin
tabadmin set vizqlserver.protocolcachelifetime_in_minutes 10
tabadmin set dataserver.protocolcachelifetime_in_minutes 10
tabadmin set vizqlserver.protocolcachesize 50
tabadmin set dataserver.protocolcachesize 50
Versions 2018.2 and newer using TSM
tsm configuration set -k dataserver.protocolcachelifetime_in_minutes -v 10
tsm configuration set -k vizqlserver.protocolcachesize -v 50
tsm configuration set -k dataserver.protocolcachesize -v 50
tsm pending-changes apply
If receiving a warning regarding unknown configuration keys from tsm, append --force-keys flag.
CauseTableau Server keeps connections open in order to speed workbook load.
Connections will be closed in two cases:
- The connection hasn’t been used in protocolcachelifetime_in_minutes.
- The size of the pool has reached protocolcachesize.
On Tableau Server 10.5 and older versions, we clear the pool only when the pool is accessed. Because of this, connections can linger on an idle server. Tableau Server 2018.2 and newer versions regularly clear the pool.
Discuss this article...