Issue#74: Tableau - Tableau Data Engine Error: 8 with all published views on server 9.1.1

  • Recently we encountered issue with below error for all views. This impacted all business users in QA instance. We were not able to figure out what was the root cause. We have open case with Tableau as well. Even though, we were able to resolve issue but still would like to hear from anyone who had similar issue and know the root cause so that we can avoid going forward.

     

    "An unexpected error occurred. If you
    continue to receive this error please contact your Tableau Server
    Administrator.

    DataSourceException: Tableau Data Engine Error: 8: An error has occurred in
    IPC_Socket::Recv(buffer length=16) An existing connection was forcibly closed
    by the remote host

    2016-01-20 00:25:41.372 (Vp7UBawQOk0AAAho0GQAAAJO,1,1)

    Would you like to reset the view?'

     

    Resolution: On two node architecture

     

    1. Stop Services

    2. Move all services from Worker Node to Primary Node except Data Engine; File Store; Repository

    3. Save and start services; After start check if all views are working as expected, in our case we did not encountered the above said issue.

    4. Stop services again

    5. Move all services from Primary Node to Worker Node except File Store; Gateway; Search and Browse and save

    6. Start services and things should be back as before without issue.

     

     

    Thanks,

    Deepak Sinha

    Brocade

     

     

    0 Answers

    Sorry, your answer is too short !

  • Issue#429675: Tableau - Error when creating extract file - Tableau Data Engine Error: 48041: Invalid Command: data

    Hi there, When I was trying to create an extract file, I got this error message: Tableau Data Engine Error: 48041: Invalid Command: database: Path does not exist.  How can I fix this issue? what is the root cause? Thank you, Jason

  • Issue#491897: Tableau - Anyone Encountered Tableau Data Engine Error: 49037?

    I have been receiving this error recently on my workbooks recently.From my experience, it occurs irregularly whenever i am working on my chars. A quick re-open of my workbook would solve this issue.However if i were to save/export my workbook as a packaged workbook (*.twbx) and open it , it would prompt this error again. Re-opening the aforementioned packaged workbook doesn't seems to help at all. It also happens for separate workbooks using different data set. Anyone have this issue? Any advice on how to resolve this, and what is the root cause of the error? I am on Tableau 9.3.

  • Issue#748727: Tableau - Tableau Data Engine Error: 40280: invalid range

    Hi,Anyone seen this EXACT error and know what to do about it?  As background, I was trying to open a .twbx I had built earlier in the day. Thanks in advance,Jon

  • Issue#749749: Tableau - Tableau Data Engine Error: utf8 to utf16

    Hi, I've been using Alteryx to create a Tableau extract (tde) but when I try to use certain dimensions in Tableau I get the following error: Tableau Data Engine Error: 40583: error measuring utf8 to utf16 Is there something I would probably have to change in Alteryx or can something be done in Tableau to overcome the problem? Thanks!

  • Issue#888126: Tableau - Editing a Published Data Source not working after updating to Tableau Server 9.3 and Deskt

    I am trying to edit a Published Data source by following the steps outlined in Editing a Published Data Source | Tableau Software. I have successfully followed the same steps with all previous versions. Did something change? These are the steps I am taking: Connect to the published data source from Tableau Desktop.Create a local copy of the data source by selecting Data > <data source> > Create Local Copy.Save the local copy of the data source.Replace the published data source in the workbook with the newly created local data source by selecting Data > Replace Data Source.Right-click the published data source and then select Close to close the published data source.Make the desired changes to the local copy of the data source.Select Data > <data source > Publish to Server to overwrite the original published data source on Tableau Server.Select Data > Connect to Data to connect to the newly published data source.Select Data > Replace Data Source to rep

  • Issue#1006852: Tableau - Tableau Server Data Engine stopping...causes?

    What would cause a Data Engine process to stop?Example from my ...\logs\tabadmin.log (line 9):2016-07-29 16:39:48.603 -0700_DEBUG_##.#.#.#:myServer_:_pid=15484_0x1debc91c__user=__request=__ ====>> <script> 9.3 (build: 9300.16.0708.1543): Starting at 2016-07-29 16:39:48.572 -0700 <<==== 2016-07-29 16:39:50.850 -0700_DEBUG_##.#.#.#:myServer_:_pid=15484_0x1debc91c__user=__request=__ Configuring Java logging, to file D:/Application/Tableau/Tableau_Server/logs/tabsvc-tabadmin-java.log. 2016-07-29 16:39:50.350 -0700_DEBUG_##.#.#.#:myServer_:_pid=15484_0x1debc91c__user=__request=__ run as: <script> status --verbose 2016-07-29 16:39:50.834 -0700_EXACT_##.#.#.#:myServer_:_pid=15484_0x1debc91c__user=__request=__ Status: DEGRADED 'Tableau Server Coordination Service 0' (6396) is running. 'Tableau Server Search and Browse 0' (22632) is running. 'Tableau Server Tabadmin Service 0' (12212) is running. 'Tableau Server Search Service' (18900) is running. 'Tableau Server Data En

  • Issue#1162651: Tableau - Tableau 10, group dimensions and extracts = Tableau Data Engine Error: 40401: Scan::Next:

    Evening all,  I recently upgraded to T10 and seem to be having the same issue identified here in T9.3. Error "Tableau Data Engine Error: 40401: Scan::Next: Mismatched row counts" Opening Workbook Connected to Data Extract |…  I have created a grouped dimension from an existing dimension to group like items for a particular dashboard and all works fine when I use a live connection but as soon as I create an extract (to publish a TWBX) any time I try and use a dimension from the extract I get this "Tableau Data Engine Error: 40401: Scan::Next: Mismatched row counts: Table has 49431 rows: Column: [OD - Act (group)] has 44994 rows". Can anyone advise if they too have this issue as it is a real pain to have to keep moving data in and out of groups to produce an TWBX.  If anyone has any advise I would really appreciate the input. Kind regardsPhil

  • Issue#1187217: Tableau - I am getting Tableau Data Engine Error. How to solve this??

    I am getting Tableau Data Engine Error. How to solve this??

  • Issue#36: Tableau - Has any one seen this error retrieving records from SQL Server

    There is about 50000 record in this table I am trying to get information from... If I narrow down the range it fine... but if I request all of it I get this error... Thanks.  CARLOS TRIVINO | Director, Information Technology905-875-0708 ext.332   Fax: 905-875-55191-375 Wheelabrator Way, Milton, ON, L9T3C1 "This email and any attachments may be confidential or legally privileged. If you received this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail.  

  • Issue#10493: Tableau - After publishing tableau server data source, the alias is no longer available and doesn't

    This seems to be a bizarre issue I encountered today after publishing a data source to Tableau Server. While on my desktop I had an alias on a measure name. After publishing to Tableau Server, this alias disappeared (as expected). However, now I'm attempting to create a new measure with the same name as my alias, and it doesn't let me "A field named "X" already exists."   However there seems to be no way for me to access the previous alias in order to delete it. Anyone know how to workaround this issue?

  • Issue#42243: Tableau - SQL server authentication error on tableau server

    Hi folks, I need a small help regarding tableau server connection to a SQL Server database. In short, I've developed a tableau workbook with live connection to a SQL database and published to our tableau server. But when I login to tableau server and try to browse the report, I get the below error. It doesn't let me in even when I enter the login credentials. FYI...I'm using windows authentication for connecting to SQL Server authentication and the user id through which I've logged into tableau server has access to the database. I've also configured my tableau server to use Active directory, however I've not created a service account yet (it's using NT AUTHORITY\NetworkService which is a dummy one). Let me know if I'm missing anything pls?  Thanks in advance!

  • Issue#60590: Tableau - Table name changed after extracting data - Error - Invalid table name valueT

    Hello! I'm getting below error as the name of a table I'm using in custom SQL has changed (after I extracted data into the workbook). I'm using Tableau Desktop 9.2. When I click on Data Source, I get prompted to enter connection details (Cloudera Hadoop). When I hit OK, then I get above message. However, the screen where I set up custom SQL is not coming up. How do I modify my sql to reflect new table name and resolve above error? Thanks for your attention! Ravi.

  • Issue#62909: Tableau - Data Connections - SQL Server

    Hi All, I have an excel source (200MB) loaded as data source with 7 sheets with data extracted using separate queries. In Tableau I have the joins defined where the tables have  separate queries and extracts data into a worksheet. In the other sheets I have the dimensions with the joins defined. Now I have access to SQL server database and want to create and replace the schema. So I have 7 queries and these will extract data from live DB to Tableau and extract data and later schedule on server. Do I need to build separate connections for every query and join them  in Tableau same as like I did in excel ? What is the right approach to take in this scenario. Can I have 7 connections and then blend them inside Tableau ? I have many dashboards built of this data. Please advise.

  • Issue#64098: Tableau - how to move Server 9.1 program data to a different disk / drive / data volume?

    Tableau Server Version: 9.1.0 (9100.15.0903.2142) 64-bit on Windows Server 2012 R2. Everything was installed on drive C, which is 100 GB. I'm pretty sure all install options were default. The disk has filled up. I could attach a much bigger data volume to that instance and format it. But I don't know how to: 1. Identify which are the Tableau data files that need to be moved. Is it C:\ProgramData\Tableau ? 2. Change the settings after the move so that TS uses the data files in the new location. Any help is appreciated. Thank you.

  • Issue#197925: Tableau - How to modify header name after published in server ...

    Hi all,          How to modify the tableau Report after publishing in server. Scenario :        Header fileds : like (TV,Mobile,Bike, Etc...) now i want to change TV to Television.

  • Issue#198296: Tableau - SQL Server impersonation issue

    Hi All, I've a small issue with SQL server impersonation configuration. To give the details, I'm using live connection to a MS SQL Server Database in one of my workbooks (published with impersonate via server run as account) and the tableau service account has db owner permissions to that database. When I grant a user access to that database, his access to the tableau workbook on the server works fine. However when I remove his access to that database on SQL Server, he is still able to access the workboook. Pls let me know if this is a limitation or am I missing some setting anywhere. Kindly help me.  Thank you!Surendra

  • Issue#205292: Tableau - Unknown server error

    Hi guys, I found this error when publishing my dashboard to TBL Server. It is a database with a vertica connection  (it's in Portuguese, but basically it says "Unknown server error. Contact Server Admin". We're clueless about why this is happening. Thanks for any help! Cheers,Pedro  Tableau Server: 9.2.4 (9200.16.0204.1543) 64-bit Tableau Desktop 9.1

  • Issue#242254: Tableau - Tooltip Error on Server

    Hi everyone,I have individually separated bullet chart ,1 for each dimension value . I have all these 5 bar chart in a container. The problem with this is the Tooltip Functionality is working good on Desktop , but fails to change on hover in Tableau Server. It requires to click each individual bar chart for the tooltip to change.Kindly Help. Thank You in Advance,Sanket

  • Issue#256851: Tableau - Issue in setting up AD with tableau server

    We are in the Process of Setting up Tableau Server 9.2 with Active Directory Authentication. We have created a generic AD for that as well. Our AD team is not allowing us to provide Admin Privileges to that AD ID. They are asking for specific rights to be given to that ID. In Tableau documentation, it is not clearly mention regarding list of permission to be given to the id. Can anybody please specify that what all privileges / Access rights / Permission / Group an AD ID should have to configure that AD ID as the Administrator of  Tableau while initial setup of Tableau ?

  • Issue#257856: Tableau - Data blending Zip codes performance issue

    I am looking for the best / most efficient way to blend or join a secondary data source which contains a master zip to territory mapping. Primary data source: (live connection tableau online) each row has a zipSecondary data source: (excel) master zip file with ~40k rows (all US zips) - each zip is tied to a territory I am looking to add the territories from the master zip to territory file as a filter. I tried data blending using the zip codes as a common field but I am facing very slow performance. Is there a better way to do this?

  • Issue#259051: Tableau - Parameter filter not showing when published to Tableau Server

    I have a parameter filter in a dashboard (see screenshot 1) that I've created on Tableau Desktop (version 8.3). When I publish it to Tableau Server (version 8.3), one of my users cannot see the filter (screenshot 2). He is using Chrome in a Mac, I am using Chrome on a PC. Has anyone experienced this before? I've tried removing the filter and re-adding it but nothing changed. Also, everything else on his dashboard is identical to what I see. I'm extracting the data from a server before publishing it to Tableau Server. What I see on Desktop:  What the user sees on Server:     Any help would be greatly appreciated! Derek

  • Issue#272470: Tableau - How to Enable Row-Level Security on a Published Data Source (TDE)

    I recently attended a customer summit where one of the break-out sessions focused on the challenge of adding row-level security to a published data source on Tableau Server.  This is something that we'd been struggling with for a while and something we really needed to figure out prior to going live with our latest project (which would add hundreds of new users to Tableau, users who needed to only see specific slices of the data). Thanks to some help by Tableau Support, we finally got it to work.  Below is a short blog post that describes how we added row-level security to a TDE.  I hope others find this useful.  It's actually much easier than we originally thought. Pixel Mixer: Row-Level Security On A Published Tableau Data Source  -Mike

  • Issue#276716: Tableau - Data Blending Left Join Issue

    Hi All, We are currently developing a customized usage dashboard for our business users. We are blending data using multiple data sources and both data sources are connecting to PostgreSQL databases. In the second data source we are using custom SQL which basically pulls the users who are in Usage and Admin AD groups. All sites contains corresponding Usage and Admin AD groups accordingly. Our aim is to provide the users logged in with their sites usage data. For example, user X is only part of site A and when he logs in he should be viewing only site A's usage statistics and if user Y is part of site B and C, he should be viewing both sites B and C's usage statistics. For the security piece we are capturing user login information using GetUserName() function. But we have a issue here with the Site Name filter. When a user X logs in, he is able to see only his sites corresponding data getting filtered but the site name filter shows all sites within the environment. we want to

  • Issue#365849: Tableau - Help Refresh Data Live In Tableau Server

    Hi everyone,I'm using Tableau Server 9.3. I have a problem with refresh data with Live data connect SQL.My Tableau Server have more site, but i just only setting refresh live data in Configure Tableau Server, Data connection.I want to configure every Site have diffirent Blanced Minutes refresh.How can I do it? 

  • Issue#377118: Tableau - tabcmd - The server is not licensed to connect to 'Tableau Data Extract

    Good day Tableau Community,   I'm new to Tableau 'tabcmd' and I would really appreciate support here.   I have a data source on Tableau Server named "FilterList". The connection type is Text File and it connects to a CSV file as an Extract. This CSV file sits on the same server as the Tableau Server and we used UNC path.   I want to refresh this data source each time the CSV file is updated using 'tabcmd' below:        "C:\Program Files\Tableau\Tableau Server\9.2\bin\tabcmd" refreshextracts --datasource FilterList  --no-certcheck --synchronous   However, I am gated with issue below.     ===== Continuing previous session   =====     Server:   http://111.11.11.11//   =====     Username: RohnJose   ===== Scheduling extracts for datasource 'default/FilterList' to be refreshed now...   ===== com.tableausoftwa

  • Issue#401955: Tableau - Data Blending Issue

    Hi All, I am working with two data sources and I need to blend some data fields from both data souses to create some dash boards. I did data blending but it does not give me correct results what I expect. I have attached a sample workbook by enclosing similar example which I faced. For your convenience, I have attached two screen shots of results what I expected and observed 1. This kind of figure I am expecting to have. In my two data sets one have 5 ICUs(A, B, C, D, E) and 3 for other(A, B, D) . But this figure shows 3 ICUs(A, B, D) which are in data set 1. But I need to show rest ICUs though those do not have data (C and E) 2. When I blend Data I observed this figure. This figure shows rest 2 ICUs(C and E) But failed to show discharge type correctly as in figure 1 when dragging discharge type into color shell Can anyone please kindly help me to getting this problem solved. I have attached my tableau workbook as well. I can work upto tableau version 9.2. 

  • Issue#418105: Tableau - View data option not shown after publishing on Tableau Server

    Hello allOn Tableau Desktop, I can select multiple data point on my graph and have access to “View data Option”; however, I cannot do the same after publish it on Tableau Desktop.Below showing what I see on Tableau Desktop:Below showing what I see on Tableau Server after publishing the workbook (Note that view data is NOT there):  I include Commands bottoms as enabled on the tooltip and I have full permission on Tableau Server (I'm one of the admins) so I should be able to see the data.What else should I look to troubleshoot the issue?Thanks in advance 

  • Issue#432528: Tableau - Analysis Services database error 0x80004005 in Tableau Server

    Hello everyone,I have use Cube Dynamic AX in Tableau desktop 9.3. When I publish dashboard Tableau Server. I have a error, as below picture.The error appear when I update Cube Dynamic AX. I can try Deploy Cube Dynamic AX again but the error still occur.How i can fix error?Thanks for your help.  

  • Issue#432529: Tableau - Analysis Services database error 0x80004005 in Tableau Server

    Hello everyone,I have use Cube Dynamic AX in Tableau desktop 9.3. When I publish dashboard Tableau Server. I have a error, as below picture.The error appear when I update Cube Dynamic AX. I can try Deploy Cube Dynamic AX again but the error still occur.How i can fix error?Thanks for your help.