1 Reply Latest reply on Oct 25, 2018 3:42 AM by Ciara Brennan

    Extract tuning

    ROHIT CHATURVEDO

      Hi,

       

      I have created an extract for 12 months data. Because of I am using item level information, extract size is around 7 GB and fetching around 112 millions records.It is taking 180+ mins to refresh.

       

      We don't want to use incremental extract because our data can change for last one or two months.

      So is there a way to refresh extract only for latest 2 or 3 months not for entire 12 months in full extract?

       

      Thanks

        • 1. Re: Extract tuning
          Ciara Brennan

          Hi Rohit

          I wonder if increasing the value for the backgrounder.querylimit parameter would help here...?

           

          https://kb.tableau.com/articles/Issue/error-extract-timeout-7200-seconds

           

          Resolution

          Increase the value for the backgrounder.querylimit parameter.

          1. Open a Command Prompt, and change directories to the Tableau Server\bin directory.For example: cd "C:\Program Files\Tableau\Tableau Server\<version>\bin"
          2. Run the following command to stop Tableau Server:tabadmin stop
          3. Run the following additional commands to increase the querylimit parameter, configure Tableau Server with the new setting, and restart Tableau Server with the new configuration:
            • tabadmin set backgrounder.querylimit 9000
            • tabadmin configure
            • tabadmin start
          4. Log in to Tableau Server and attempt to refresh the extract using the Refresh Now option.If the refresh fails with the same error after the 9000 seconds (or 2.5 hours), repeat these steps, setting the querylimit parameter value to 10800.

          Cause

          The query exceeded the timeout variable set for extract refreshes.