KNOWLEDGE BASE

"Database error 0x80004005: Not a valid path" Error after Refresh


Published: 17 Apr 2013
Last Modified Date: 20 Jun 2017

Issue

You may see the following error messages when a refresh or scheduled refresh of a workbook or extract fails:
 
com.tableausoftware.nativeapi.dll.DataSourceException: Microsoft JET database error 0x80004005: 'Y:<filename>.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
The table "Table" does not exist.
Unable to connect to the Microsoft Access database"\\unc_path\file.mdb". Check that the path is correct and that you have access privileges for the requested file.


Or
 
com.tableausoftware.nativeapi.dll.DataSourceException: Database error 0x80004005: 'C:<filename>.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Unable to connect to the Microsoft Excel file "
C:<filename>.xlsx". Check that the path is correct and that you have access privileges for the requested file and that it is not open in another location
 

Environment

  • Tableau Server
  • Microsoft Access or Microsoft Excel

Resolution

To help resolve this issue, check the following: 
  • Make sure that the full UNC path is used to connect to the data source in the workbook as referred to in the Error: "Error communicating with the repository (999)..." When Publishing Workbook with a File-Based Data Source article. 
  • Check if the data source (i.e., Microsoft Access or Microsoft Excel) is connected to a file located on a shared drive. If the file is located on a shared drive, use the full UNC path. Note: A UNC path is the full path of a resource or file that is stored on the computer, which includes the full computer name, drive, path to the file, and file name. For example, a text file with a mapped path to D:\datasource.txt has a UNC path that looks like the following: \\workstation1\d$\datasource.txt, where “workstation1” is the full computer name.
  • Check to make sure that the Tableau Server Run As User account has permission to access the file on the shared drive.
 

Cause

This issue occurs when a filed-based data source is located on a shared drive. When the data source is on a shared drive, the full UNC path must be specified and the Run As User account must be allowed access to the file location.
 

Did this article resolve the issue?