Azure SQL Database
An Azure relational database service.
6,332 questions
Solution i ended up using was the retry option in the lookup activity, along with specifying the seconds between each retry.
prevent timeout when connecting to paused azure sql database serverless
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 79%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
na
146
Reputation points
I have a linked service to an azure sql database on serverless.
The sql database auto pauses when not in use for a period of time.
The first connection to the database always fails, as the un-pause takes a number of minutes.
I added a connection property "connection timeout" with a value of 100000, but it still fails after about 30 seconds.
How can i ensure the connection to the paused azure sql database does not timeout while the database is un-pausing?
Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,632 questions
2 answers
Sort by: Most helpful
-
na 146 Reputation points
2022-05-30T08:12:01.507+00:00 -
PRADEEPCHEEKATLA 90,641 Reputation points Moderator2022-06-01T05:56:39.523+00:00 Hello @na ,
Glad to hear that your issue is resolved. Appreciate for sharing the resolution, this would certainly benefit other community members.
Sign in to comment -
-
Pratik Somaiya 4,211 Reputation points Volunteer Moderator2022-05-26T13:18:24.023+00:00 Hello @na
Instead of adding connection timeout property, I would recommend you to use Wait activity before the activity where you access synapse, this way your pipeline will trigger at your scheduled time but will wait for x number of time until Synapse is resumed
-
na 146 Reputation points
2022-05-26T13:20:42.957+00:00 Hi, thanks for the reply.
I am not using synapse, i am using azure sql database on serverless.
I cannot see how a wait activity will help.In order to un-pause the sql database, it needs to be contacted. once its contacted, the connection either works or times out, i cannot do a wait once the connection has been started.
-
Pratik Somaiya 4,211 Reputation points Volunteer Moderator
2022-05-30T07:23:50.457+00:00 Hello @na : Ok understood, after adding the connection timeout property as you did, are you able to see it reflecting in the pipeline JSON code post publishing?
-
na 146 Reputation points
2022-05-30T08:11:29.293+00:00 Hi, no the connection timeout property does not seem to work as i expected, and timeout still occurs after a few seconds.
The solution i ended up using was the retry option, specifying seconds between retries in the lookup activity.
-
Pratik Somaiya 4,211 Reputation points Volunteer Moderator
2022-05-30T08:45:19.25+00:00 Hello @na : Is the retry working correctly? But it might be failing your job for once atleast
Sign in to comment -