May 9, 2024 at 6:05 pm
Dears,
We are using Azure Data factory pipes to run some stored procedures against a SQL Server Managed Instance in the cloud
Almost every day while running we receive the following error :
Error Message: Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 64. Error Message: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Sometimes its on one stored procedure, other times on other.. there are multiple stored procedures runed by this pipe
Issue detail:
The datawarehouse procedures are invoked by an ADF pipeline which runs every 15 minutes. We have single refresh per day for the underlying tables in the procedure. If the procedure fails the pipeline will re-trigger it after 15 mins.
However, we seem to face network connectivity issue at times when the procedures are invoked via ADF. This usually does not happen in the beginning of the run but in between. As a result we also lose out on time that it took to process the records partially. We say a network issue, because of type of error, maybe its not related at all with networking
I would appreciate if you can help understand what may be the root cause? can it be locks or deadlocks? can it be concurrency? can it be a network issue? Can it be timeouts?
How can we investigate?
Thanks a lot,
Pedro
May 10, 2024 at 11:00 am
Also interesting to state that the stored procedures have SET XACT_ABORT ON
May 28, 2024 at 10:07 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply