Deploying Tableau Server 9.0 (32-bit) on Google Cloud
John Liska May 7, 2015 8:15 AMI'm posting this as a heads up for anyone in the Tableau community who is trying to deploy Tableau Server 9.0 on Google Cloud. There is "glitch" that I've encountered so I wanted to make folks aware of what I found and what the workarounds are.
Setup
First off, I'll list my setup. (What I'm encountering may not apply to different configurations.)
- Platform: Google Cloud
- OS: Windows Server 2008 R2
- Machine Type: n1-standard-4 (4 vCPU, 15 GB memory)
- Physical cores: 2
- Tableau Server Version: 9.0 (32-bit)
I have to run the 32-bit version of Tableau Server 9.0 because the 64-bit version requires the machine to have 4 physical cores.
Issue
The core issue is that after re-cyling the machine -- via the Google Cloud console, not "restart" on Windows -- I'm no longer able to see my Tableau data in Server: sites, dashboards, etc.
Steps to Reproduce
Here is how I encountered this issue:
- Clean install of Tableau Server (32-bit) on a new Windows Server 2008 R2 instance in Google Cloud.
- I restored an earlier (v8.3) backup of all of my Tableau Server work -- sites, dashboards, etc. -- in this new 9.0 install.
- I verified that I could see all of my data and work with the dashboards.
- I went into the Google Cloud console and ran "Stop" on the machine.
- I then went back into the Google Cloud console and run "Start" on the machine.
- I opened up an RDP connection to the machine and went into Tableau Server; I was able to login without any issues.
- Once I was logged in I could not see the data that was there previously: sites, dashboards, etc.
Workaround (long-term)
In order to resolve this issue long-term here is what I did, based on the recommendation from Tableau Support:
- [make sure the machine instance is running on Google Cloud console.]
- Open up an RDP connection the machine.
- Open up Server Manager; navigate to Configuration > Services
- Right-click on "Tableau Server Application Manager"; select Properties
- Change the Startup Type field from "Automatic" to "Automatic (Delayed Start)"; click OK.
Workaround (short-term)
In order to resolve this issue immediately here is what I did, based on the recommendation from Tableau Support:
- [make sure the machine instance is running on Google Cloud console.]
- Open up an RDP connection the machine.
- Right-click on the Command Prompt application and select "Run as administrator".
- Navigate the [Tableau Server install]\bin directory.
- Run "tabadmin stop"; wait for the service to stop successfully.
- Run "tabadmin start"; wait for the service to start up successfully.
Stop #3 is critical; this workaround will not succeed unless you open the command prompt window as the administrator.
Root Cause
I've been working with Tableau Support on this issue. (For reference, the case number is #01433040.) What I have heard so far is that this is an issue with the Search & Browse index failing to build when Tableau Server starts. In other words: all of my data (from the restore that I did) is still there, but the search index is screwed up somehow so it only looks like my data is gone. The short-term workaround -- stop + start -- allows Tableau Server to rebuild the index correctly.
The long-term workaround that I listed above seems to work because the problem is happening when Tableau Server is trying to start alongside all of the other Windows services that are starting when the machine boots. (Again, my experience is that doing a "restart" via Windows did not cause this; only the hard "stop" + "start" via the Google Cloud console caused this.) By setting the Start type of the Tableau Server service to Automatic (Delayed Start) the Windows services are all given priority to get up and running before Tableau Server even attempts to start up. In that environment the search index builds correctly.
Again, this issue may be specific to the combination of v9.0 (32-bit) + Windows Server 2008 R2 + Google Cloud, and may not apply to other configurations (e.g., AWS, v9.0 64-bit, etc.).