Loading

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

Publiceringsdatum: Apr 13, 2024
Beskrivning
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. 
Lösning
Check if any fields in the data source contain the value "N/A" and replace them with NULL 

 
Ytterligare resurser
This issue may occur with other invalid values besides "N/A".

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

Knowledge-artikelnummer

001472964

 
Laddar
Salesforce Help | Article