Loading

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

Дата публикации: Apr 13, 2024
Описание
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. 
Решение
Check if any fields in the data source contain the value "N/A" and replace them with NULL 

 
Дополнительные ресурсы
This issue may occur with other invalid values besides "N/A".

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

Номер статьи базы знаний

001472964

 
Загрузка
Salesforce Help | Article