3 Replies Latest reply on Nov 27, 2012 9:42 PM by ravi.vankayala

    Database error 0x800004005: ERROR:invalid input syntax for double precision: "";

    Nathan Schofield

      I had this error when trying to refresh a data extract from PostgreSQL DB. I found this thread:

       

      community.tableausoftware.com/thread/114859

       

      I then found one variable in my workbook which I had changed from its default format of string to numeric. I changed this back and then the extract worked.

       

      Is this a bug? Is there anything I can do to not have to manually change the datatype back and forth every time I refresh?


      Regards,

       

      Nathan Schofield