MSSQL only : some jobs time out after 600 min (How to set and check remote_query_timeout on MSSQL)

book

Article ID: 140534

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

We notice some of the long running jobs time out after few hours. What could be causing this? 

Environment

Release : All Supported Clarity releases with MSSQL (Sql Server) 

Resolution

This is caused by remote_query_timeout setting is not set up as per the Install Guide, it should be set to 0 (unlimited). This is a required setting for Clarity to properly work. 

 

To check the setting in SQL Management Studio UI 

1. Open SQL Management Studio - right-click on the Server Name - Properties

2. Go to Connections

3. See the setting for Remote Query Timeout, it should be 0


To change it modify and save

To check the current setting with a query:

Connect to the database (master as sa) and run:

sp_configure 'remote query timeout (s)'


To set the setting as required, run:

sp_configure 'remote query timeout',0 reconfigure with override