KNOWLEDGE BASE

TSM Maintenance Backup Error "Did not parse exactly one backup result, got 0" with PGPASSWORD or PGUSER Environment Variables Set


Published: 17 Sep 2018
Last Modified Date: 04 Apr 2019

Issue

When running a backup with PGPASSWORD and/or PGUSER postgres environment variables set, the following error occurs:
Did not parse exactly one backup result, got 0

Environment

  • Tableau Server 2018.2.0 - 2018.2.3, 2018.3.0
  • Windows Server 
  • TSM Web User Interface
  • CMD Administrator Window

Resolution

Option 1: 

Upgrade to Tableau Server 2018.2.4, 2018.3.1, or a newer version. Click here for downloads of current and previous versions of Tableau Server: Tableau Server Downloads and Release Notes. For more information on current releases, see Upgrade Tableau Server and Server Upgrade.

Option 2:

Use the following workaround:
  1. Remove PGPASSWORD from the User and System Environment Variables in Windows System Properties.
  2. Reboot the server (hardware reboot) for the change to take effect.

Cause

This behavior is related to a known issue with ID 821312  which was corrected in Tableau 2018.2.4 and 2018.3.1.

Additional Information

Note: The error message Did not parse exactly one backup result, got 0 is a generic error message indicating that the backup failed. If the PGPASSWORD or PGUSER environment variables are not set on the computer running Tableau Server, this article does not apply.  


Discuss this article... Feedback Forum
Did this article resolve the issue?