KNOWLEDGE BASE

"ERROR: invalid input syntax for type" when refreshing PostgreSQL extract


Published: 12 Aug 2016
Last Modified Date: 02 Aug 2017

Issue

When refreshing a PostgreSQL extract, the following error is encountered: ERROR: invalid input syntax for type double precision: "N/A". Error fetching next row

Environment

  • Tableau Desktop
  • PostgreSQL

Resolution

Check if any fields in the data source contain the value "N/A" and replace them with NULL 

 

Cause

Invalid values in the data source. 

Additional Information

This issue may occur with other invalid values besides "N/A".
Did this article resolve the issue?