Skip to main content

Posts

Showing posts from June, 2020

Tableau Server Is Down in Degraded State

Tableau Server Is Down in Degraded State After Run as User Password Changes or Expires When the Run As User's password changes or the user account expires in Active Directory,  Tableau Server will start in a degraded state after a system reboot, and Tableau Server will not be accessible. Updating the Run As User password in the TSM UI or with the command line "tsm configuration set -k runas.service.password -v <password>" commands has no effect. Versions: Tableau Server 2018.2, 2018.3, 2019.1, 2019.3, 2020.1, 2020.2 Windows Server 2012r2  or Windows Server 201 6 Tableau server can display the status:  Tableau Server Is Down in Degraded State after the Tableau upgrade process is complete and when you try to start or stop TSM. This appears when we try to use start tsm or stop tsm after upgrade. It requires the user to login to TSM Web utility using: https://localhost:8850/ (if you're working directly on the server computer) https://MarketingServer:8850/ (if yo

Login Prompt When Embedding Tableau Server in portals

Login Prompt When Embedding Tableau Server in portals When embedding the Tableau Server interface in a portal, accessing pages of Tableau Server, such as http://[tableau-server]/views returns a login prompt. This is the same information from Tableau Technote but I am saving for reference as I faced the issues and solved with the steps. Environment Tableau Server Trusted authentication Resolution Tableau's tach note says that this could be due to trusted authentication is for only single view but there could be scenarios in which the browser rejects the tableau URL due to security settings. If the case is with security settings it requires to add tableau web servers to the trusted sites which is also called Whitelisting. Also this tableau requires allow third party cookies setting to be enabled in the browser. To resolve this issue, enable unrestricted tickets. However, before you complete the following steps, see the cautionary note below them. Unrestricted tickets can be enabled b

Display Tableau View with the Ticket

Display Tableau View with the Ticket After you   create the POST request , you need to write code that provides the web server with the view’s location and the ticket from Tableau Server. It will use this information to display the view. How you specify it depends on whether the view is embedded, and if Tableau Server is running multiple sites. Tableau Server View Examples Here’s an example of how to specify a view that users only access via Tableau Server (the view is not embedded): http://tabserver/trusted/<ticket>/views/<workbook>/<view> If Tableau Server is running  multiple sites  and the view is on a site other than the Default site, you need to add  t/<site ID>  to the path. For example: http://tabserver/trusted/<ticket>/t/Sales/views/<workbook>/<view> Use the same capitalization that you see in the Tableau Server URL. Embedded View Examples Here are some examples of how to specify embedded views. Because there are two approaches you can

Tableau Migrate from Core-Based to User-Based Licensing

Process to Migrate from Core-Based to User-Based Licensing You can migrate Tableau Server from a core-based license metric (which counts the processor cores on which you have Tableau Server installed) to a user-based license metric (which counts named users) or vice versa Prepare for migration to user-based licensing Core-based licenses allow an unlimited number of users with  Explorer  and lower level site roles, including view-only guest accounts. Every user has a site role when they are added to Tableau Server, and these users and site roles persist when licensing is changed. Because user-based licenses limit the number of users, you should ensure that your new user-based licenses accommodate the number of users who are currently connecting to Tableau Server, including the users currently using guest accounts. If your new user-based licenses don't accommodate the full number of users, some users will become unlicensed.  To count the number of users in your Tableau Server install

Embedding Tableau Server Dashboards into a Website without Prompting for Credentials

Embedding Tableau Server Dashboards into a Website without Prompting for Credentials When embedding a Tableau Server view into a web page, how do I ensure that no prompt for username or password credentials is shown? To ensure no prompt for username or password credentials occurs inside an embedded view, both user credentials and database credentials need to be addressed. Here are all the options discussed but I could see that   using Trusted Authentication is the easiest one. How to enable trusted authentication is given on another article in this blog. Tableau Server User Credentials Tableau Server must be able to authenticate the viewer of an embedded Tableau Server view as a valid Tableau Server user before allowing the user to open the embedded view. This can result in a login screen being presented. There are several options to prevent this: Option 1: Use Guest user access If Tableau Server uses a core-based license, a  Guest User  can be enabled which would allow any viewer to a

Test Trusted Authentication on Tableau server

Test Trusted Authentication The steps below provide a method you can use to test retrieving a trusted ticket from your web server. This simple test can help evaluate connectivity between the web server and Tableau Sever, and whether or not trusted authentication has been configured correctly. Important : The test code provided in this topic runs client-side in the browser to provide a quick, visual validation that trusted authentication is configured correctly on Tableau Server. If the client browser loading the html page is not on the trusted web server, you may have to temporarily trust the client IP. In practice, you should never trust client IP addresses as part of your trusted authentication configuration. All trusted IP addresses are able to request tickets as any user including your administrator. In a production environment, all trusted authentication flows should run server-side, between Tableau Server and the trusted web server(s) only. Because the test is run on a client bro

Tabadmin commands with a corresponding TSM CLI command

The following table shows which tabadmin commands correspond to commands available in the TSM CLI. Command Description Tabadmin Command(s) Comparable TSM CLI Command Activate a license tabadmin activate --activate tsm licenses activate Deactivate licenses tabadmin activate --return tsm licenses deactivate Activate a trial license tabadmin activate --trial tsm licenses activate --trial Create a backup of the data managed by Tableau Server tabadmin backup tsm maintenance backup A backup created using TSM does not include any server configuration data. There is no option to include server configuration data. Clear the server cache tabadmin clearcache tsm maintenance cleanup -r Clean up temporary files and old log files tabadmin cleanup tsm maintenance cleanup Update the server configuration with any changes you've made tabadmin configure tsm pending-changes apply Customize the server name and logos tabadmin customize tsm customize Enable access to the repository tabadmin dbpass tsm da