Synapse query failed after 6 minutes from Data factory

Jhonatan Reyes 61

Hi,

I'm using the copy activity to extract data from Synapse analytics (SQL DWH).

After exactly 6:38 minutes the query fails and the error is a Timeout Error.

If a run the query from ssms, works.

I set up the max time for query timeout:

HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2021-01-26T00:23:09.027+00:00

Hello @Jhonatan Reyes ,
Thanks for the ask and also using the forum .
Can you please share the exact error ?That will help .
I could also suggest you to please run a very simple query ( may be some top 100 records from a single table ) and see if that works .
Can you please share the runid with us ?

Thanks
Himanshu
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2021-01-27T19:31:48.737+00:00

Hello @Jhonatan Reyes ,

Since we have not heard back from you so I was checking if the above suggestion helped ?

If you found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Himanshu
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2021-02-02T17:27:22.957+00:00

Hello @Jhonatan Reyes ,

Since we have not heard back yet from you so I was checking if the above suggestion helped ?

If you found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Himanshu

Your answer