Loading

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

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

Cause

This is an issue/limitaion with the data source used. 
Resolution
Check if any fields in the data source contain the value "N/A" and replace them with NULL 

 
Additional Resources
This issue may occur with other invalid values besides "N/A".

Error "invalid input syntax for type date: ""; Error while executing the query"

Knowledge Article Number

001472964

 
Loading
Salesforce Help | Article