Skip to main content

#Tableau Server67 人正在讨论

When looking at the data source tab of a report I don't own, that has an extract generated from Snowflake (using stored OAUTH credentials in the report owner's account), editing the connection, I see this:Why can't I see that Snowflake credentials are used?The owner of the report sees this:image.png

I spent a while wondering how this report was successfully updating without any credentials. Now that I know, I'll probably just ignore it, but that means I can't diagnose if that's the reason a report is legitimately not updating, without asking the owner (who may not be available) to check for me. That dialog will look the same to me whether there are stored credentials or not. Am I overcomplicating it (cos' I'd get some other extract error if there was, say, a query problem, so this would be the catch-all)? 

 

#Tableau Desktop & Web Authoring  #Tableau Server

3 个回答
  1. 今天,12:20

    Hi, 

    I personally never noticed that when auditing snowflake keypairs or OAuth embedded authentication. But I'm always a Tableau Server Admin. Most likely the saved credential keychains scope is owner and Server Admin only. Have a try.

0/9000

Databases can store datetime in local time or UTC - the designer of the database makes that decision. 

 

Our microsoft sql database stores datetime in UTC. The users want to see datetime in local time. How do i tell tableau that this particular sql server stores datetime in UTC? 

 

Tableau server 2025.3.3 

 

#Tableau Server

3 个回答
0/9000

How can we repair one index data entry in the database? 

We get "An unexpected error occured" trying to delete a user or even saving workbooks. the log analytics via CoPilot leads us to an corrupted index entry.

 Is there any way to fix this issue directly without restore the whole database?

#Tableau Server

2 个回答
  1. 昨天,21:39

    This looks like a tricky database issue, especially since it’s affecting both user deletion and workbook saves. I’d also be interested in knowing if there’s a way to repair just the corrupted index entry without restoring the entire database. Hopefully someone has dealt with this before. 

0/9000

Hi everyone. 

I don't know why the CPU usage of Hyper Database Engine goes up so much.

Hyper Database Engine uses 100% CPU in my tableau server now...

Surprisingly, there is no data extraction or view access on the server.

What's the problem..? And when to use Hyper Database Engine except for extract data and view access?

​

7 个回答
  1. 2022年12月9日 09:48

    Hello,

     

    Hyper is built to always use all the available CPU resources to speed things up as much as possible. So the usage of 100% isn't surprising. I am not sure what Tableau Server is doing with Hyper at this point, though. I added the "Tableau Server" tag to your question. Maybe someone else knows better what is happening in the background here.

0/9000

Creating a new workbook with a datasource with connection to MS SQL using the Tableau server GUI works fine but when clicking the "Data Source" tab the page initially loads ok but then there is a delay followed by "Unexpected Error" 

 

The error message is: 

Session ID: 71705F88A636490B90F1B1EF0D85F7C4-1:1 

Uncaught Error: Minified React error #185; visit

https://reactjs.org/docs/error-decoder.html?invariant=185

for the full message or use the non-minified dev environment for full errors and additional helpful warnings. 

 

The additional information when following the link is: 

Upon opening the above URL, here is the message ---

"Maximum update depth exceeded. This can happen when a component repeatedly calls setState inside componentWillUpdate or componentDidUpdate. React limits the number of nested updates to prevent infinite loops." 

 

I have restarted the browser, restarted tableau server, and started from scratch with a new workbook and datasource. 

 

We have many workbooks and datasources connecting to this sql server and they worked fine yesterday. 

 

All datasources to this MS SQL server are affected. 

 

 

 

Tableau Server Version: 2025.3.3 (20253.26.0206.0336) 64-bit Windows 

 

#Tableau Server

4 个回答
  1. 9月4日 13:10

    This error was caused by login failure on AD by the Tableau service account. 

     

    Another problem that was caused was failure of Tableau to start up and then fail to either start or stop. 

     

    Both were resolved by correcting the account and rebooting the server 

     

    -Arvid

0/9000

Hi Tableau Community,

I am looking for best practice guidance on configuring authentication between Tableau Server and an Oracle Database in an enterprise environment while strictly enforcing individual user permissions.

Current Environment & Workflow:

  1. Current State: We currently use static database usernames/passwords for connection, but we want to migrate away from static credentials entirely.
  2. Desktop Client: In Toad/Tableau Desktop, developers connect to Oracle via Integrated Authentication / Kerberos (AD Tickets). They run a local script to generate an Active Directory ticket and connect seamlessly without entering database passwords.
  3. Tableau Server: Tableau Server is currently running under a default setup.

The Challenge:

If we use a single generic account (like the Server Run As account) to connect to Oracle, every developer and end-user on Tableau Server gains access to all tables through that single identity.

We do not want a shared service account with broad access. We need each user/developer on Tableau Server to access only the specific Oracle tables they are individually authorized to see in Active Directory / Oracle.

What We Want to Achieve:

  • Pass-Through Authentication: Migrate from static database credentials to a ticket-based AD/Kerberos mechanism on Tableau Server.
  • No Database Passwords: Avoid sharing or embedding static database passwords in workbooks or Server connections.
  • User-Level Authorization: Ensure that when a workbook is viewed or published, the connection to Oracle honors the logged-in user's individual AD/Kerberos permissions (Viewer Credentials).

Questions:

  1. Is Kerberos Constrained Delegation between Tableau Server and Oracle the recommended architecture to pass the logged-in user's AD identity directly to Oracle?
  2. If Kerberos Delegation is configured, how are Extract Refreshes handled for user-specific data sources without static service passwords?
  3. Are there alternative patterns (e.g., Oracle Proxy Authentication or Published Data Sources with RLS) to enforce table-level Oracle security while keeping the experience passwordless for users?

Any guidance, architectural best practices, or official configuration references would be greatly appreciated!

Thanks in advance. 

 

#Tableau Server

1 个回答
  1. 9月29日 15:20

    Hi @Mahmut Onat

     

    about your questions: 

    1) I would rather say it is your only option 

    2) Kerberos is an interactive authentication type. It cannot handle Extracts back-end refreshes. For extracts use-case, you must keep username / pass authentication. 

    3) You can use published datasource RLS, but then you use Tableau features so the "logic" is on Tableau side, supported by an entitlement table on Oracle side.

0/9000

My Tableau workbook is on a server embedded in our company website. On the website, one of my dashboard tabs shows as Automatic fit to the screen size. The other two dashboard tabs have a fixed desktop size. All three have a fixed size on the desktop file and on the server file. Why is it not a fixed size on the website? 

 

#Tableau Desktop & Web Authoring  #Tableau Server  #Size Requirements  #Trailhead

2 个回答
  1. 9月28日 23:24

     I’ve had a similar issue with embedded Tableau views. It seems like the website can handle the sizing differently from Desktop and Server. I’d check the embed settings and container CSS first, as they may be overriding the fixed size. 

0/9000

We do not have Admin access to our Tableau Server, but we have access to PostgreSQL DB workgroup schema. 

We have a need to monitor LDAP groups, users and Site Limits. 

We have created custom data model for the data (screenshot attached), but results do not match with details presented on Tableau Server (supporting group with Admin access is sharing latest Site Limits numbers) and some of the users do not have names displayed. 

Please let me know if our model is using proper objects. 

Is there any documentation for the workgroup schema tables how to connect them? 

 

We start with users: 

- id 

- site_id 

- site_role_id 

joined group_users via

users.id

= group_users.user_id for: 

- group_id 

joined groups via group_users.group_id =

groups.id

for: 

- name (group name) 

joined hist_users via

users.id

= hist_users.user_id for: 

- name (user name) 

joined site_roles via users.site_role_id = site_roles.id for: 

- display_name (site role name) 

joined sites via users.site_id =

sites.id

for:  

- name (site name) 

 

Viz 1 

Rows 

site_role_id, display_name, countdistinct (user_id) 

we have number of users for each site role. We can add here role_name, we can add user_name, but there are NULL values for user_name from hist_users.  Why there are NULL for user_name? Are they past users? Never logged in? 

 

Viz 2 

We would like to find number of Site Limits for each license type. 

In sites table there are three columns named 'Tier Basic User Capacity', 'Tier Author Capacity', 'Tier Interactor Capacity'. Are them the ones to preset set Site Limits? If no, where can I found proper numbers? 

 

#Repository  #Tableau Server

3 个回答
0/9000

Getting this error when trying to access Site Status reports in Tableau Server On-Prem. 

 

ERROR: unrecognized configuration parameter "tableau.site_id" 

 

#Tableau Server

2 个回答
  1. 9月28日 20:57

    I’ve seen this error before with Tableau Server configuration parameters. It would be worth checking the exact Tableau Server version first, since some parameters can vary between releases. Also, checking whether tableau.site_id is actually supported in that version may help narrow it down. 

0/9000

Hello all, 

I have (Recently upgraded the servers to version 2026.2.1) Linux server and using tnsnames.ors files for Oracle DB connections. Also has the 'ojdbc11.jar' driver file placed at /opt/tableau/tableau_driver/jdbc location.  

 

(Note: Other data extracts or refreshes works normally. only issue with this recently created flow which outputs multiple files) 

 

I see one of the prep flows on the server is failing with ERROR: "

Output step error message: [FailedToConnectExternalResourceError] - Unable to connect to DataSource_Name on DataSource_Name. Check that the data source is available, or edit the connection and enter your credentials again

" 

 

When I check connection from the panel 'Test Connection' works and shows successful, but at the runtime this flow fails.  

 

I have tnsfiles.ora with proper DB connection names and have placed the 'oracle.properties' file with the string 'oracle.net.tns_admin=/etc' within at locations: 

1. /var/opt/tableau/tableau_server/data/tabsvc/flowminerva/Datasources/oracle.properties 

2./var/opt/tableau/tableau_server/data/tabsvc/minerva/Datasources/oracle.properties 

3./var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources/oracle.properties  

 

also, just now added the file at - 

4. /var/opt/tableau/tableau_server/data/tabsvc/flowprocessor/Datasources/oracle.properties

 

Any idea what can I check for?  

 

Thank you! 

 

#Tableau Server  #Flow  #Tableau

0/9000