2 Replies Latest reply on Mar 15, 2010 6:48 AM by Chris Gerrard

    Increase the Timeout for Queries

    . clwoodard

      We have a large dataset that takes a bit of time to process. Unfortunately, this is the only way we can do this so redefining the data isn't an option.

       

      When we try to open views relating to this workbook and dataset, we get timeout errors and a message stating that the query timeout of 30 seconds has been reached.

       

      Is there any way to increase this timeout to, say 5 minutes? Generating the reports is not time critical so we're fine with increasing the timeout if it's possible.

       

      I've searched through the tableau directory and looked at config files and such but couldn't find anything of value, at least regarding the 30 second time limit.

       

      Thanks,

      -Curt

        • 1. Re: Increase the Timeout for Queries
          . clwoodard

          Just got a reply from Support. The answer is:

           

          You can increase the vizqlserver query limit using the process below.

           

          1. Open a 'cmd' window on the Tableau Server machine

          2. Navigate to the 'C:\Program Files\Tableau\Tableau Server\5.1\bin' folder

          3. Stop the Tableau Server using the command 'tabadmin stop'

          4. Increase the vizqlserver query limit using the command 'tabadmin set vizqlserver.querylimit 60'

          5. Update the Tableau Server's configuration using this command 'tabadmin configure'

          6. Start the Tableau Server using the command 'tabadmin start'

           

          You should test to see if the view displays. If not, you may have to increase the value again - I would suggest that you do so in 30 second increments until you have success.

           

          Thanks, Support!

           

          Now, where to suggest a new feature...

          • 2. Re: Increase the Timeout for Queries
            Chris Gerrard

            This configuration is described in the Server Admin doc.

            The value at the end of the command 'tabadmin set vizqlserver.querylimit 60' is 'Longest allowable time for updating a view, in seconds'

             

            In 5.1, on p64 of server_admin5.1.pdf

            In 5.0, on p50 of server_admin5.0.pdf

             

            The sequence of actions required to apply the configuration(s) are on the pages immediately following, in both documents.