Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,538 questions
[Microsoft][Salesforce] (23) Error in Http Request: Server returned nothing (no headers, no data)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 48%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sreelakshmi N S
31
Reputation points
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,'
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,376 Reputation points Microsoft Employee2022-11-16T23:25:05.927+00:00 Hello @Sreelakshmi N S ,
Thanks for the question and using MS Q&A platform.
WIth all the little information which we have , did you checked if the production envirtoment has any data? The reason I am calling this out is because as the error very clearly calls that out .
"no headers, no data"
We will wait to hear from you . .
Thanks
Himanshu -
Sreelakshmi N S 31 Reputation points
2022-11-22T11:37:19.23+00:00 Hi @HimanshuSinha-msft ,
Yes data is available in salesforce service cloud prod and same query is running fine also in prod.
is this error related to ADF connector? -
HimanshuSinha-msft 19,376 Reputation points Microsoft Employee
2022-11-30T22:25:04.873+00:00 Hello @Sreelakshmi N S ,
Thanks for the patience , unfortunately we are not getting the kind of response from the team here . if you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Subscription ID:
Subject : Attn Himanshu
Please let me know once you have done the same.
Thanks
Himanshu
Sign in to comment