Runtime error when running lookup in Azure data factory, pipeline

Question

Runtime error when running lookup in Azure data factory, pipeline

Yehia, Asama 5

I am getting the following error when running lookup in pipeline, anyone can help finding out the reason?

ErrorCode=UserErrorInvalidEncryptedCredentialProvided,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The data source credential'2e4ddaa4-b9ed-4ef8-8afb-35339f4e2e17' had been deleted from current Integration Runtime node with payload '' when you delete the link service on Azure Portal, or the task has the wrong payload, please create new link service with your credential again.,Source=diawp,'

Thanks

Asama

Subashri Vasudevan 11,226 Reputation points

2023-03-30T05:25:42.9433333+00:00

What are you trying to lookup? From a table? If so pl check if that table exists and you can query from azure portal.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-04-06T04:34:07.29+00:00

Hi @Yehia, Asama - We received your feedback that the answer provided on the thread was not helpful. Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback. Our engineer has provided a detailed answer which has clear steps for which you are looking for. If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us. Looking forward to you reply. Much appreciate your feedback! Regards, PRADEEPCHEEKATLA-MSFT

1 answer

Your answer

Subashri Vasudevan 11,226 Reputation points

2023-03-30T05:25:42.9433333+00:00

What are you trying to lookup? From a table? If so pl check if that table exists and you can query from azure portal.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-04-06T04:34:07.29+00:00

Hi @Yehia, Asama - We received your feedback that the answer provided on the thread was not helpful. Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback. Our engineer has provided a detailed answer which has clear steps for which you are looking for. If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us. Looking forward to you reply. Much appreciate your feedback! Regards, PRADEEPCHEEKATLA-MSFT

Answer 1

AnnuKumari-MSFT 34,556 Microsoft Employee Moderator

Hi @Yehia, Asama ,

Welcome to Microsoft Q&A and thanks for posting your question here.

As I understand your query, you are experiencing error 'The data source credential had been deleted from current Integration Runtime node with payload' when trying to use lookup activity in ADF pipeline. Please let me know if the understanding is incorrect.

The issue here might be because the linked service underlying in the lookup activity is lacking the correct credentials or the linked service credentials don't have the required access.

Kindly check by clicking on 'test connection' in the linked service pointing to the datastore. If it's failing , Kindly create a new linked service with correct credentials again and use the same in the lookup activity.

If you still face issue, kindly provide more details like which datastore you are trying to connect to and since when are you facing the issue.

Hope it helps. Please consider accepting the answer if it's helpful as accepted answer helps community as well. Thankyou.

Yehia, Asama 5 Reputation points

2023-03-30T13:16:34.0966667+00:00

Linked service is working, from the lookup, when I select preview data, I can see the query results output.
Yehia, Asama 5 Reputation points

2023-03-30T13:18:00.6033333+00:00

Linked service is working fine, from the lookup, when click preview data, the query results shows the output
Yehia, Asama 5 Reputation points

2023-03-30T14:08:11.8733333+00:00

Connection test is successful with linked service
Yehia, Asama 5 Reputation points

2023-03-30T18:56:27.7766667+00:00

To get it to work, I had to create a new linked service, and use it for my Dataset, not sure why the old linked service stopped working for me, my colleague is able to use the old linked service when he runs his pipeline.
AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator

2023-04-05T07:21:23.1333333+00:00

Yehia, Asama , Glad to know that the issue has been resolved by recreating the linked service as suggested in the original answer. Requesting you to kindly accept the answer by clicking on Accept answer button so that it can be helpful for other community members to resolve the issue in case anyone faces in future. Thankyou.

Share via

Runtime error when running lookup in Azure data factory, pipeline

1 answer

Your answer