3 Replies Latest reply on Apr 26, 2017 7:03 AM by Jeff Strauss

    tabcmd error full refresh on the extract

    Chadd Dumagas

      Hi again Everyone,

       

      I have a Microsoft Access file stored in a network drive which is the original source of the datasource uploaded in tableau server.

       

      A. Using the tableau refreshextract (preinstalled with tableau desktop - working)

      C:\Program Files\Tableau\Tableau 10.0\bin>tableau refreshextract --source-userna

      me "***" --source-password "***" --original-file "\\***\shares\

      CustomerSupport\Knowledge Management\Content Architecture\Tableau\RMG\datasource

      \progsched.accdb" --force-full-refresh --server "http://***" --site "CS" --data

      source "progsched" --project "CS Knowledge Management" --username "***" --p

      assword "***"

      Data source refresh completed.

      276405 rows uploaded.

       

      B. Using tabcommand refreshextracts (downloaded separately - working)

      C:\Program Files\Tableau\Tableau Server\10.0\extras\Command Line Utility>tabcmd

      refreshextracts --datasource "progsched" --project "CS Knowledge Management"

      ===== Continuing previous session

      =====     Server:   http://***

      =====     Username: ***

      =====     Site:     CS

      ===== Scheduling extracts for datasource 'CS Knowledge Management/progsched' to

      be refreshed now...

      ===== Succeeded

       

      C. Using tabcommand refreshextracts (downloaded separately - added the parameter --synchronous - not working)

      C:\Program Files\Tableau\Tableau Server\10.0\extras\Command Line Utility>tabcmd

      refreshextracts --synchronous --datasource "progsched" --project "CS Knowledge M

      anagement"

      ===== Continuing previous session

      =====     Server:   http://***

      =====     Username: ***

      =====     Site:     CS

      ===== Scheduling extracts for datasource 'CS Knowledge Management/progsched' to

      be refreshed now...

      ===== com.tableausoftware.nativeapi.dll.DataSourceException: The drivers necessa

      ry to connect to the database server '' are not properly installed on Tableau Se

      rver.  Visit http://www.tableau.com/drivers to download driver setup files.

      Database error 0x80040154: Class not registered

      Unable to connect to the Microsoft Access database "\\esl-asia\shares\CustomerSu

      pport\Knowledge Management\Content Architecture\Tableau\RMG\datasource\progsched

      .accdb". Check that the path is correct and that you have access privileges for

      the requested file.

       

      Observation/Results

      A. allows access by specifying source username and password plus server username and password

      A. successfull full refresh from the original datasouce, changes have reflected

      B. allows access by specifying server username and password only

      B. not a full refresh, it would just refresh the uploaded datasource in the server but wont pick up the changes in the original datasource (totally annoying, tested many times, waited for hours)

      B. same function when you click that refresh button above the published view

      C. allows access by specifying server username and password only

      C. full refresh but causing an error, it says don't have access to the path...

       

      By using the above scripts i have concluded that the tabcmd is not using my credentials to open the path of the original ms access file.

      I am able to indicate the --source-username when using tableau refreshextracts but not in tabcmd, there is no such parameter! WTH.

       

      Now, how do you give access to tableau server on a specific file or path?

      I really need help here........ it has been days bumping into tons of trials and errors.....       -,-