New ADF data source with a Ingest Instance task error: 'Failed to encrypt sub-resource payload'¶
Symptoms¶
When creating a new ADF (Azure Data Factory) SQL data source with an on-prem SQL Server, running Ingest Instance Synchronization or Transfer tasks give the following error:
Failure
Microsoft.Rest.Azure.CloudException: Failed to encrypt sub-resource payload ..
Cause¶
Self-Hosted Integration Runtime is offline.
Resolution¶
Ensure your Self-Hosted Integration Runtime is online (connected to the cloud service) when executing Ingest Instance tasks for an ADF data source that requires it. Self-hosted IR is used to encrypt your payload.
Notes¶
After the data source is successfully configured (Ingest Instance Synchronization or Transfer tasks succeeded), if you then stop the Self-Hosted Integration Runtime, you may get a more descriptive message:
Failure
The Self-hosted Integration Runtime <Name> is offline
Discussed in the community
Looking for related questions…
Didn't find your answer? Ask the community about this page — questions are answered by Timextender experts, partners and other users.