CODEWITHSUNDEEP
timeoutazure-data-factory
lachicazul
lachicazul

Reputation: 103

ADF - Script Activity - Timeout after 30 minutes

I have a couple of scripts activities and despite the default timeout setup enter image description here

It gets a timeout error after 30 minutes.

Any clue?

Upvotes: 1

Views: 4714

Answers (4)

OlehMrB
OlehMrB

Reputation: 21

Script activity timeout for executing script block is configurable now. For the newly created script activity, the default timeout is 120, but users can change the timeout according to their preference.

Parameter: Script block execution timeout.

enter image description here

Documentation: https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-script#inline-script

Resolved Github issue: https://github.com/MicrosoftDocs/azure-docs/issues/94986

Upvotes: 1

KyferEz
KyferEz

Reputation: 397

The Script Activity has a currently undocumented time limit of 30minutes. This cannot be changed and the Activity Timeout setting has no effect.

Upvotes: 2

Himanshu Kumar Sinha
Himanshu Kumar Sinha

Reputation: 1776

What is the timeout set on the source ? if it always timeout in 30 mins may be thats what is happening . For example you can set the timeout SQL like

USE AdventureWorks2012 ;
GO
EXEC sp_configure 'remote query timeout', 30 ;
GO
RECONFIGURE ;
GO

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-query-timeout-server-configuration-option?view=sql-server-ver16

Upvotes: 0

Abhishek Khandave
Abhishek Khandave

Reputation: 3230

We can use the Script activity to execute DML (Data Manipulation Language) statements like SELECT, INSERT, UPDATE, as well as DDL (Data Definition Language) statements like CREATE, ALTER, and DROP operations.

Currently, the Script activity supports the following data stores:

• Azure SQL Database

• Azure Synapse Analytics

• SQL Server Database

• Oracle

• Snowflake

The General section is similar to other activities with these items:

• Name - Name of the activity.

• Description - Comments about this activity (optional).

• Timeout - Timeout in D.HH:MM:SS format, the default timeout value is 7 days.

• Retry - Maximum number of retry values.

• Retry interval (sec) - Specify the number of seconds between each retry attempt, the default value is 30.

• Secure output - Output from the log file will not be captured if checked.

• Secure input - Input from the log file will not be captured if checked.

You need to check timeout settings at Source level.

Refer this article by Tech Zero

Upvotes: 0

Related Questions