Loading

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

Julkaisupäivä: Feb 21, 2025
Kuvaus
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.

Cause

Tableau Server will only allow file-based data sources from specific locations.
Ratkaisu
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: 
tsm configuration set -k native_api.allowed_paths
 
If the value returned does not include a path or parent directory of where the file is located, then Tableau Server will not be allowed to access the file.. Add specific desired file locations separated by a a semicolon (;) to allow new locations to be used.
 

To configure access to shared files, you must configure allowlist functionality. This lets the Run As service account to access just the local directory paths, or shared directories where you host data files.

  1. On the computer running Tableau Server, identify the directories where you will host data source files.

    Important Make sure the file paths you specify in this setting exist and are accessible by the service account. If the paths are not accessible when the computer starts, Tableau Server will not start.

  2. Run the following commands:

    tsm configuration set -k native_api.allowed_paths -v "path" , where path is the directory to add to the allowlist. All subdirectories of the specified path will be added to the allowlist. If you want to specify multiple paths, separate them with a semicolon, as in this example:

    tsm configuration set -k native_api.allowed_paths -v "c:\datasources;\\HR\data"

    tsm pending-changes apply






 
Knowledge-artikkelin numero

001472938

 
Ladataan
Salesforce Help | Article