KNOWLEDGE BASE

Extract Refreshes fail or take a long time After Upgrading


Published: 07 Aug 2018
Last Modified Date: 08 Aug 2018

Issue

After upgrading from Tableau Server 10.3.X to 10.5.X or later, extract refreshes fail or take a long time. 

Additionally, depending on your hardware:
  • If the hardware is fast enough, extract refreshes may take up to 5x as long in 10.5 and later versions (hyper).
  • If the hardware is not sufficient, the refreshes may appear to fail or timeout, and the following errors might occur on the Background Tasks for Extracts Admin View:
    • DataSourceException: Unable to materialize temporary table
    • DataSourceException: server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request.
    • DataSourceException: ERROR: canceled

 

Environment

Tableau Server 10.5 (and later versions)

Resolution

As a Tableau Server Administrator, upgrade to Tableau Server 2018.1.3. For more information, see Upgrading Tableau Server in Tableau Help. 

Cause

This issue is being investigated. 
Did this article resolve the issue?