KNOWLEDGE BASE

Error "Unable to materialize temporary table" Joining Data Sources


Published: 31 Aug 2016
Last Modified Date: 03 Feb 2017

Issue

When joining across multiple data sources, the following error might occur:

Unable to materialize temporary table

Environment

Tableau Desktop 10

Resolution

Work with your IT team to add the below files, located in the Tableau bin folder, as exceptions to your antivirus software and Windows Defender.
Note: Even if there is no antivirus software installed, Windows Defender may still be preventing the join from completing. 
  • custactutil.exe
  • installanchorservice.exe
  • uninstallanchorservice.exe
  • tableau.exe
  • tabprotosrv.exe
  • TabOnlineSyncClient.exe
  • TabOnlineSyncClientCmd.exe
  • TabOnlineSyncSvc.exe
  • tdeserver64.exe
By default, the Tableau bin folder is located by default at C:\Program Files\Tableau\Tableau <VERSION>\bin for 64-bit versions of Tableau Desktop or C:\Program Files (x86)\Tableau\Tableau <VERSION>\bin for 32-bit versions of Tableau. Desktop.

Cause

Antivirus is preventing Tableau Desktop from working as expected. 
Did this article resolve the issue?