1 Reply Latest reply on Sep 13, 2013 1:33 PM by Robert Morton

    Permanent database connections on EMC Greenplum

    Artemis Systems

      After migrating from Tableau 7.0.14 to Tableau 8 we have found an issue with EMC Greenplum data source. Connections to GP database takes lot of time to close and stay on idle state for minutes or even hours although the query has run and report has been already shown properly. Connections duration seems completely random. In different data sources types as mysql we aren't experienced the same problem so we think is a problem with EMC Greenplum datasources only.

       

      Any suggestions?

       

      Thanks for your help in advance.

        • 1. Re: Permanent database connections on EMC Greenplum
          Robert Morton

          Hi,

           

          Each database and driver has its own policies for how long to retain a connection before disconnecting with a timeout. This is not strictly controlled by Tableau. What you are noticing in version 8.0 is that we are doing a better job of retaining a connection for a longer period when it may serve as an advantage for quickly responding to followup queries, which can happen when a user begins interacting with a report after a long period of inactivity. However Tableau is still subject to the driver / database timeout policy, which forces Tableau to reconnect upon discovering that the connection is no longer usable. If you wish to alter this behavior, consider working with your Greenplum DBA, or if this is a limitation of the Greenplum system then I suggest you work with EMC to report this as a defect or perhaps a feature request.

           

          In the meantime, if you have further evidence that this is a problem specific to Tableau then please contact our excellent Support team (support@tableausoftware.com) so they may work with you to collect log files, determine the database server settings, etc.

           

          I hope this helps,

          Robert