Tableau Data Engine Error 40705 typically indicates that Tableau has run out of resources to finish creating the extract. Tableau is able to create and handle fairly large extracts, however, there can often be physical and theoretical practical limits to the size of extracts.
- Launch a Command Prompt as an Administrator
- Navigate to the Tableau Server \bin directory
- Run tabadmin cleanup (more information about this command may be found here: https://onlinehelp.tableau.com/current/server/en-us/tabadmin_cleanup.htm )
- If possible, find more opportunities to clear up disk space on the Tableau Server machine.
Please let me know if these steps resolve the issue for you For more background on this issue, I'll quote a colleague of mine because their write-up is quite good and concise:
In terms of physical limitations, when creating the extract, the Temp directory, which is where an extract is stored during creation or a refresh, may require disk space up to the square of the final file size of the extract. If you're running low on space, this would account for the behavior you're seeing. The amount of available RAM may also limit the size of extracts that can be created. While the full data set is never loaded entirely into memory, creating extracts and querying extracts utilizes the local machine RAM and disk. These resources can be exhausted before the theoretical practical extract size limit, particularly if the data set is very large. Additionally, the space required to create an extract goes up exponentially when joins are involved.
This can also be caused by excessive memory fragmentation. When Tableau requests memory, it must be able to address the full size requested as a contiguous block. The memory requested must be contiguous, which is why some machines with a lot of available memory may see “out of memory” errors if the contiguous address space is not available.
For more detailed information about when to use an extract over a live connection, please see the following article:
In-Memory or Live Data: Which Is Better?