SQL Server stored procedure call never ends

[amaaiia]

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 response from SQL Server.

I have checked the configuration of SQL Server itself, and I see that when I receive a request from Fabric, the call to the stored procedure never ends. However, if I launch the exact same stored procedure call from outside Fabric with the same user Fabric is using, it finishes in less than 10 seconds. The execution plan that is launched in the SQL is the same whether the call is made from Fabric or outside. I only get this issue with Fabric.

Has anyone else experienced this?

[v-cboorla-msft]

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]

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]

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]

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.

[amaaiia]

ticket 2406280050001028