[Microsoft][Salesforce] (23) Error in Http Request: Server returned nothing (no headers, no data)

Sreelakshmi N S 31 Reputation points
2022-11-16T03:30:37.747+00:00

I am trying to extract data from salesforce sales cloud to ADLS using ADF and it failed with below Error and this happened in prod and in dev the extraction was successful with same configuration.

Query used to extract is : selct col_list's from table where systemmodtimestamp >= '2013-01-01T00:00:00Z'

Details
Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][Salesforce] (23) Error in Http Request: Server returned nothing (no headers, no data),Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][Salesforce] (23) Error in Http Request: Server returned nothing (no headers, no data),Source=Microsoft Salesforce ODBC Driver,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,182 questions
{count} votes