Loading

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

Publiseringsdato: Apr 13, 2024
Beskrivelse
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 

 
Flere ressurser
This issue may occur with other invalid values besides "N/A".

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

Knowledge-artikkelnummer

001472964

 
Laster
Salesforce Help | Article