2 Replies Latest reply on Jul 20, 2015 10:19 PM by Rho Ackerman

    Tableau server 9 extract error

    Rho Ackerman

      When I refresh an extract (SQL server 2008) from tableau server 9, I get the following error:

       

      2015-07-16 08:42:22.316 +0200 (,,,) backgroundJobRunnerScheduler-1 : ERROR com.tableausoftware.backgrounder.runner.BackgroundJobRunner - Error executing backgroundjob: :refresh_extracts

      java.util.concurrent.ExecutionException: com.tableausoftware.nativeapi.dll.DataSourceException: [Microsoft][SQL Server Native Client 10.0][SQL Server]Error converting data type varchar to float.

       

      Some context:

      • We are upgrading from Tableau server 7 to Tableau server 9
      • The same workbook refreshes on Tableau server 7
      • The same workbook refreshes on Tableau desktop 9
      • Other workbooks on the Tableau server 9 (which connects to the same database) refreshes

       

      I suspect it has something to do with the machine settings where Tableau server 9 is installed.  Has anyone come across a similar problem?