4 Replies Latest reply on Mar 9, 2018 1:36 PM by Patrick A Van Der Hyde

    Looking for log file from tableau refreshextract

    Tom White

      I'm using tableau refreshextract and task scheduler to automate refreshes of extracts on Tableau Online. I'd like to be able to monitor if a refresh succeeded or not and e-mail a log if the refresh fails. But, I can't figure out where the log files are ? Does anyone know ? I've tried redirecting the output to a file I specify, but all I get are blank files.

        • 1. Re: Looking for log file from tableau refreshextract
          Akhilesh Singh

          Hello Tom,

           

          Refer the below url that's having all folder names for all the activities. You will have your folder C:\ProgramData\Tableau\Tableau Server\data\tabsvc\logs\backgrounder.

           

          Server Log File Locations

           

          I hope this could help you.

           

          AK

          • 2. Re: Looking for log file from tableau refreshextract
            Matthias Goossens

            Hey Tom,

             

            Your backgrounder is responsible for refreshing your extracts.

            The log files of the backgrounder can be found here:

             

            C:\ProgramData\Tableau\Tableau Server\data\tabsvc\logs\backgrounder

             

            Cheers,

            Matthias

            • 3. Re: Looking for log file from tableau refreshextract
              Tom White

              Thanks, but I'm using Tableau Online, not Server, so the extracts are being created on a machine with Desktop and then are pushed to Online. So, that directory doesn't exist on my box.

              • 4. Re: Looking for log file from tableau refreshextract
                Patrick A Van Der Hyde

                Hello Tom - this is from last year but I just saw it.  This is how we create logs with success/failure and send out each day for some of our visualizations using tableu -refreshextract

                 

                 

                cd "C:\Program Files\Tableau\Tableau 10.4\bin"
                
                SET logFile="C:\CommRefresh.log"
                
                @echo. > %logFile%
                
                @echo ------------------------ >> %logFile%
                @echo %date% - %time% - Tableau Datasource Refresh >> %logFile%
                @echo ------------------------ >> %logFile%
                @echo. >> %logFile%
                
                @echo Refreshing datasource "DATASOurce1" >> %logFile%
                tableau refreshextract --datasource "DATASOurce1" --site "OurSite" -c CommRefreshConfig.txt >> %logFile%
                @echo. >> %logFile%
                
                @echo Refreshing datasource "Datasource2" >> %logFile%
                tableau refreshextract --datasource "Datasource2" --site "OurSite" -c CommRefreshConfig.txt >> %logFile%
                @echo. >> %logFile%
                
                @echo Refreshing datasource "Datasource3" >> %logFile%
                tableau refreshextract --datasource "Datasource3" --site "OurSite" -c CommRefreshConfig.txt >> %logFile%
                @echo. >> %logFile%
                
                @echo Done >> %logFile%
                c:\mailsend -f emailfront@domainexample.com -d domainexample.com -smtp smtpserveraddress -t emailfront@domainexample.com +cc +bc -sub "Datasource Refresh Log" -m "C:\CommRefresh.log,text/plain,i"
                

                 

                 

                The config file contains: 

                username=username

                password=password

                server=https://server.url.com

                site="MySiteName"

                project=projectname

                source-username=database username

                source-password="database password"

                 

                 

                I hope that helps. 

                 

                Patrick