Forum Discussion

mwsmoley's avatar
mwsmoley
Helper II
2 years ago

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?

 

 

Sincerly,

 

Michal

Need Help
pipelines

7 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    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.

    • mwsmoley's avatar
      mwsmoley
      Helper II
      2 years ago

      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.

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Microsoft Employee
        2 years ago

        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