Pipeline activities failing with 'Failed to resolve connection ... referenced in activity run ...'

[gacurtin]

Hello, 

A few days ago my pipeline activities started failing with the following error:

Error Code: UserError

Failure Type: User Configuration Issue

Details: Failed to resolve connection [Connection ID] referenced in activity run [Activity ID]' 

Prior to seeing this error, the pipelines ran on schedule every night without any issue.  No changes were made to the source, destination or pipeline prior to experiencing this issue. I own the source, destination and pipeline.

To resolve the error, I have to go to each activity and run a test connection then rerun.  However, this solution only resolves the issue temporarily.  All failed activities are copy data activitities which have an Azure SQL Database as both the source and destination.  All the copy data activities in these pipelines run concurrently (as opposed to sequentially).  

So far I have tried:

o Creating new connections (issue remains)

o Rerunning Pipeline without testing connection (issue remains)

Does anyone know how to permanently resolve this issue?  Currently, it is taking hours everyday to run a test connection on every failed activity.

[Mauro89]

Hi @gacurtin, 

I faced the same issue. In my case what helped was to go to the acutal connection which is used in the activity.

There I checked the rights and renewed the connection credentials. This worked for me. Depending on your authentication type (OAuth, SP, WS Identity) this is worth giving a try.

Hope this helps!

Best regards!

PS: If you find this post helpful consider leaving kudos or mark it as solution

[chetanhiwale]

Hi @gacurtin ,

I also got the same error. For me by removing and attaching same connection and saving the pipeline worked for me. 

Steps :
Remove the connnection. 
Save the pipeline
Attach the same connection again.
Updating the creds with the same creds
Save the pipeline

[deborshi_nag]

Hello @gacurtin 

You can try the Fabric CLI to inspect your workspace items with missing connections. 

List all items first using:

fab get <workspace-name>.Workspace

For the items that you have issues with:

fab get .connections <item-path>

If there are no connection binding for the items, recreate them, and see if this issues disappears. 

Hope this helps, please appreciate giving a Kudos or accepting it as a Solution! 

[mnicnielsen]

I am facing the same error message. For me, it seems to reference the correct connection when I use the 'Preview' button, but then when I try to run the pipeline, it's trying to reference an old connection that no longer exists. Maddening!

[SivaReddy24680]

HIi @gacurtin 

I faced the same issue. I actually copied the copy activity from another pipeline and pasted in new pipeline and ran the new pipeline. When I re-build the copy activity, it went fine

[Anonymous]

I was able to fix by adjusting batch counts - was trying to load 55 tables simultaneously via same connection (something that can be done in ADF and Synapse). Adding a batch limit allowed for the pipeline to run..

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .