Error Loading data into ElasticSearch using Azure Data Factory - Zappysys connector

Elastic Stack Elasticsearch
1

I was trying to load data from azure postgresql to elasticsearch through ADF copy activity using Zappysys connector.

Facing this issue.

Failure happened on 'Sink' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY＀㌀擿] Syntax error Ln 0, Col 68: Syntax error, expected: string, number, NULL, )
in: INSERT INTO "DATA"."Test" (name) VALUES (?),Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [HY＀㌀擿] Syntax error Ln 0, Col 68: Syntax error, expected: string, number, NULL, )
in: INSERT INTO "DATA"."Test" (name) VALUES (?),Source=ZappySys API Driver,'

Appreciate help to get through this.

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.