KNOWLEDGE BASE

Errors "java.util.concurrent.ExecutionException" or "Unable to connect to the file" Connecting to File-based Published Data Sources


Published: 27 Feb 2018
Last Modified Date: 28 Feb 2018

Issue

When attempting to connect to file based data sources on Tableau Server, the connection fails and the error suggests that Server may not have sufficient privileges.  You might see one of the following errors after an extract refresh attempt, or trying to view a workbook with the underlying data:
  • java.util.concurrent.ExecutionException: com.tableausoftware.nativeapi.dll.DataSourceException: Invalid database name value
  • Unable to connect to the file "D:/Tableau Server/data/tabsvc/temp/TableauTemp/xxxx".  Check that the file exists and that you have sufficient access privileges for it.

Environment

  • Tableau Server
  • Excel or CSV files

Resolution

Check the configuration for native_api.allowed_paths.
On the computer running Tableau Server, open a command prompt as an administrator and navigate to the Tableau Server bin folder, located by default at C:\Program Files\Tableau\Tableau Server\<version>\bin
Enter the following command: 
tabadmin get native_api.allowed_paths
 
If the value returned is something other than default (which is "*") then Tableau Server will only allow file-based data sources from specific locations. Set it back to default, or add specific locations separated by a a semicolon (;) to allow new locations to be used.

To return the setting to default: 
On the computer running Tableau Server, open a command prompt as an administrator and navigate to the Tableau Server bin folder, located by default at C:\Program Files\Tableau\Tableau Server\<version>\bin
Enter the following commands:

tabadmin stop
tabadmin set native_api.allowed_paths -d
tabadmin configure
tabadmin start





 

Cause

If native_api.allowed_paths is set to something other than "*", Tableau Server will only allow file-based data sources from specific locations.
Did this article resolve the issue?