topic Re: Lookup activity id undefined in Pipelines

Lookup activity id undefined

mwsmoley — Thu, 16 May 2024 14:36:22 GMT

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?

Sincerly,

Michal

Re: Lookup activity id undefined

v-cboorla-msft — Fri, 17 May 2024 08:32:09 GMT

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.

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.

Re: Lookup activity id undefined

mwsmoley — Fri, 17 May 2024 11:01:55 GMT

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.

Re: Lookup activity id undefined

v-cboorla-msft — Fri, 17 May 2024 15:59:53 GMT

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

Re: Lookup activity id undefined

v-cboorla-msft — Mon, 20 May 2024 16:52:23 GMT

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.

Re: Lookup activity id undefined

mwsmoley — Tue, 21 May 2024 12:41:44 GMT

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.

Re: Lookup activity id undefined

v-cboorla-msft — Mon, 27 May 2024 06:29:42 GMT

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.

Re: Lookup activity id undefined

v-cboorla-msft — Tue, 28 May 2024 05:46:02 GMT

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.