KNOWLEDGE BASE

Error "(...)unable to create database '<File path to a .tmp file>': open("<File path>/tableau-temp"): Too many open files" When Creating Extract


Published: 27 Jun 2018
Last Modified Date: 27 Jun 2018

Issue

When trying to create an extract on Mac, the following error might occur: 

[-7] PQresultStatus: 7 ERROR: unable to create database '<File path to a .tmp file>': open("<File path>/tableau-temp"): Too many open files 
[SQL State: 58000] [Severity: ERROR] [Primary message: unable to create database '<File path to a .tmp file>': open("<File path>/tableau-temp"): Too many open files

Environment

  • Tableau Desktop
  • Mac OSX

Resolution

Delete unused temporary files under the tableau-temp directory (<File path>/tableau-temp).
 
 

Cause

Tableau Desktop creates temporary files under the tableau-temp directory. If the temporary files cannot be created for some reasons, the error message is displayed.
Did this article resolve the issue?