KNOWLEDGE BASE

"Error setting do_not_reap_extracts_before in database" and TSM Maintenance Backup Fails at 61%


Published: 26 Apr 2019
Last Modified Date: 25 Jun 2019

Issue

Creating a Tableau Server backup will intermittently fail at 61% completion during the "Uninstalling backup services" step. Additionally, the following error may be seen in the logs:

WARN com.tableausoftware.backuprestore.BackupRestoreServiceHandler - Error setting do_not_reap_extracts_before in database javax.persistence.TransactionRequiredException: Executing an update/delete query

Environment

  • Tableau Server 2019.1.2 and earlier
  • Tableau Server 2018.3.5 and earlier
  • Tableau Server 2018.2.8 and earlier

Resolution

Depending on the affected Tableau Server version, upgrade to the relevant maintenance release containing the fix:
  • Tableau Server 2019.1.3
  • Tableau Server 2018.3.6
  • Tableau Server 2018.2.9
See Tableau Server Downloads and Release Notes for downloads of current and previous versions of Tableau Server. For more information on current releases, see Upgrade Tableau Server and Server Upgrade.

Cause

This behavior (known issue ID 883869) has been fixed in more recent version of Tableau Server. 
Did this article resolve the issue?