Tableau Server Acceleration Status Showing an Error

Issue

In Tableau Server Tasks, some of your views or workbooks are showing an error in the Accelerated Views tab under the Acceleration status column.

User-added image

Environment

Tableau Server 2022.3 or newer

Resolution

Query is complex

If the query is too complex and acceleration won't significantly improve the performance of the view, acceleration isn't available. For more information on why the View Acceleration is not available, please review the Tableau Online Help.

Upgrading to Tableau Server 2023.1 or newer can improve your experience and show a recommendation for optimizing resources. Information on this change is available on the Tableau website.

User Function is used

If the views or workbook are using user-based functions, then the effectiveness of the acceleration for these views will be impacted because the view relies on providing different results for different users which significantly increases the CPU, memory and storage.

Cause

There are two possible causes for the error status:

1. A User function is being used in the view or workbook
2. The query is too complex

Additional Information

Tableau Server (nativeapi_backgrounder) logs will reflect output similar to the following when a user function is being used.

From nativeapi_backgrounder_1-0_2023_08_09_00_00_00.txt:

{"ts":"2023-08-09T18:25:52.108","pid":125129,"tid":"47e","sev":"info","req":"0b40bd3b-e08b-4cfd-ae92-dc67e4edf74f","sess":"F9D9D42ABE05447A8EC9BCD1BF4C0C92-1:0","site":"Default","user":"testuser","k":"lock-session","v":{"caller":"CreateAndLockTransientWorkbookSession","sess":"F9D9D42ABE05447A8EC9BCD1BF4C0C92-1:0","session-bootstrap-attr-hash":"57486309","session-key-hash":"0543f472","site":"Default","user":"testuser","workbook":"Book1"}}

{"ts":"2023-08-09T18:26:06.305","pid":125129,"tid":"1ec6f","sev":"info","req":"0b40bd3b-e08b-4cfd-ae92-dc67e4edf74f","sess":"F9D9D42ABE05447A8EC9BCD1BF4C0C92-1:0","site":"Default","user":"testuser","k":"tableau-materialized-views","v":{"msg":" query with hash 1166844557270455330 is skipped for materialization because query result is user sensitive."}}

Tableau Server (nativeapi_backgrounder) logs will show the following when the query size is too big:

{"ts":"2023-08-10T06:04:14.682","pid":23610,"tid":"c053","sev":"info","req":"3b0741b4-d616-4459-bf1f-570509d90ff3","sess":"D516BE7C9A9945D482B178C16C37890C-1:1","site":"Default","user":"christopher","k":"lock-session","v":{"caller":"CreateAndLockTransientWorkbookSession","sess":"D516BE7C9A9945D482B178C16C37890C-1:1","session-bootstrap-attr-hash":"57486309","session-key-hash":"0543f472","site":"Default","user":"testuser","workbook":"Book1"}}

{"ts":"2023-08-10T06:04:52.873","pid":23610,"tid":"601f","sev":"info","req":"3b0741b4-d616-4459-bf1f-570509d90ff3","sess":"D516BE7C9A9945D482B178C16C37890C-1:1","site":"Default","user":"testuser","k":"tableau-materialized-views","v":{"msg":" query with hash 8200387738261871100 is skipped for materialization since query size 2372318 greater than the limit 2097152"}}

For additional information from the Tableau Online Help see the following:

View Acceleration
User Functions