Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mwsmoley
Helper I
Helper I

Lookup activity id undefined

Hello,

 

I have started experiencing an issue with Lookup actiivyt where they are all failing when connecting to a azure sql database with the error "Connection failed undefined. Acitivity ID: undefined." I have tried creating a new pipeline using a Lakehouse, Warehouse, Azure SQL Database, on prem database and all return the same error.  Has anyone else experience this and have a fix?

 

mwsmoley_0-1715870010493.png

 

Sincerly,

 

Michal

7 REPLIES 7
v-cboorla-msft
Community Support
Community Support

Hi @mwsmoley 

 

Thanks for using Microsoft Fabric Community.

The error "Connection failed undefined. Activity ID: undefined." in Microsoft Fabric Lookup activity connecting to an Azure SQL Database indicates an issue with establishing the connection.

I tried to replicate the scenario and didn't face any difficulty in setting up connection. Please find the screenshot for reference.

vcboorlamsft_0-1715934625057.png

Here are some troubleshooting steps that might help you.

Connectivity Issues: Check if there are any temporary network issues preventing communication between the Microsoft Fabric service and your Azure SQL Database. You can try refreshing the connection or restarting the workflow.

Verify Connection Details: Double-check the Azure SQL Database server name, username, password, and database name in the Fabric Lookup activity configuration. Ensure there are no typos or incorrect information.

Fabric Lookup Activity Configuration: Check the configuration settings in the Fabric Lookup activity. Ensure the connection information matches the Azure SQL Database details.

 

I hope this information helps. Please do let us know if you have any further queries.

 

Thank you.

Hello,

Thank you for the reply.  I do not believe this is related to a connection issue as this was happening on all connection types and instead of using the lookup I switched to useing scripts to not stop development and script activities are able to connect to the server just fine. Additionally I can connect using SSMS and Azure Data Studio.

Hi @mwsmoley 

 

There might be a chance of an intermittent issue could you please follow the below steps that might help you. 

Temporary Glitch: Clearing cookies and caches can sometimes resolve temporary glitches within the application that might be causing the issue.

Hard Refresh: A hard refresh bypasses the cached version of the webpage and forces the browser to download the latest version from the server. Press Ctrl+Shift+R (Windows) or Cmd+Shift+R (Mac).

 

If the issue still persists, please do let us know. Glad to help.

 

I hope this information helps.

 

Thank you

Hi @mwsmoley 

 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

 

Thanks.

I use Microsoft Edge and have it set to not save any history and delete all cookies, cache, images, etc on close.  At this point I have not checked to see if the issues has been resolved as I had to move on to conintue projects in alternative ways.

Hi @mwsmoley 

 

Apologies for the delay in response.

If the issue still persists. Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

 

Thank you.

Hi @mwsmoley 

 

We haven’t heard from you on the last response and was just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

 

Thanks.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayFBCUpdateCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.