5 Replies Latest reply on Sep 6, 2013 9:11 AM by Joe Cole

    Live data not refreshing in desktop and on tableau server

    Alexander Buyin

      Hi,

      I use live connection to MS SQL server. I created a worksheet based on one table from DB. Then I updated the table in the data base. I changed the values in one column. Tableau report showed outdated values in this column. I tried to refresh data (F5) as recommended in Tableau help to bring changes from the table into effect in the report but it didn't help. I tried to publish the workbook at Tableau server and refresh data at Tableau server but it didn’t help either. The report still shows old values. If I add a calculated filed that is the replica of this column the calculated field shows correct values in the report. Please look at the attached screenshot. activity_category column shows incorrectly “Blacklist” value for 39633 records. activity_category_calculated field is based on activity_category but it shows correct values. Apparently the data is cached and it is not updated when I select Refresh in the menu. What else should I do to refresh the data in the report?

        • 1. Re: Live data not refreshing in desktop and on tableau server
          Tracy Rodgers

          Hi Alexander,

           

          If you closed the workbook and reopened it, you may need to refresh the connection. Click on the Data menu, navigate to the data source and select Edit Connection... then re-navigate to the source to establish a live connection.

           

          Hope this helps!

           

          -Tracy

          • 2. Re: Live data not refreshing in desktop and on tableau server
            Zach Leber

            Tableau Server data caching has some glitches. If you update a table in your DB, say with a new or dropped column, you may not be able to get Tableau Server to see the updates without stopping and restarting Tableau Server. This happens to us occasionally with Oracle, there is no good workaround, we have to wait for our nightly restart of Server for our views to be fixed. We have never seen this problem in Desktop however, so if you are, something else sounds wrong.

            • 3. Re: Live data not refreshing in desktop and on tableau server
              Kyle B

              What setting do you have on this screen?

               

              http://onlinehelp.tableausoftware.com/v7.0/server/en-us/config_cache.htm

               

              We had to set ours to "refresh more often" but I've never encountered a cache holding until the server restarts before.

              • 4. Re: Live data not refreshing in desktop and on tableau server
                Zach Leber

                We currently use "refresh less often" but even with "balanced 120" we've had this problem for years. It's not that we see old data, it's that we see an old structure for the table itself, which means our newly published views won't even load until the next day after the restart flushes the cache. Truly maddening. Sometimes this means we only make table changes at the end of the working day. An option in Server to flush the cache without restarting Server would solve this. We can't restart in the middle of the day without bumping users.

                • 5. Re: Live data not refreshing in desktop and on tableau server
                  Joe Cole

                  We have this problem too.  It would be great if Tableau would add a new "tabadmin dump cache" command that would enable us to dump the Tableau cache on-demand from the command line.  We have regularly scheduled data loads (more frequent than daily) that invalidate the cached query results in Tableau.  Currently, we can only:

                   

                  1) Set our cache settings to "Refresh More Often".  This always returns accurate data, but has a HUGE impact on performance.

                   

                  2) Set our cache settings to "Balanced".  However, whatever value we put for "minutes" is translated as "this is how long we're ok with our users viewing stale data", which doesn't really give us a warm fuzzy feeling.

                   

                  3) Set our cache settings to "Refresh Less Often", and schedule a RESTART OF TABLEAU SERVER just after each regularly scheduled data load.  This is great, except it takes NEARLY 5 MINUTES for our HA Tableau environment to restart, and our users get 500 errors if they attempt to view reports while the restarts are happening.

                   

                  What would be SPECTACULAR is if we could dump the cache from the command line after every data load.  I'm guessing it would take a lot less time to just dump the cache versus restarting the entire tableau infrastructure...