Large Sas File Extract Refresh Failed And Huge Memory Consumption Observed After Upgraded Tableau Server To 2020.3.1

KNOWLEDGE BASE

Large Sas File Extract Refresh Failed And Huge Memory Consumption Observed After Upgraded Tableau Server To 2020.3.1

Published: 09 Dec 2020
Last Modified Date: 10 Dec 2020

Issue

After upgrading to Tableau Server from 2019.3.1 to 2020.3.1, large SAS-based extract refresh fails with tabprotosrv connection failure due to the error below:

"exceeded per-process memory threshold".

Large memory is consumed when this error occurs.

Environment

Tableau Server 2020.3.1
Windows Server 2016
large SAS file

Resolution

Workaround

For Tableau Desktop, run the following command

tableau.exe -DOverride=ReadStat:off,Rdata:off

For Tableau Server, use the following commands:

tsm configuration set -k features.ReadStat -v false
tsm pending-changes apply

Cause

This is due to the design/code change related to reading statistical files in Tableau Server 2020.1. This is under investigation by Tableau development team.