KNOWLEDGE BASE

Error "Unable to materialize temporary table" Joining Data Sources


Published: 31 Aug 2016
Last Modified Date: 13 Jan 2017

Issue

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

Unable to materialize temporary table

Environment

Tableau Desktop 10.0.0

Resolution

Work with your IT team to add 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. 

Navigate to C:\Program Files\Tableau\Tableau <VERSION>\bin for 64-bit version. 
Navigate to C:\Program Files (x86)\Tableau\Tableau <VERSION>\bin for 32-bit version.

Add the following files to the exceptions list within the antivirus software and Windows Defender:
  • custactutil.exe
  • installanchorservice.exe
  • uninstallanchorservice.exe
  • tableau.exe
  • tabprotosrv.exe
  • TabOnlineSyncClient.exe
  • TabOnlineSyncClientCmd.exe
  • TabOnlineSyncSvc.exe
  • tdeserver64.exe

 

Cause

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