KNOWLEDGE BASE

Error "Tableau Server initialization failed." in Configuration and Initialization Window During Install


Published: 26 Sep 2016
Last Modified Date: 17 Nov 2016

Issue

While installing or upgrading Tableau Server, after clicking OK on the "Configuration and Initialization" window, the following error occurs:
Tableau Server initialization failed. See install log at <filepath>.

Additionally, the logs may indicate:
Error during restore… failed with code 2, result was psql: FATAL: database "workgroup" does not exist

Environment

Tableau Server 

Resolution

Step 1: Confirm the Run As User account has explicit permissions to the Tableau Server data and pgsql folders.

Note: Run As User permissions as part of a group such as “Administrator” do not always enable proper access.
  1. Navigate via Windows Explorer to the Tableau Server data folder.
    • If installed at the default location, the folder will be at C:\ProgramData\Tableau\Tableau Server\data (to see ProgramData you may need to view hidden folders).
    • If installed at a custom location, the data folder will be under the Tableau Server folder where it has been installed.
  2. Right click on the data folder and choose Properties, then open the Security tab.
    • Confirm that the Run As User has been granted read, execute, and write permissions.
  3. Return to the folder view and navigate to Tableau Server\data\pgsql.
  4. Right click on the pgsql folder and choose Properties, then open the Security tab.
    • Confirm that the Run As User has been granted read, execute, and write permissions.
  5. If any permissions are missing for either data or pgsql, refer to the instructions for “Installing on non-system drive or in a different folder” under the following article: Required Run As User Account Settings. Substitute the Tableau Server data folder for “Local Disk (C:)” in the instructions.

Step 2: Confirm that the UAC (User Account Control) is not preventing the Run As User from opening the Tableau Server data or pgsql folder. 

  1. Log into the Tableau Server computer using the Run As User credentials.
  2. Navigate via Windows Explorer to the Tableau Server data folder.
    • If installed at the default location, the folder will be at C:\ProgramData\Tableau\Tableau Server\data (to see ProgramData you may need to view hidden folders).
    • If installed at a custom location, the data folder will be under Tableau Server.
  3. Double click the data folder, then the pgsql folder. 
    1. If there are no prompts for administrative credentials, there is no need to change the UAC settings.
    2. If there is a prompt for credentials, push OK, and then disable UAC:
      1. Click the Start button, and select Control Panel > User Accounts > Change User Account Control settings. Move the slider down to the lowest level to disable UAC.
      2. Return to Windows Explorer to verify that the Run As User can now open the data and pgsql folders with no prompts to enter administrative credentials.

Step 3: Resume the installation process

  1. Open the Command Prompt as an administrator and navigate to the Tableau Server bin folder.
    • By default, this folder is located at: C:\Program Files\Tableau\Tableau Server\[version]\bin
  2. Run the following command in the Command Prompt: tabadmin init -i 
  3. If restoring from a backup (.tsbak) file, run the following commands after tabadmin init –i has completed:
tabadmin verify_database
tabadmin restore --no-config

Cause

The Run As User does not have necessary permissions to access the repository database.

Additional Information


 
Did this article resolve the issue?