9 Replies Latest reply on Jun 16, 2016 5:20 AM by harris.tsr

    Cannot refresh Data source based on csv or test file

      Hi

      I have just upgraded to V7. created a datasource based on a csv file. When I manually or the schedule refreshes the extract it fails with

      <snip>

      com.tableausoftware.vizql.dll.DataSourceException: Unable to open the text file. Please check that you have specified the correct field delimiter and that you have access privileges for the file. Microsoft JET database error 0x80040E37: The Microsoft Jet database engine could not find the object 'OOSBIS.CSV'.  Make sure the object exists and that you spell its name and the path name correctly. The table "OOSBIS#CSV" does not exist.

      </snip>

       

      Excel base files refresh fine and an excel version of the same file in the same location works fine

       

      The only thing I have noticed is that the attribute for the csv based data source "Database name" does not have a path and file name

      e.g \\ihc-dc-vms18\set\DataSource\oosbis.XLS

       

      where as the xls based one does have a path and filename.

      e.g oosbis.csv

       

      Tried local based files. Files from accessible based shared.  No luck so far

      ?

      Peter