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

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: 08 Feb 2019

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.