KNOWLEDGE BASE

Errors "unable to open database file" and "device or resource busy" Refreshing Published Extracts or Opening Attached Workbooks


Published: 26 Nov 2018
Last Modified Date: 06 Dec 2018

Issue

When refreshing a published extract in Tableau Bridge or Tableau Online, or when opening a workbook in Tableau Online or Tableau Desktop that is connected to the published data source, an error may occur:

"PQconnectdb: 1, ERROR:  error opening database 'hash/F0/90/4C/upload_{6A141FC8-4EA2-476D-BF94-F6006D4FC2E7}/<extract name>.hyper': There was an error during loading database 'hash/F0/90/4C/upload_{6A141FC8-4EA2-476D-BF94-F6006D4FC2E7}/<extract name>.hyper': unable to open database file "/mnt/tableau_filestore/dataengine/hash/F0/90/4C/upload_{6A141FC8-4EA2-476D-BF94-F6006D4FC2E7}/<extract name>.hyper": open("/mnt/tableau_filestore/dataengine/hash/F0/90/4C/upload_{6A141FC8-4EA2-476D-BF94-F6006D4FC2E7}/<extract name> .hyper", 0): Device or resource busy

Unable to connect to the Tableau Data Extract server "localhost". Check that the server is running and that you have access privileges to the requested database.

 

Environment

  • Tableau Online 10az pod
  • Published extract data source (note: live connections are not impact by this issue)

Resolution

As a workaround, republish the extract from Tableau Desktop.
If no local copy of the data source is available, a copy of the TDS file can be downloaded from Tableau Online and republished with the following steps:
 
  1. As an admin, or other user who has permission to download the data source, log into Tableau Online.
  2. Enter the following URL into the address bar:
    https://10az.online.tableau.com/t/<site url goes here>/datasources/<data source name goes here>.tds?noExtract=true
    The resulting download will be a .tdsx file.
    In the above example, the site url is what you see after the # in the URL when you're navigating Tableau Online. For example, the site URL for "Tableau Example Site" would be "tableauexamplesite". The data source name is the name of the data source, without spaces. For example, the datasource name for "Tableau Example Data" would be "TableauExampleData.tds".
  3. Change the newly downloaded file's extension from .tdsx to .zip, then unzip the file. Inside, you will find a .tds file containing the metadata for the connection.
  4. Open the file in Tableau Desktop on a computer that has access to the original data source (Excel file, SQL Server, etc).
  5. When the Extract Not Found dialog box displays, do the following:
    • Select Regenerate the extract and click OK.
    • When prompted, save the .hyper file.
    • If prompted, sign into the database.
  6. Select Server >  Publish Data Source > <data source name>.
    Republishing will overwrite the existing data source and automatically update all connected workbooks to use the new extract.

Cause

This behavior is related to a known issue which is currently under investigation. 
Did this article resolve the issue?