1 Reply Latest reply on Mar 24, 2017 10:17 AM by Cheryl Grinds

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

    Vijay Anishetty

      Hi,

       

      We have been experiencing an issue with one of our tableau worker since this morning. Any extracts sent to that node are failing with the below error.

       

      Backgrounder Error:

       

      com.tableausoftware.nativeapi.dll.DataSourceException: Tableau Data Engine Error: 80001: An error has occurred in IPC_Socket::Recv(len=16): An existing connection was forcibly closed by the remote host

       

      Did anyone experienced similar issue in the past?

       

      we did tried restarting the services multiple times, hard rebooting the worker. but nothing helped.

       

        • 1. Re: Tableau Data Engine Error: 80001: An error has occurred in IPC_Socket::Recv(len=16): An existing connection was forcibly closed by the remote host
          Cheryl Grinds

          Hi Vijay,

           

          I did a little research and it sounds like this error typically occurs when the using an incompatible IP address. Specifically, Tableau Server is not compatible with link.local addresses, temporary IPv6 addresses, or APIPA. This is because certain Tableau Server processes such as publishing or refreshing data sources are reliant on the IP address of Tableau Server and link.local addresses do not support the type of communication required.

           

          The best way to assure a reliable IP for Tableau Server is to have either a static IP or a static lease with temporary IPv6 (or APIPA) disabled. If the Tableau Server IP does change, if the new address is not a link.local address then Tableau Server can be reconfigured with the new address using tabadmin config and a restart: Update Configuration for a New IP Address .

           

          The behavior can also be intermittent or inconsistent if Tableau Server has a dual-NIC and only one NIC has a link.local IP address

           

          Below are some options that may help resolve the error for you:

           

                 1.  Configure Tableau Server to use a static IP address.

           

                2.   Disable temporary IPv6 on all nodes where temporary IPv6 is enabled. Note, this setting may need to be reapplied every time the server computer hosting Tableau Server is restarted. To identify where temporary IPv6 is enabled and how to disable, please refer to the following Knowledge Base article:  Identifying and Disabling Temporary IPv6 Addresses | Tableau Software

           

                3.   If Tableau Server is actually using an IPv4 address, consider disabling IPv6 completely on all nodes. This change will be persistent through computer restarts. To disable IPv6, open the Control Panel, Network and Internet, Network and Sharing Center, Local Area Connection, Properties, and uncheck IPv6. Please run tabadmin config to assure that IP changes take effect (see Identifying and Disabling Temporary IPv6 Addresses | Tableau Software for an example).
                *For an alternative process for disabling IPv6 involving registry commands: How to disable IPv6 or its components in Windows

           

               4.   In an environment using IPv4, the link.local address is known as an APIPA. Disabling APIPA requires editing Windows Registry keys:   https://support.microsoft.com/en-us/kb/220874

           

          If none of these options work for you, I recommend opening a case with Tableau Technical Support

           

          Best,

           

          Cheryl