Forum Discussion

amaaiia's avatar
amaaiia
Skilled Sharer
2 years ago

SQL Server stored procedure call never ends

I have a connection created against a SQL Server on-prem through a data gateway. I can ingest tables normally but when ingesting data from a stored procedure it keeps loading and I never get a respon...
General Comment
General Question
v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi amaaiia 

 

Thanks for using Microsoft Fabric Community.

To ensure optimal performance, it would be beneficial to confirm the version of your on-premises data gateway?

If you are using an older version, upgrading to the latest release might improve the data ingestion process. 

For latest version of on-prem gateway please refer : On-premises data gateway

 

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

 

I hope this information helps.

 

Thank you.

 

 

 

  • amaaiia's avatar
    amaaiia
    Skilled Sharer
    2 years ago

    It's not data gateway issue. The query gets to SQL Server but the server is not responding. That is, the query request arrives to the server, and the server is not creating and sending an answer. The problem is not in the communication between Fabric and del SQL Server, it's in the SQL Server only when Fabric is the requester.

     

    The point is that this only happens when I run a query from Fabric, in other cases de stored procedure works well.

     

    By the way, gateway version is 3000.218.9

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

      Hi amaaiia 

       

      Apologies for the inconvenience.

      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.

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

        Hi amaaiia 

         

        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.

         

        Thank you.