Issue
The error "Deadline Exceeded" occurs when fails to refresh extract with queries that take a long time to process
If the Query process takes a long time and the connection is idle for a long time, the NAT gateway times out.
Last Modified Date: 21 Feb 2023
Environment
- Tableau Server
- PostgreSQL
- JDBC Connection
Resolution
Enable TCP keep-alive by using properties file1. Prepare properties file named "postgres.properties"
Add "tcpKeepAlive=true" in the file.
"Initializing the Driver"
2. Place the "postgres.properties" to the following directory on all server nodes:
- Windows: ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Datasources
- Linux: /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources/
"Customize JDBC Connections Using a Properties File"
3. Restart Tableau Server
Cause
The connection that's using a NAT gateway may time out.Additional Information
Internet connection drops after 350 seconds (AWS document)Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials