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: 21 Jul 2021

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. 
Did this article resolve the issue?