3 Replies Latest reply on Aug 27, 2018 12:12 PM by RK Raj

    Tableau server back up issue

    Tushar  More

      Hi Experts,


      I am trying to move log files on azure cloud (Blob storage). Here is the command that I am using:

      AzCopy /Source:C\"Program Files"\Tableau\"Tableau Server"\10.3\bin /Dest:https://xxx.blob.xxx.xxx.xxx /DestKey:key /Pattern:"logs.zip" 


      However, I am getting following error.

      Incomplete operation with same command line detected at the journal directory "C
      :\Users\admin\AppData\Local\Microsoft\Azure\AzCopy", do you want to resume
      the operation? Choose Yes to resume, choose No to overwrite the journal to star
      t a new operation. (Yes/No) y
      Unhandled Exception: System.InvalidOperationException: Only one transfer is allowed with stream journal.
        at Microsoft.WindowsAzure.Storage.DataMovement.StreamJournal.AddTransfer(Tran
      sfer transfer)
        at Microsoft.WindowsAzure.Storage.DataMovement.TransferCheckpoint.AddTransfer
      (Transfer transfer)
        at Microsoft.WindowsAzure.Storage.DataMovement.TransferManager.GetOrCreateDirectoryTransfer(TransferLocation sourceLocation, TransferLocation destLocation, TransferMethod transferMethod, TransferContext transferContext)
        at Microsoft.WindowsAzure.Storage.DataMovement.TransferManager.<UploadDirectoryInternalAsync>d__70.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
        at Microsoft.WindowsAzure.Storage.AzCopy.BlobFileTransfer.DoTransfer()
        at Microsoft.WindowsAzure.Storage.AzCopy.AzCopy.ExecuteTransfer()
        at Microsoft.WindowsAzure.Storage.AzCopy.AzCopy.Execute(String[] args)
        at Microsoft.WindowsAzure.Storage.AzCopy.AzCopy.Main(String[] args)


      Does anybody has any idea how to move log files to azure storage? My tableau server is installed in VM.


      Would appreciate your help.



        • 1. Re: Tableau server back up issue
          Glen Robinson

          Hi Tushar

          I dont know much about Azure Copy, but I would look at your syntax

          1: Are the logfiles in the bin folder?

          2: the command should look more like this (then what you have) (ie check your double quotes locations)

          AzCopy /Source:"C:\Program Files\Tableau\Tableau Server\10.3\bin"/Dest:https://xxx.blob.xxx.xxx.xxx /DestKey:key /Pattern:"logs.zip"


          Hope this helps


          1 of 1 people found this helpful
          • 2. Re: Tableau server back up issue
            Tushar  More

            Hi Glen,


            Thank for pointing me to the syntax of the command. I've fixed up that. Actually, I have created a backup script as below and need some help to make it work.


            1. tabadmin ziplogs -l -n -f -p "C:\Program Files\Tableau log\ logs.zip”
            2. tabadmin cleanup
            3. AzCopy /Source:<source_path /Dest:<dest_path>
            4. tabadmin backup backup_Test -d –v
            5. timeout /t 90
            6. if tabadmin status != 'RUNNING' then <code_to_email_an_alert>


            Step 3: tabadmin commands require the bin directory where as Azcopy works with the AzCopy installation directory (%ProgramFiles(x86)%\Microsoft SDKs\Azure\AzCopy).


            Will the script automatically change the path? If not, please tell me what modifications need to be done?


            Step 6: If I replace <code_to_email_an_alert> with tabserveradmin@admin.com, then is this correct?


            Would appreciate your help.



            • 3. Re: Tableau server back up issue
              RK Raj

              Hi All,


              I have backup  schedule which is working fine earlier recently we moved and configured on E:drive( accordingly  modify in  script)

              Script is running as per task schedule  options but not saving backup in path which is (E:\ableaubp\Backup) and not sending reboot emails.(SMTP configured as its before) Please correct below script


              Appreciate your help for review script.



              cd E:\Tableau\Tableau Server\10.4\bin

              tabadmin stop

              tabadmin ziplogs -l -n -f

              move logs.zip E:\ableaubp\Backup


              cd E:\Tableaubp\Backup

              ren logs.zip logs%date:~10,4%-%date:~4,2%-%date:~7,2%.zip


              cd E:\Tableau\Tableau Server\10.4\bin

              tabadmin backup E:\ableaubp\Backup\ts_backup -d -v

              tabadmin cleanup

              tabadmin start

              timeout /t 90