linked service connection issue

Question

Hello,
My linkedservice connects to adlsgen2 using AccountKey for which I have placed the URL which points to the storage and the storage account key which is the string I got from the portal.azure.com for this storage...
When I run the ADF pipeline using the debug botton, all is fine but when I click on trigger now, the error is:
Operation on target my activityName failed: The specified account key is invalid. Check your ADF configuration.
Any suggestions?
Thank you

Answer 1

Hello @arkiboys ,

Thanks for the question and using MS Q&A platform.

As per my understanding you have used an account key for your ADLS Gen2 linked service connection from ADF and when you do the test connection it works fine but when you do trigger now then it fails with above error.

Could you please confirm if you have published your pipeline and the linked service that you have created? If not, please publish your pipeline and linkeservice changes and then try re-testing it and see if it works.

The reason is when you do a debug run it will run on the local version of your pipeline/linked service, but when you trigger now, you pipeline will run on the code that is last published to ADF service.
This kind of issue occurs(debug runs but trigger run fails) when there is a mismatch between the local version of your ADF code and already published version.

Please try to publish all your changes and try to trigger now and see how it goes.

Thank you

Answer 2

I think if you use ADLS Gen 2 as a storage and you want to store the keys in the KeyVault, Instead of giving connection string like we do using azure blob storage, you should give only key value from the ADLS.