Error "The process cannot access the file because it is being used by another process" when trying to refresh extracts

Tableau / Tableau Server
Solution Deployed

Deployed In Current - 2022.3.10, 2022.4.7, 2023.1.6, 2023.2.2, 2023.3.1

Created

Jun 30, 2023

Found in Release

2022.3.x

Last Updated

Oct 27, 2023

Reference ID

W-12824663

Summary

When use calculated fields from an extract with dynamic zone visibility or dynamic axis tittles, refresh extracts failed.

Error Details

The process cannot access the file because it is being used by another process.

Steps to Reproduce

1. Create a workbook and use calculated fields from an extract with dynamic zone visibility or dynamic axis titles.

2. Publish workbook to Tableau Server.

3. Schedule an extract refresh.

4. Wait to refresh to run or select "Run now".

5. Check the Jobs page.

Workaround

Option 1

  • Check which sheets were causing issues. There can be hidden visualizations as well using Dynamic Zone Visibility.
  • Replace them with other ways to show/hide them.

Option 2

  • Use parameters with dynamic zone visibility instead of calculated field. For more information, See Use Dynamic Zone Visibility.

Option 3

  • Use a live data connection instead of extract.

Option 4

  • Use Tableau Server on Linux or Tableau Desktop to run the extract refresh.


Updates

10/26/23 - Option 5 removed due to unintended issues caused by workaround. Fix confirmed in several versions now: 2022.3.10, 2022.4.7, 2023.1.6, 2023.2.2
Reference IDW-12824663
Solution Deployed

Deployed In Current - 2022.3.10, 2022.4.7, 2023.1.6, 2023.2.2, 2023.3.1


18 Reports

18 Reports